If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Currency Conversion

Started by bloggerman, 25 Apr 2011 04:21:39 AM

Previous topic - Next topic

bloggerman

Converted data at the lowest time level is stored in the cube. Is the roll up done and stored in the cube or is it done by Analysis Studio?

bloggerman

My guess is that its converted at the lowest level, rolled up at all levels and then stored in the cube. But, things i have read in the manual and at othe places left some scope for interpretation

Arsenal

rollup's at all levels for the dimensions (including time dimension levels such as day, Prior day, Prior Quarter etc.)  in the cube are created at the time of cube build and stored in the cube itself.
AS will issue MDX's to the cube based on how you're slicing and dicing, but the data will come from the cube