SAP BI (IDT) Information Design Tool 4: Creating Business Objects Universes

SAP BusinessObjects BI IDT (Information Design Tool)

Create Exciting Dependable Universes

Create a universe on a hypothetical stock trading company that trades for one year. During this year the company buys and sells stocks, calls companies, and saves daily stock prices.

Chapter 1: Build a Basic Universe

• Create a one table universe. Create a Connection, a Data Foundation, and a Business Layer.
• Develop Dimensions and Measures that allow for creation of analytical reports.
• Focus on object creation and behavior independent of the complexities that additional tables add to a universe.

Chapter 2: Query Filters

• Query and Business Filters are explored and simple filters are introduced.
• Subqueries in both Query and Business Filters.
• Ranking Business Filters that return top or bottom values.
• Prompted filters.
• List of Values and Parameter objects.
• Date filters using SQL Server and Oracle functions are explained.

Chapter 3: Inserting Tables and Joins

• Supporting Dimension Tables.
• Dimension Objects.
• Organization of objects and how to determine their qualification.
• Chasm Traps that arise from adding additional tables.
• Since not every chasm trap is the same, four different solutions are presented.
• Creating and editing Joins
• Join Cardinality.
• Attribute objects and their purpose.
• Case Statements.
• Derived Tables & Summary Tables.

Chapter 4: Working with Multiple Fact Tables

• Multiple Fact Tables.
• Date Tables.
• Fact table Chasm Traps.
• Data Foundation and Business Layer Views.
• Defining and modifying Contexts
• Strategies on how to keep the designs simple and easy to understand.

Chapter 5: Data Complications

• Aggregated Fact Tables and Aggregate Awareness.
• Fan Traps developed by including Summary Tables.
• Solving Fan Traps with Aggregate Awareness.
• Point of View Fan Traps.
• Delegated Measures and how to use them with fan traps.

Chapter 6: Additional Topics

• Multisourced-Enabled Data Foundations.
• Index Awareness.
• Theta Joins.
• Managing the Table Map.
• Printing Reports.
• Security Editor.
• Data Security Profiles.
• Business Security Profiles.
• Net Profiles.

Just a Few Comments from Past Customers

• Goes through every single detail and possible challenges you could come across at every further step...