Archive for 'OBIEE Repository' Category
Time Series Wizard in OBIEE
Time Series Wizard (Time Series Measure) Oracle BI Server provides Ago and ToDate functions for time series comparisons. There is no direst way in SQL to make time comparison so Oracle BI Server has provided these two functions for time series comparison. Time series measures ( Ago & ToDate ) are the best way to [...]
Multi User Development Environment(MUDE) In OBIEE
Multi User Development Environment (MUDE) Oracle BI repository development environment is not set up for multiple users. A more efficient development environment would permit developers to modify a repository simultaneously and then check in changes. This can be done by setting up the multi user environment using the Oracle BI Administration Tool to support concurrent [...]
BMM Layer – Important things
OBIEE Business Model & Mapping Layer (BMM) Layer Out of three layer of OBIEE repository I believe the most important one is the middle layers i.e BMM layer. There very interested things which we can do in this layer. 1) Create New Logical Columns 2) Complex Joins 3) Time Series Wizard 4) Level Based Measures 5) [...]
Hierarchy ( Dimensional Hierarchy) in OBIEE
Hierarchy Hierarchy: The specification of levels that represents relationship between different attributes within a dimension. For example, one possible hierarchy in the Time dimension is Year → Quarter → Month → Day. Dimensional Hierarchy in OBIEE First of all our first task is to thoroughly understand your business model. You have to understand what business [...]