Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Analysis Studio => Topic started by: terry_stjean on 01 Dec 2007 05:05:03 PM

Title: Calculations between measures of different measure sets
Post by: terry_stjean on 01 Dec 2007 05:05:03 PM
I have 2 summary tables for Sales data, one is summarized for MTD and the other for YTD.
In Framework Manager, I have created each as it's own measure set.
ex. MTD Sales
           MTD Cases
           MTD Sales $
     YTD Sales
           YTD Cases
           YTD Sales $
In Analysis studio, I can add the MTD Sales $ and YTD Sales $ measures from each of the measure Sets to the columns of the report so I can see both MTD and YTD Sales, however it does appear I can do a calculation between the 2 measures. ex YTD Sales$ - MTD Sales$
Am I missing something?
Is it something I need to change in Framework Manager?
Title: Re: Calculations between measures of different measure sets
Post by: rockytopmark on 02 Dec 2007 02:30:43 PM
Not sure if you can.  I'd guess that there is no scope between the YTD summary table and the MTD dimension, and vice-versa.
Text only | Text with Images