Essbase Transparent Partitioning Between 2 ASO Cubes Returns Warning "The Essbase cube has data, which will not be considered during query time." (Doc ID 1485924.1)

Last updated on AUGUST 08, 2016

Applies to:

Hyperion Essbase - Version 11.1.2.2.000 and later
Information in this document applies to any platform.
Transparent partition
Source App is ASO
Target App is ASO
***Checked for relevance on 28-Jan-2014***

Symptoms

 A transparent partition was created from one source ASO cube to another target ASO cube. Both cubes have exactly the same outline.

When validating the partition, this warning displays: "The Essbase cube has data, which will not be considered during query time."

The partition can still be saved with this warning. When querying the data, the data from the source cube can be seen through the partition. However, the data from the target cube is no longer showing. This would be normal if there would be an overlap between the 2 cubes. There is no overlap. This was even tried with 1 data cell. When the partition is removed, the data in the target cube becomes "visible" again.

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