Persistence of Aggregate and Detail Data

Assuming that you selected a main record and aggregate record in the cube collection, Analytic Calculation Engine uses these records to persist aggregate data and detail data:

• Tree data.

  Tree data includes:

  • Aggregate data:

    Analytic Calculation Engine persists aggregate data in the aggregate record.

    Note:

    Records that are used as aggregate records should be read after records that are used as main records.

    See Synchronization Order.

  • Pushed down data.

    Analytic Calculation Engine creates detail data out of pushed down aggregate data. For this reason, Analytic Calculation Engine persists this data in the main record.

    See Pushed Down Data.

• Detail data.

  Detail data is data that cannot be broken down any further. Analytic Calculation Engine persists detail data to the main record.

  A detail member is generated out of one value of detail data in the database.