removing duplicates from crosstab

[orbair]

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!

[MFGF]

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.

[orbair]

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