Official Product Tutorials – SAP BusinessObjects Information Design Tool

The following tutorials have been developed to help you get started using the Business Intelligence Suite products. New content is added as soon as it becomes available, so check back on a regular basis.

Are there topics we've missed or things we can improve? Submit new ideas or vote on existing ones to help us better address your learning needs for the BI Suite of products.

Looking for eLearning for the rest of the Business Intelligence Suite? Go to sap.com/LearnBI.

Key Concepts

• Concept: Navigate the interface (6:50)     interactive / video
• Concept: Create a universe (2:27)     interactive / video
• Concept: Create a multisource-enabled universe (3:23)     interactive / video
• Concept: Create joins (4:08)     interactive / video
• Concept: Compare the information design tool to the universe design tool     interactive

Getting Started

• Create a project (0:56)     interactive / video
• Create a connection to a relational database (2:02)     interactive / video
• Create a data foundation based on a single source relational database (2:35)     interactive / video
• Create a business layer based on a single relational data source (1:33)     interactive / video
• Publish a new universe file based on a single data source (2:33)     interactive / video
• Retrieve a universe from a repository location (1:49)     interactive / video
• Publish a universe to a local folder (1:25)     interactive / video
• Retrieve a universe from a local folder (1:20)     interactive / video
• Open a local project (1:29)     interactive / video
• Delete a local project (1:58)     interactive / video
• Convert a repository universe from a UNV to a UNX (4:04)     interactive / video
• Convert a local universe from a UNV to a UNX (3:01)     interactive / video

Connecting to Data Sources

• Create a connection shortcut (1:58)     interactive / video
• View and filter data source values in the connection editor (2:00)     interactive / video
• Create a connection to an OLAP data source (1:30)     interactive / video
• Create an OLAP connection to SAP BW using BICS (2:32)     interactive / video
• Create a relational connection to SQL Server using OLEDB providers (2:13)     interactive / video

Building the Structure of a Universe

• Arrange tables in a data foundation (1:52)     interactive / video
• View table values in a data foundation (1:11)     interactive / video
• View values from multiple tables in a data foundation (1:31)     interactive / video
• Filter table values in a data foundation (2:02)     interactive / video
• Filter values from multiple tables in a data foundation (2:49)     interactive / video
• Apply a wildcard to filter table values in a data foundation (2:14)     interactive / video
• Apply a wildcard to filter values from multiple tables in a data foundation (2:22)     interactive / video
• Sort and re-order table columns in a data foundation (1:14)     interactive / video
• Edit table values in a data foundation (2:06)     interactive / video
• Create an equi-join (2:12)     interactive / video
• Create a theta join (1:50)     interactive / video
• Create an outer join (3:17)     interactive / video
• Create a shortcut join (1:53)     interactive / video
• Create a self-restricting join using a column filter (2:11)     interactive / video
• Modify and remove a column filter (1:43)     interactive / video
• Detect join cardinalities in a data foundation (2:35)     interactive / video
• Manually set join cardinalities in a data foundation (1:30)     interactive / video
• Refresh the structure of a universe (2:41)     interactive / video
• Create a calculated column using string values (1:48)     interactive / video
• Create a calculated column using a date value (2:17)     interactive / video
• Create a calculated column using numeric values (1:57)     interactive / video

Creating the Business Layer of a Universe

• Create business layer folders (1:49)     interactive / video
• Create business layer subfolders (1:58)     interactive / video
• Create a business layer folder and objects automatically from a table (1:47)     interactive / video
• Create a business layer subfolder and objects automatically from a table (1:53)     interactive / video
• Create dimension objects automatically from a table (2:08)     interactive / video
• Create a dimension (1:42)     interactive / video
• Create an attribute (1:30)     interactive / video
• Create a measure (2:27)     interactive / video
• Hide folders and objects in a business layer (1:34)     interactive / video
• Organize folders and subfolders in a business layer (2:18)     interactive / video
• View table and object dependencies (1:33)     interactive / video
• Create a custom navigation path (2:39)     interactive / video
• Create a dimensional business layer from an OLAP data source (1:44)     interactive / video
• Copy and paste folders and objects in a business layer (1:49)     interactive / video

Filtering Data in Objects

• Create a pre-defined native filter (2:09)    interactive / video
• Create a pre-defined business filter (2:05)     interactive / video
• Create a pre-defined native filter using multiple objects (2:46)     interactive / video
• Create a pre-defined business filter using multiple objects (2:52)     interactive / video

Working with Derived Tables

• Create a derived table based on an existing table in a data foundation (3:09)     interactive / video
• Create a derived table using the SQL Builder (3:03)     interactive / video
• Merge tables in a data foundation (1:48)     interactive / video

Visualizing Data in a Universe

• Run a business layer query (2:06)     interactive / video
• Edit a business layer query (3:14)    interactive / video
• Run a business layer query with pre-defined filters (3:23)     interactive / video
• Profile column values in a chart (1:53)     interactive / video

Connecting to SAP HANA

• Create a relational connection to SAP HANA (2:54)      interactive / video
• Create a data foundation based on an SAP HANA view (3:45)      interactive / video
• Create a business layer for a data foundation based on an SAP HANA view (6:45)      interactive / video
• Create a data foundation based on SAP HANA tables (5:33)       interactive / video
• Create a business layer for a data foundation based on SAP HANA tables (4:43)      interactive / video
• Modify parameters to optimize an SAP HANA universe (2:57)      interactive / video
• Create a relational connection to SAP HANA in the repository (3:22)     interactive / video

Building a Multi-Source Universe

• Create a data foundation based on multiple MS Access connections (3:55)     interactive / video
• Create a data foundation based on multiple RDBMS connections (4:06)    interactive / video
• Add a connection to an existing multisource-enabled data foundation (2:32)    interactive / video
• Create calculated columns in a multisource-enabled data foundation (5:08)     interactive / video
• View values from multiple tables in a multisource data foundation (1:56)     interactive / video
• Create a business layer based on a multisource MS Access data foundation (2:02)     interactive / video
• Create a business layer based on a multisource RDBMS data foundation (2:06)      interactive / video
• Run a query using objects from a multisource business layer (2:17)     interactive / video

Working with Parameters and Lists of Values

• Create a list of values based on query results of business objects (2:18)     interactive / video
• Create a list of values based on a hierarchy of business layer objects (2:12)     interactive / video
• Create a static list of values (2:05)     interactive / video
• Create a list of values based on a SQL expression (2:36)     interactive / video
• Assign a list of values to a business layer object (1:25)     interactive / video
• Create a parameter (2:01)     interactive / video
• Assign a parameter to a business layer object (1:57)     interactive / video
• Test a parameter in a query (1:58)     interactive / video

Resolving Loops in a Universe

• Resolve a loop by automatically inserting an alias table in a data foundation (4:18)     interactive / video
• Resolve a loop by manually inserting an alias table in a data foundation (4:22)     interactive / video
• Resolve a loop by automatically inserting contexts in a data foundation (3:38)     interactive / video
• Resolve a loop by manually inserting contexts in a data foundation (5:04)     interactive / video

Applying Index Awareness

• Set up primary key index awareness (2:59)     interactive / video
• Set up foreign key index awareness (3:31)     interactive / video
• Apply a WHERE clause restriction to a primary key index (3:09)     interactive / video
• Apply a WHERE clause restriction to a foreign key index (3:50)     interactive / video
• Set up multiple foreign key index awareness (3:50)     interactive / video

Securing Universes

• Create a data security profile for connection and query options (5:33)     interactive / video
• Create a data security profile that restricts access to specific rows (3:36)     interactive / video
• Create a data security profile that defines replacement tables (3:54)     interactive / video
• Create a business security profile for query data (4:05)     interactive / video
• Create a business security profile for filtered data (3:50)     interactive / video
• Create a business security profile for display data (3:37)     interactive / video
• Assign security profiles to users (7:41)     interactive / video
• Assign security profiles to a group (3:08)     interactive / video
• Test data security profile aggregation (3:43)     interactive / video
• Test business security profile aggregation (4:11)     interactive / video
• Test a combination of business and data security profile aggregation (4:58)     interactive / video

Managing and Deploying Universes

• Identify local dependencies between universe resources (2:38)     interactive / video
• Run an integrity check on a universe (3:31)     interactive / video
• Insert a comment box in a data foundation view (1:35)     interactive / video
• Apply color to tables that share the same information (2:58)     interactive / video
• Organize a business layer with business layer views (1:32)     interactive / video
• Create a custom data foundation view (2:19)     interactive / video
• Create a custom data foundation view based on a selection of tables (2:06)     interactive / video

Interacting with the BI Platform

• Open a session to a CMS system (2:02)     interactive / video
• Close, re-open, and delete a CMS session (1:55)     interactive / video
• Create a shared project (1:17)     interactive / video
• Rename a shared project (1:46)     interactive / video
• Synchronize a project (2:19)     interactive / video
• Lock and unlock a shared resource (3:01)     interactive / video
• Retrieve shared resource changes from the server (2:16)     interactive / video
• Delete a shared project (1:35)     interactive / video

To view the full IDT 4.0 playlist on Youtube, click here.

To report a technical issue with a tutorial, send an email to: BI_Suite_eLearning@sap.com.