COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: xyz on 03 Jun 2014 03:21:00 AM

Title: Is there a way to roll up dimension, if there are duplicate string in cube datas
Post by: xyz on 03 Jun 2014 03:21:00 AM
Hi All,

I have a cross tab Cognos 10.2.1 report against Cube datasource which is coming from SSAS, where in 'Process' dimension is there in rows and measure Shell Count is there. Where in 'Test' process is repeating six times for the Shell count measure. When I looked into the 'Process', the Process key, 'Test' member has unique six keys for each 'Test' member. But I am not using any key in the cross tab. How will I make sure that 'Test' should be rolled up for Shell count. Please find the Current output and expected output below. I tried taking measure in data item and setting the Rollup and Aggreation to Total, nothing is working out.


Current Output of Cross tab below:
                                                 
                    Shell Count
Process
Test            1                                 
Test            1
Test            1 
Test            1
Test            1
Test            1


Expected Output:

                    Shell Count
Process
Test            6                                 

Can you guys help, me how to achieve the above expected output!!!

Your help will be much appreciated :)

Thanks & Regards,
Xyz

Title: Re: Is there a way to roll up dimension, if there are duplicate string in cube datas
Post by: xyz on 03 Jun 2014 04:39:13 PM
Hello Guys,

Any updates on my below email?


Your help will be much appreciated?


Thanks & Regards,
Xyz
Title: Re: Is there a way to roll up dimension, if there are duplicate string in cube datas
Post by: Francis aka khayman on 03 Jun 2014 08:47:29 PM
You may not  be using business keys in your crosstab but your cube does. the display you see is just the caption but since those captions have different keys they are not grouped together.

you can try to 'remove the dimensionality'... check it out here:
http://cognosm.fm3online.com/dimensional/stripping-dimensionality-of-a-member/

however it might affect the report's performance
Title: Re: Is there a way to roll up dimension, if there are duplicate string in cube datas
Post by: xyz on 04 Jun 2014 03:08:48 AM
Thank you very much Khayman.

The link provided by you helped me a lot, I appreciate your help :)



Thanks & Regards,
Xyz