Hello
in Cognos 10.1.1 i can't calculate 2 date members in a crosstab after drill-down.
My Crosstab looks like this:
Revenue
--------------------------------------
Company Month last year 1900,00
Month 900,00
--------------------------------------
difference -1000,00
Month is a dataitem '[CUBE].[Date].[Date]-> ?P_Month?'
Month last year is a dataitem 'lag([Month]; 12)'
difference is '[Month] - [Month last year]'
DateDimension: Date->Date->Year->Qua->Month->Day
The report works fine and in Cognos 8.4 complete but after drill down by 'Month last year' or 'Month' an error accours in Cognos 10.1.1.
QE-DEF-0480 The operands of [Month] - [Jun./2011] cannot be converted to consistent dimensional object.
It should be:
01/06/2011 20,00
02/06/2011 399,30
03/06/2011 33,90
04/06/2011 12,00
...
...
...
Jun./2012 900,90
difference 203,00
I know there is a Fixpack 1 for Cognos 10.1.1. but i can't use this at the time.
Is there a way ? Please HELP !
in Cognos 10.1.1 i can't calculate 2 date members in a crosstab after drill-down.
My Crosstab looks like this:
Revenue
--------------------------------------
Company Month last year 1900,00
Month 900,00
--------------------------------------
difference -1000,00
Month is a dataitem '[CUBE].[Date].[Date]-> ?P_Month?'
Month last year is a dataitem 'lag([Month]; 12)'
difference is '[Month] - [Month last year]'
DateDimension: Date->Date->Year->Qua->Month->Day
The report works fine and in Cognos 8.4 complete but after drill down by 'Month last year' or 'Month' an error accours in Cognos 10.1.1.
QE-DEF-0480 The operands of [Month] - [Jun./2011] cannot be converted to consistent dimensional object.
It should be:
01/06/2011 20,00
02/06/2011 399,30
03/06/2011 33,90
04/06/2011 12,00
...
...
...
Jun./2012 900,90
difference 203,00
I know there is a Fixpack 1 for Cognos 10.1.1. but i can't use this at the time.
Is there a way ? Please HELP !