COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => BI Modeling (Transformer) => Topic started by: bloggerman on 25 Apr 2011 04:21:39 AM

Title: Currency Conversion
Post by: bloggerman on 25 Apr 2011 04:21:39 AM
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?
Title: Re: Currency Conversion
Post by: bloggerman on 25 Apr 2011 06:33:22 AM
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
Title: Re: Currency Conversion
Post by: Arsenal on 25 Apr 2011 01:48:31 PM
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