When creating Aggregate tables in the OBI repository by using the Aggregate Persistence Wizard,
which two statements are true?
A.
The analyst must first write DML (Data Manipulation Language) scripts to create the aggregate
table.
B.
The Aggregate Persistence Wizard enables you to automate the creation of physical aggregate
tables and their corresponding objects in the repository.
C.
Job Manager can be used to run the Aggregate Persistence script.
D.
The Extraction Transformation and Loading process creates the aggregate tables.
Explanation:
B: The Aggregate Persistence Wizard automates the creation and initial population
of aggregates, persists them in a back-end database and configures the BI Server metadata layer
so that theyre used when appropriate.
C: The wizard then shows me a preview of the script its going to generate, and asks me if I want
to create any more summaries. Heres how the preview script looks note that its not SQL, its a
script language that the BI Server understands and uses as the specification for an aggregation
job, which it then turns into separate CREATE TABLE, INSERT SELECT and so on SQL
statements, optimized for the particular back-end database platform.
Script example:“ag_Items”
for “Seminar – Complete”.”Items”(“Quantity”)
at levels (“Seminar – Complete”.”Customerdim”.”State”, “Seminar -Complete”.”Productdim”.”Category”, “Seminar – Complete”.”Timedim”.”Year”)
using connection pool “custdw”.”CUSTDW_Pool”
in “custdw”..”CUSTDW”;
B & D (Not B & C)
It is B and C
official answer is correct( B and C)
D can not be the answer as there is no role of ETL in generating Persistent Aggregate table .
Although the best way to generate aggregate table is to have it created in Datawarehouse and get it populate freshly through ETL after daily run .
http://www.rittmanmead.com/2007/10/using-the-obiee-aggregate-persistence-wizard/
(1) run tool->utility->aggregate wizard to generate script
(2) run nqcmd.exe to generate database aggregate table and obiee physical layer/bmm layer logical table, logical dimension, logical level, aggregate content on level
:\product\OracleBI\server\Bin>nqcmd.exe -u Administrator -p Administrator -d an
alyticsweb -s c:\agg_wiz_script.sql
The Aggregate Persistence Wizard enables you to automate the creation of physical aggregate tables and their corresponding objects in the repository. The Aggregate Persistence Wizard creates an Oracle BI Enterprise Edition SQL script, which is executed by the BI Server. The script specifies each aggregate table to be created, the facts from the business model that should be included in it, and its dimensions and grain. When the BI Server runs the aggregate persistence SQL script, it generates DDL to create the required tables in the target database, internal instructions to generate the corresponding physical and aggregate navigation metadata, and data manipulation language (DML) to aggregate and load data from the base tables into the aggregate tables. The aggregate persistence script is intended to be run after each extraction, transformation, and loading (ETL) of the base tables, typically nightly. This can be done by an Oracle BI EE Job Manager job, or it can be run as a .bat or any other script called by a custom program.
Create Aggregates Using Aggregate Persistence Wizard in Oracle BI 11g
http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi11117/agp/agr.html