What is the first step when creating an Aggregate table in the OBI repository?
A.
Test the Aggregate table by using Analysis
B.
Specify the Fact table that you want to aggregate
C.
Use Job Manager to run the Aggregate script
D.
Create a dedicated Connection Pool
Explanation:
Steps for Creating Aggregate Tables in OBIEE
1. Create all Dimension Tables, Fact Tables & Hierarchies, which are required to be aggregated.
2. Go to ToolsUtilities (from Administration tool menu bar), a dialog box will pop up with all
available utilities.
3. Select Aggregate Persistence Wizard, and then click Execute Button.
4. Now Select appropriate path where you need to generate Aggregate Table SQL.
Note : Click Generate DDL file for first time generation of Aggregate Table
Click Next, to move to next page (Select Business Model & Measure Page)
In Select Business Model & Measure Page, Select Appropriate Business Model & then select
associated Fact / Measure.Etc.
B
(1) create the logical dimension and Fact in BMM
(2) create the aggregate table(dimension & fact) in underlying database, manually or VIA obiee aggregate table persistence tool
(3) drag the aggregate table(dimension & fact) into the existing BMM logical table
(4) set the logical level and aggregate content group by on the level on which the aggregation table is on