dbTalk Databases Forums  

Help...with a dynamic calc across a partition Essbase cube

comp.databases.olap comp.databases.olap


Discuss Help...with a dynamic calc across a partition Essbase cube in the comp.databases.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
teamsuperfan
 
Posts: n/a

Default 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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.