Help...with a dynamic calc across a partition Essbase cube -
02-22-2006
, 11:56 AM
Hello,
I am trying to figure out a solution for dynamic calc that does not
properly retrieve when pulling data across a partitioned cube.
I have a target cube and 2 source cubes. The source cubes are split by
fiscal year with the most recent 3 years loaded in one cube and 4 years
back and prior loaded in the other.
Example: the dynamic calc is coded to pull the last month of fiscal
year in one source cube and sum it to one month of a fiscal year in the
other source cube. The retrieve properly pulls data from one cube, but
fails to pull the data from the other cube. The it does the sum, it
only has one of the 2 pieces needed.
This dynamic calc works for all fiscal years except the year the
requires the calc to cross the partitioned cubes.
Any tips would be appreciated...thanks in advance. |