Which OBIEE capability enables developers to build Aggregate tables?
A.
Aggregate Persistence Wizard
B.
Expression Builder
C.
Table Builder
D.
Query Analyzer
Explanation:
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.
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