Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculate 2 crosstab date members in Cognos Cube Report

Status
Not open for further replies.

miggg

Technical User
Sep 26, 2012
2
0
0
AT
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 !


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top