CROSS TAB

[tamise]

hello,

I am using Report Studio. And I need help concerning creating crosstab, I want to create a croostab like that :

           Cumul à Juillet  Y-1   |   Y-1    |   M-2et Y   | M-1etY | M et Y
Compte                

For exemple with the year  2013 and month 01, I have to have :

           Cumul à Juillet  2012   |   2012    |   201211   | 201212 | 201301
Compte
      
After running the report studio I have :


                           2012   |              2012                            |201211   | 201212 | 201301
                         1 2 3 4 5 6 7         1 2 3 3 4 5 6 7 8 9 10 11 12
Compte

Can you help me PLEASE

THANKS

[charon]

Hey Tamise,

do you use a relational model or is it dimensional modeled?
In case of relational, you can create columns calculation that have if then else logic in it and place it, using expressions like "currentdate" to get the actual year and month will make that dynamic.
i prefer the dimensional way though, in case you have a dmr package or olap source/ cube try dimensional time functions.
most likely, your package contains a "time" dimension, in case you have modeled year and month try dimensional time functions like lag, which will get the previous member in the level of your dimension. lag ([currentyear],1) will give you Y-1.

Cognos delivers plenty functions to navigate through dimensional structures, and esp. time dimensions.
If you want to dig deeper into this, check this pdf out
http://www.google.de/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CDIQFjAA&url=http%3A%2F%2Fwww.temple.edu%2Fers%2FTraining_Material%2FCognos_time_and_date_functions.pdf&ei=qvpiUuTkFIXMsgaAv4CoBQ&usg=AFQjCNGPeotWv_etUjacW8ZudHnz0oFScQ&sig2=WctZkm_6_srl9K3diyirZA

but in Report Studio you will find the most important expressions in the "function tab" as well.
cheerz

[tamise]

Thanks for the answers. I use relationnel models. But is there a function the output on crosstab :

Cumul of 2012 (with the month to 01 to 12)

and not

2012
1 2 3 4 5 6 7 8 9 10 11 12

Indeed on colums i put
year
period

thanks

[charon]

Hi Tamise,

cumul 2012 -> means the whole year.
create a calculation [Y-1] with [year] = 2012 for 2012.
Also, you could use expressions like currentyear -1 to get the last whole year dynamic.

cheerz

[tamise]

Hello,  thanks for the help :)