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
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
- 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
Prerequisites
-
Prior experience with Excel and SQL would be helpful, but not required.
Topics
- 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
Exam Terms & Conditions
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
Purchase Information
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.