OBIEE - Repository Design

Bi Server Architecture With Client

Business Model



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


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


Discover More
Bi Server Architecture With Client
OBIEE - BI Server (OBIS|nqsserver|nqs)

OBI Server is also known as: OBIS (Oracle Business Intelligence Server) or nqsserver (The process name) OBI Server is principally a query and analysis server software: that can integrate data...

Share this page:
Follow us:
Task Runner