Information Design Tool Workshop
Workshop Description
This three day SAP BusinessObjects Information Design Workshop (formerly the universe design course) provides all the skills needed to design, build and maintain a BusinessObjects universe.
Delegates will learn information design concepts and terminology as well as the role of universes in relation to BusinessObjects reporting tools, the course provides an overview of the process of planning, designing and creating a universe, and then walks through the process of designing a universe that responds to identified user requirements.
The new Information Design Tool allows multiple connections based on relational or flat file sources all within one single data foundation.
Through well-designed universes, report designers and business users will be able to create their own reports without having to know anything about the underlying data source or structure. Through a Master Business Layer or specific Business Layer Views, the report writer or consumer has seamless access to their required data through Business Language Objects that may well exist in different disparate sources and technologies.
Topics Covered
Understanding BusinessObjects Universes and Information Designer
- Understanding how universes allow users to query databases using their business terms
- Understanding the unx structures and terminologies
- Brief navigation of projects
Creating Projects and Connections
- The course database and universe
- Creating a project
- Creating and publishing multiple connection (relational, csv and xls)
Building the Data Foundation Layer
- Populating the data foundation with tables from disparate sources
- Defining joins within the data foundation layer
Creating the Business Layer
- Understanding classes/folders and objects
- Creating folders, dimension and attribute objects
Creating Measure Objects
- Understanding measure objects
- Creating measure objects
Resolving Loops in a Universe
- Resolving loops using aliases
- Resolving loops using shortcut joins
- Resolving loops using contexts
Resolving SQL Traps
- Resolving chasm traps
- Resolving fan traps
Applying Restrictions on Objects
- Restricting the data returned by objects
Using Functions with Objects
- Using @ Functions
Using Lists of Values
- Working with LOVs in Designer
- Creating a cascading LOV
Using Navigation Paths
- Working with Navigation Paths (hierarchies)
Aggregate Awareness
- Applying aggregate awareness to objects
Creating Business Layer Views
- Creating different views of the available objects for personalization to groups and users
Managing Security
- Understanding the vast and tighter security setting in the Information Design Tool.
Deployment Considerations
- Understanding a multi user project environment
- Use of LCM or the Import Wizard with Universes
Designing an OLAP Universe
- Configure connectivity to an OLAP Source
- Discuss OLAP connectivity considerations
- Creating an OLAP Universe
On completion delegates will be able to:
- Understand the role of the SAP BusinessObjects information designers
- Assist in creating a more user friendly, flexible and effective universes
Workshop Style
- A large percentage of this workshop is practical based. Delegates will carry out activities throughout the workshops that are relevant to the BusinessObjects environment using a purpose-built training database.
Audience
This workshop is designed for information designers, new to SAP BusinessObjects Information designer, who need to design, build, document, maintain, and distribute BusinessObjects universes.
Pre requisite Knowledge, Experience and Education
- Exposure to SQL
Delivery & Duration
This is a 3 day, instructor led training workshop and can be delivered either on your site or at our training suite in Birmingham.
Request More Information
For more information regarding this workshop, please call today 0845 124 9495 and speak to one of our team or complete our short form below.
