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