Description

SAP BusinessObjects® Information Design Tool is a complementary tool to the Designer, allowing you to create universes based on several relational sources and/or on OLAP cubes. This course will teach you how to create enriched universes via the Information Design Tool module of the SAP BusinessObjects® BI 4 suite.

Who is this training for ?

For whom ?

Analysts and business experts, project management assistants.

Prerequisites

Training objectives

• Create a project with Information Design Tool
• Build a data foundation based on several relational connections
• Define a relational management layer and associated objects
• Organize security on the data for restitution
• Build queries on the data

Training program

• Introduction
  • Reminder about BI and the SAP BusinessObjects® company.
  • Principles of the Designer and the design tool.
  • The design stages.
• Information Discovery Design Tool
  • First connection to the application.
  • Creating a project.
  • The concept of sessions.
  • Repository resources.
  • Connection management.
  • Shortcuts.
  • Exercise: Creating a project.
  • Creating a connection based on E Mode data and an Excel file.
• Data Foundation
  • What is a data foundation? Principle.
  • Management of tables and joins, notions of optimization.
  • Presentation and management of views.
  • Families.
  • Data profiling.
  • Calculated and time columns.
  • Derived tables.
  • Exercise: Creating a multisource data foundation based on two connections.
• Creation of management layers
  • Creation of a relational management layer.
  • Creation of classes and objects.
  • Object properties.
  • Objects candidates.
  • The views of the management layer.
  • The format editor.
  • Exercise: Creating a relational management layer .
• Maintain and optimize the universes
  • The parameters of the universe.
  • Manage the structure, updating.
  • Check the integrity.
  • Resolving loops with aliases and contexts.
  • Object navigation paths.
  • Exercise: Using the integrity test on a universe with loops.
  • Resolution via context creation.
• Test and distribute the universes
  • Query editor overview.
  • How to create a query? Filtering data in a query.
  • Profiling values.
  • Publishing the universe.
  • Convert a file ".
  • unv" to ".
  • unx".
  • Exercise: Insert a query and use filters.
• Security management
  • Presentation of security issues.
  • Insertion and modification of a data and management security profile.
  • Assignment of security profiles to users.
  • Exercise: Create a management data security profile.
  • Assign security to a user.