1Z0-591 · Question #20
What is the first step when creating an Aggregate table in the OBI repository?
The correct answer is B. Specify the Fact table that you want to aggregate. Steps for Creating Aggregate Tables in OBIEE 1. Create all Dimension Tables, Fact Tables & Hierarchies, which are required to be aggregated. 2. Go to ToolsàUtilities (from Administration tool menu bar), a dialog box will pop up with all available utilities. 3. Select Aggregate…
Question
What is the first step when creating an Aggregate table in the OBI repository?
Exhibit
Options
- ATest the Aggregate table by using Analysis
- BSpecify the Fact table that you want to aggregate
- CUse Job Manager to run the Aggregate script
- DCreate a dedicated Connection Pool
How the community answered
(34 responses)- A15% (5)
- B76% (26)
- C6% (2)
- D3% (1)
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 ToolsàUtilities (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.
Topics
Community Discussion
No community discussion yet for this question.