title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
SAP Information Design Tool
Duration
2 Days
Course
ADSAP-100-NO
Available Formats
Classroom Training, Online Training
Course Description
Overview
This course prepares employees for using SAP Information Design Tool (IDT) to create BusinessObject universes. Topics to be covered include universe creation, creating relational database connections, creating Data Foundations, creating Business Layers, folders and objects, filters, table aliases, aggregate awareness, viewing table keys, publishing and securing universes, index awareness and universe maintenance.The course includes hands-on exercises in using IDT to create universes. The lab data is designed to provide exposure to a range of realistic scenarios.
Objectives
Upon completion of the SAP Information Design Tool course, students will be able to:
- Explain the concept of a BusinessObjects universe.
- Explain the purpose of Information Design Tool.
- Describe the process of creating Single and Multiple Source connection universes.
- Create Data Foundations.
- Create Business Layer views.
- Create folders and objects.
- Create dimensions, attributes, and measures.
- Create filters within the different layers.
- Using queries to test the Business layer.
- Publish universes for use by other BO products.
Audience
Business analysts that need to create the BusinessObjects connections, data foundations and business layers as an interface to the data in a data warehouse, data mart, or database.
Prerequisites
-
Prior experience with Excel and SQL would be helpful, but not required.
Topics
Getting Started with IDT
- What is IDT?: Basic Architecture, Infrastructure, Defining Layers, Definitions Review, Universe Development Process
- Executing IDT
- Using IDT: The IDT User Interface, Setting Preferences, Online Help
- Creating Local Projects
- Defining Connections
- Setting Connection Parameters
- Using the Connection Editor
- Publishing Connections
- Creating the Data Foundation
- Inserting Database Tables
- Displaying Table Properties
- Displaying Column Properties
- Detecting/Setting Keys
- Counting Table Rows
- Profiling Column Values
- Creating Calculated Columns
- Creating Time Columns
- Inserting Derived Tables
- Defining Joins
- Resolving Loops: Alias Tables, Contexts
- Checking Data Foundation Integrity
- What is a Business Layer?
- Components of a Business Layer
- Creating a Business Layer
- Inserting Folders
- Inserting Dimensions
- Inserting Attributes
- Inserting Measures
- Turning Measures and Attributes into Measures
- Specifying Display Formats
- Creating Query Objects
- Testing the Business Layer
- Checking Business Layer Integrity
- Creating Filter Objects
- Object vs. Universe Level Filters
- Optional and Mandatory Filter Settings
- Setting/Deleting Column Filters
- Filter Testing
- Creating and Implementing Custom Lists of Values
- Creating and Implementing Parameters
- Publishing a Local Universe
- Publishing a Universe to a Repository
Related Courses
-
SAP Web Intelligence
ADSAP-105-NO- Duration: 2 Days
- Delivery Format: Classroom Training, Online Training
- Price: 1,230.00 EUR
-
SAP Lumira
ADSAP-110-NO- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 1,850.00 EUR
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart