Currently Being Moderated

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.

 

You can submit and vote on ideas for enhancements to this product, or submit and vote on ideas for new tutorial topics or improvements to tutorial formats and delivery.

 

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

 

Key Concepts

  • NEW for 4.1  What's new in SAP BusinessObjects Information Design Tool 4.1 (5:50)     interactive / video
  • NEW for 4.0 FP3  What's new in SAP BusinessObjects information design tool 4.0 Feature Pack 3 (5:14)     interactive / video
  • 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

 

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 an SAP NetWeaver BW InfoProvider (2:07)     interactive / video
  • Create a relational connection to SQL Server using OLEDB providers (2:13)     interactive / video
  • Create a relational connection to an Excel spreadsheet or text file using ODBC drivers (2:38)     interactive / video
  • NEW for 4.0 FP3  Create a relational connection to an SAP ERP data source (1:45)     interactive / video
  • NEW for 4.0 FP3  Create an OLAP connection to an Oracle Essbase data source (1:39)     interactive / video
  • NEW for 4.1  Create a connection to an OData data source (1:32)     interactive / video
  • NEW for 4.1  Create an OLAP connection to an SAP HANA view (1:11)     interactive / video

 

Building the Structure of a Universe

 

Creating the Business Layer of a Universe

 

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

 

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
  • UPDATED for 4.0 FP3  Create a relational connection to SAP HANA (2:34)      interactive / video
  • UPDATED for 4.0 FP3  Create a data foundation based on an SAP HANA view (3:28)      interactive / video
  • UPDATED for 4.0 FP3  Create a business layer for a data foundation based on an SAP HANA view (4:42)      interactive / video
  • UPDATED for 4.0 FP3  Create a data foundation based on SAP HANA tables (4:52)       interactive / video
  • UPDATED for 4.0 FP3  Create a business layer for a data foundation based on SAP HANA tables (4:55)      interactive / video
  • UPDATED for 4.0 FP3  Modify parameters to optimize an SAP HANA universe (2:33)      interactive / video
  • UPDATED for 4.0 FP3  Create a relational connection to SAP HANA in the repository (3:09)     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

 

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

 

Setting up Aggregate Awareness

  • Insert aggregate tables into a data foundation (2:37)     interactive / video
  • Define aggregate aware objects in a business layer (5:51)     interactive / video
  • Set aggregation navigation in a business layer (2:38)     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
  • NEW for 4.0 FP3  Create a data security profile based on a custom user attribute (7:28)     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

 

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

 

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.

Delete Document

Are you sure you want to delete this document?