SAP Business Objects 4.2 Information Design Tool

Business Applications

Course Description

SAP Business Objects Information Design Tool (IDT) training teaches attendees Universe creation and how to implement relational database connections, Data Foundations, Business Layers, Folders, objects, and more. Students also learn how to publish, secure, and maintain Universes.

3 Days

  • Create Single and Multi-Connection Universes
  • Incorporate Data Foundations
  • Create Business Layer Views
  • Add Folders and Objects
  • Create Dimensions, Attributes, and Measures
  • Implement Filters within the different layers
  • Implement Aggregate Awareness
  • Use Queries to test the Model

  • Application Consultant
  • Data Consultant / Manager
  • Database Administrator
  • Developer
  • Developer Consultant
  • System Administrator
  • System Architect
  • Technology Consultant

  • Basic familiarity with Windows Environment
  • Knowledge of RDBMS is helpful

Day 1

Module: Information Design Tool

  • Introduction to the Information Design Tool
  • Creating the Data Foundation
  • Creating a Business Layer
  • Resolving Loops in a Universe
  • Applying Restrictions
  • Using List of Values and Parameters

Module: Key Concepts

  • What's new in SAP BusinessObjects Information Design Tool 4.2
  • Concept: Navigate the interface
  • Concept: Create a universe
  • Concept: Create a multisource-enabled universe
  • Concept: Create joins
  • Concept: Compare the information design tool to the universe design tool

Module: Getting Started

  • Create a project
  • Create a connection to a relational database
  • Create a data foundation based on a single source relational database
  • Create a business layer based on a single relational data source
  • Publish a new universe file based on a single data source
  • Retrieve a universe from a repository location
  • Publish a universe to a local folder
  • Retrieve a universe from a local folder
  • Open a local project
  • Delete a local project
  • Convert a repository universe from a UNV to a UNX
  • Convert a local universe from a UNV to a UNX

Module: Connecting to Data Sources

  • Create a connection shortcut
  • View and filter data source values in the connection editor
  • Create a connection to an OLAP data source
  • Create an OLAP connection to SAP BW using BICS
  • Create a relational connection to SQL Server using OLEDB providers
  • Create a relational connection to an Excel spreadsheet or text file using ODBC drivers
  • Create a connection to an OData data source
  • Create an OLAP connection to an SAP HANA view

Module: Building the Structure of a Universe

  • Arrange tables in a data foundation
  • View table values in a data foundation
  • View values from multiple tables in a data foundation
  • Filter table values in a data foundation
  • Filter values from multiple tables in a data foundation
  • Apply a wildcard to filter table values in a data foundation
  • Apply a wildcard to filter values from multiple tables in a data foundation
  • Sort and re-order table columns in a data foundation
  • Edit table values in a data foundation
  • Create an equi-join
  • Create a theta join
  • Create an outer join
  • Create a shortcut join
  • Create a self-restricting join using a column filter
  • Modify and remove a column filter
  • Detect join cardinalities in a data foundation
  • Manually set join cardinalities in a data foundation
  • Refresh the structure of a universe
  • Create a calculated column using string values
  • Create a calculated column using a date value
  • Create a calculated column using numeric values

Module: Creating the Business Layer of a Universe

  • Create business layer folders
  • Create business layer subfolders
  • Create a business layer folder and objects automatically from a table
  • Create a business layer subfolder and objects automatically from a table
  • Create dimension objects automatically from a table
  • Create a dimension
  • Create an attribute
  • Create a measure
  • Hide folders and objects in a business layer
  • Organize folders and subfolders in a business layer
  • View table and object dependencies
  • Create a custom navigation path
  • Create a dimensional business layer from an OLAP data source
  • Copy and paste folders and objects in a business layer

Day 2

Module: Filtering Data in Objects

  • Create a pre-defined native filter
  • Create a pre-defined business filter
  • Create a pre-defined native filter using multiple objects
  • Create a pre-defined business filter using multiple objects

Module: Working with Derived Tables

  • Create a derived table based on an existing table in a data foundation
  • Create a derived table using the SQL Builder
  • Merge tables in a data foundation

Module: Visualizing Data in a Universe

  • Run a business layer query
  • Edit a business layer query
  • Run a business layer query with pre-defined filters
  • Profile column values in a chart

Module: Building a Multi-Source Universe

  • Create a data foundation based on multiple MS Access connections
  • Create a data foundation based on multiple RDBMS connections
  • Add a connection to an existing multisource-enabled data foundation
  • Create calculated columns in a multisource-enabled data foundation
  • View values from multiple tables in a multisource data foundation
  • Create a business layer based on a multisource MS Access data foundation
  • Create a business layer based on a multisource RDBMS data foundation
  • Run a query using objects from a multisource business layer

Module: Working with Parameters and Lists of Values

  • Create a list of values based on query results of business objects
  • Create a list of values based on a hierarchy of business layer objects
  • Create a static list of values
  • Create a list of values based on a SQL expression
  • Create an index-aware prompt
  • Assign a list of values to a business layer object
  • Create a parameter
  • Assign a parameter to a business layer object
  • Test a parameter in a query

Module: Resolving Loops in a Universe

  • Resolve a loop by automatically inserting an alias table in a data foundation
  • Resolve a loop by manually inserting an alias table in a data foundation
  • Resolve a loop by automatically inserting contexts in a data foundation
  • Resolve a loop by manually inserting contexts in a data foundation

Day 3

Module: Applying Index Awareness

  • Set up primary key index awareness
  • Set up foreign key index awareness
  • Apply a WHERE clause restriction to a primary key index
  • Apply a WHERE clause restriction to a foreign key index
  • Set up multiple foreign key index awareness

Module: Setting up Aggregate Awareness

  • Insert aggregate tables into a data foundation
  • Define aggregate aware objects in a business layer
  • Set aggregation navigation in a business layer

Module: Securing Universes

  • Create a data security profile for connection and query options
  • Create a data security profile that restricts access to specific rows
  • Create a data security profile that defines replacement tables
  • Create a data security profile based on a custom user attribute
  • Create a business security profile for query data
  • Create a business security profile for filtered data
  • Create a business security profile for display data
  • Assign security profiles to users
  • Assign security profiles to a group

Module: Managing and Deploying Universes

  • Identify local dependencies between universe resources
  • Run an integrity check on a universe
  • Insert a comment box in a data foundation view
  • Apply color to tables that share the same information
  • Organize a business layer with business layer views
  • Create a custom data foundation view
  • Create a custom data foundation view based on a selection of tables

Module: Interacting with the BI Platform

  • Open a session to a CMS system
  • Close, re-open, and delete a CMS session
  • Create a shared project
  • Rename a shared project
  • Synchronize a project
  • Lock and unlock a shared resource
  • Retrieve shared resource changes from the server
  • Delete a shared project