COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => BI Modeling (Transformer) => Topic started by: cogcurious on 07 Apr 2012 03:32:50 AM

Title: Ratios in transformer
Post by: cogcurious on 07 Apr 2012 03:32:50 AM
Do we keep ratios as measures in cubes or do we keep the pieces and then calculate the ratio in the report

so if A=b/c then do we have A in the cube or just b and c and then  calculate A in the report
Title: Re: Ratios in transformer
Post by: cognostechie on 09 Apr 2012 03:59:01 PM
You can do that in the cube also but that is a generic answer. Typically, calculated mesures are created in Transformer only when you have to calculate something from different data sources. If the columns required for the calculation are present in the same data source (Query subject) it is preferable to do that in the Query itself.