COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: orbair on 08 Apr 2015 09:35:27 AM

Title: removing duplicates from crosstab
Post by: orbair on 08 Apr 2015 09:35:27 AM
HI All,

I would have a question regarding how can I take out my duplicates from my crosstab. We use TM1 where in the dimension we have the same member in different hierarchies. So if I use in my crosstab row  descendants([member],17, beforewithmember) then the member will appear as many times as we have in TM1.

Is there any way to have only once in crosstab without changing TM1 side?

Thanks for your help!
Title: Re: removing duplicates from crosstab
Post by: MFGF on 08 Apr 2015 10:24:42 AM
Quote from: Morfeusz on 08 Apr 2015 09:35:27 AM
HI All,

I would have a question regarding how can I take out my duplicates from my crosstab. We use TM1 where in the dimension we have the same member in different hierarchies. So if I use in my crosstab row  descendants([member],17, beforewithmember) then the member will appear as many times as we have in TM1.

Is there any way to have only once in crosstab without changing TM1 side?

Thanks for your help!

Hi,

You can't have the same member in different hierarchies - each is a different member in your cube. If you look at the MUN (Member Unique Name) for each, it will be different.

Under the covers, the cube (and your report) is keeping track of each member based on its MUN. Sadly, this means you can't take multiple members with the same caption and treat them as a single member.

Cheers!

MF.
Title: Re: removing duplicates from crosstab
Post by: orbair on 09 Apr 2015 04:37:43 AM
Hi,

This is true, they have different MUN-s, but they are actually the same. (from business point of view)

I don't know if there any way to do this requirement.

Thanks