Remove Unnecessary Solve For Leaf Partitions (Doc ID 1344869.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle OLAP - Version: 11.1.0.6 to 11.2.0.2 - Release: 11.1 to 11.2
Information in this document applies to any platform.

Symptoms

When the relation is changed and values are not changed, the compressed composite uses full build instead of incremental, and remove unnecessary solve for leaf partitions.

For example:

1) Use the sample project
2) Partition the Cube by Time at Month Level
3) Build and Aggregate the Cube
4) Add a new member to the Channel Dimension. Ensure that the new member does not affect the existing partition of the cube.
5) Load (with data that affect only latest partition) and aggregate the cube.
6) All partitions of the cube are re-aggregated (as a new member was added to non-partitioned dimension, namely Channel).
7) The cubes are fairly huge and the time it takes to re-aggregate the partition is fairly significant
(even though the existing data is not affected by new member) and the time taken is can be the same as a full solve.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms