OBIEE - Repository Design

Business Model

• OBIEE - Fact table (of logical fact table)
  • OBIEE - Identifying a Fact Table
  • OBIEE - Defining the Logical Key of a Fact Table
  • OBIEE - Aggregate Navigation with level-based fragmentation
  • OBIEE - How to create a measure from data that is stored in a dimension table
  • Search
  • OBIEE - Defining a Non-Aggregated Measure (Baseline column) of a Fact Table
  • …

• OBIEE - Dimension (Logical Table)
  • OBIEE - Configure Level Number of Elements in Dimensional Hierarchies
  • OBIEE 10G/11G - How to set up the time dimension (for time series functions Ago, Todate, ) ?
  • ..

• OBIEE - How to model the different relationships ?
  • OBIEE 10G/11G - How to model a bridge table (Many-to-Many relationship) with the joins property of a Logical Table ?
  • OBIEE 10G - How to define a Many-to-Many relationship with a Bridge table ?
  • OBIEE - Joins definitions in the repository (complex, foreign, logical table source)

• OBIEE - Densification / Dimensions Preservation Possibilities

• OBIEE - Federated Query / Multi-Database or Cross-Database Join
• OBIEE - Federated Query with Excel Sheet

Articles Related

Others

• OBIEE - How to define OBIEE to leverage SQL OLAP Query ?
• OBIEE - Expression Builder
• Obiee - How to create a dummy table ?
• OBIEE - SAP BW

Quotes

A consideration to take when designing a subject area is to pay attention at the final user. Do you design for a user:

• that will use answer to perform ad hoc queries
• or who will interact with the metadata via logical sql, dashboard and prompts.

Design Concept

• Numerous logical aggregations
• Time series and Rolling X Months
• Variations, Time Span Variations, and Compounded Variations
• Run Rates and Percent of Periods
• Grain Fragmentation
• Multi Physical Sourcing
• Dimensional Snowflaking
• Canonical Time Construct (Multi LTS Facts tables)
• Data Security, Projects, and Segmentation Metadata

sav

The rpd.sav is just an rpd file that have been copied during the start process of BI Server (OBIS).

Reference

• OBIEE Analytics/Reporting Solutions for E-Business Suite by Shyam Varan Nath