gladstonesheeba
asked on
Urgent help me out plz - Cognos Transformer problem
Hi Guyz,
I've got a problem in my Cognos Powerplay Transformer Cube.
One of the measures in the cube is ActualYTD which returns the actual gross sales values for all the years, and months within the particular year.
the report data looks like this,
Measures January Febraury ........................ December
asValues
4005 Actual Period Actual YTD Actual Period Actual YTD
-
Gross
Sales 18,827,153 18,827,153 12,608,865 (Actual YTD (jan) + Actual Period (feb))................
In this case, the Actual YTD is working for year 2007 (it's calculating the data as per the values and the
calculation in the cube)
but it's not working for the rest of the years.
the Actual YTD value for year 2006 is not working properly.
Please help me out in this!
Derivation Part:
ActualYTD = "Actual YTD" - "Budget YTD" (this is the calculation they are using in the measure)
Budget YTD is a different measure ( which gets data from the column "BA YTD Ledger Amount")
Calculation of Actual Period = "Total Ledgers Period" - "Budget Period" - "LE August Period" (this one is working fine)
only the measure ActualYTD is not working as they want it.
I don't know how its working fine for 2007 and not for 2006.
Thanks in Advance!
Prasanna.
I've got a problem in my Cognos Powerplay Transformer Cube.
One of the measures in the cube is ActualYTD which returns the actual gross sales values for all the years, and months within the particular year.
the report data looks like this,
Measures January Febraury ........................ December
asValues
4005 Actual Period Actual YTD Actual Period Actual YTD
-
Gross
Sales 18,827,153 18,827,153 12,608,865 (Actual YTD (jan) + Actual Period (feb))................
In this case, the Actual YTD is working for year 2007 (it's calculating the data as per the values and the
calculation in the cube)
but it's not working for the rest of the years.
the Actual YTD value for year 2006 is not working properly.
Please help me out in this!
Derivation Part:
ActualYTD = "Actual YTD" - "Budget YTD" (this is the calculation they are using in the measure)
Budget YTD is a different measure ( which gets data from the column "BA YTD Ledger Amount")
Calculation of Actual Period = "Total Ledgers Period" - "Budget Period" - "LE August Period" (this one is working fine)
only the measure ActualYTD is not working as they want it.
I don't know how its working fine for 2007 and not for 2006.
Thanks in Advance!
Prasanna.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Computer101
EE Admin