When creating Aggregate tables in the OBI repository by using the Aggregate Persistence Wizard, which...

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 they’re used when appropriate.

C: The wizard then shows me a preview of the script it’s going to generate, and asks me if I want to create any more summaries. Here’s how the preview script looks – note that it’s not SQL, it’s 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";