Google+ Facebook Twitter MySpace SC

Friday, September 21, 2012

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

  • NEW for 4.0 FP3  Concept: 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
  • 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
  • Create a relational connection to an Excel spreadsheet or text file using ODBC drivers (2:38)     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

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

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
  • 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


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

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)