Using Cognos Express 10.2.1 reading from TM1 cube
I have to create a crosstab report as follows
Month1 Month2 Month3 Month4
Retail 0 3 2 4
Stock 8 5 3
Measures 3 2 1
Measures is a query calculation that looks at the stock (for Month1 8) and calculates how many months retail will be covered (ie Month1 Month2 Month3 and gives the no of months in this case 3
My report looks like this
< #Month#>
Retail
Stock
Measures
Month is a level of many members a filter picks out the current year's months
I have tried tuple sets but with no success
I guess you would have an if else statement like this
if (value (tuple([period], [retail], [ month 1]) < value (tuple ([period], [Stock], Month1) them Measures = 1
else
if (value (tuple([period], [retail], [ month 2]) < value (tuple ([period], [Stock], Month 2) them Measures = 2....
It is how to reference Month 1 2, 3, 4 etc that is causing me a problem
any ideas gratefully received
I solved this by doing the calculation in the TM1 cube