OBIEE - Repository Design

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs)

1 - Business Model

3 - Others

Advertising

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

5 - 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
Advertising

6 - sav

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

7 - Reference