COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: pavankumar on 27 Jan 2015 01:12:53 PM

Title: Multiple Measures in Cross tab report
Post by: pavankumar on 27 Jan 2015 01:12:53 PM
Hi ,

I have a requirement with multiple measures in cross tab which look like below and its monthly report

                                                                                                  Jan 2015

                                                          Corporate    current account  volume        298908
                                                                              saving account    interest       889907
                                                                              overdraft             FTP rate      976657   
Here for volume i have one formula and for interest i have another formula and ftp i have another formula so i want to show this in cross tab report and when i am trying drag all these 3 measures in to fact its not taking instead its taking only one measure which i dont want. and i even tried like unlocking the data item and enabling data content yes but still facing same issue.please can anyone help me on this since i have almost 7 reports with similar format and provide any video or screen shot so that i can easily understand.

   

Title: Re: Multiple Measures in Cross tab report
Post by: bus_pass_man on 27 Jan 2015 07:34:49 PM
You can nest objects under other objects in either axis of a cross tab.

Page 67 has instructions for doing what you want to do.
http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.0/ug_cr_rptstd.pdf

http://www-01.ibm.com/support/knowledgecenter/SSWGNW_10.1.0/com.ibm.swg.im.cognos.ug_cr_rptstd.10.1.0.doc/ug_cr_rptstd_id3817cr_rptstd_reptyp_create_nested_cross.html%23cr_rptstd_reptyp_create_nested_crosstab_report
Title: Re: Multiple Measures in Cross tab report
Post by: ravireddy on 01 Feb 2015 11:15:56 AM
Is ur problem Solved??? by above mentioned link..

If not, I can give u another solution  ;D