Print Page - New measure depending on periode

Title: New measure depending on periode
Post by: verocarbelo on 08 Oct 2009 07:11:41 AM

Hi COGNOSise team!

I am new in Data Manager and I would like to do this:

I have this table

PERIODE PERIODE_VJ KONTO MEASURE1 MEASURE2

200803 200703 60000 100 0

200703 200603 60000 24,5 0

200603 200503 60000 200,14 0

and I would like to add a new column with the measure of the same periode but one year before:
I mean:

PERIODE PERIODE_VJ KONTO MEASURE1 MEASURE2

200803 200703 60000 100 24,5

200703 200603 60000 24,5 200,14

200603 200503 60000 200,14 0

How can I do this?

Thank you very much!! I hope someone can help me!!

Title: Re: New measure depending on periode
Post by: verocarbelo on 12 Oct 2009 03:13:41 AM

I can´t find the solution in DataManager.
Any ideas? :-[

Title: Re: New measure depending on periode
Post by: SSNCOG on 29 Oct 2009 11:12:13 PM

Do you want to add a new column in the table and populate the value ?
can you just show how different the table would be after the change.

Thanks,
SSNCOG

COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: verocarbelo on 08 Oct 2009 07:11:41 AM