How to group member in Cognos DMR report?

[cognosbiuser]

Hi Folks,

I am creating a report using cognos DMR package.

I am using descendants of ([Compnay]) which will give descendants of that level.Each company will have different and some times same children.But i want see only unique members from all company with all members.

For Eg My Data is like this:

Company 110-A-3
                       B-4
                       C-6
Company 120-C-1
                       A-2
                       F-3
Company 130 A-1
                       E-4
                       C-2

My Data expectations


Dep             Revenue
A                     5
B                     4
C                     9
E                      4
F                      3


But i am getting data as attached screenshot. So can somebody help me in getting unique members from all company's and getting roll up for all company's base on the availability.


PFA for more information.

Regards
BI User                   

[MFGF]

I am using descendants of ([Compnay]) which will give descendants of that level.Each company will have different and some times same children.But i want see only unique members from all company with all members.

For Eg My Data is like this:

Company 110-A-3
                       B-4
                       C-6
Company 120-C-1
                       A-2
                       F-3
Company 130 A-1
                       E-4
                       C-2

My Data expectations


Dep             Revenue
A                     5
B                     4
C                     9
E                      4
F                      3


But i am getting data as attached screenshot. So can somebody help me in getting unique members from all company's and getting roll up for all company's base on the availability.


PFA for more information.

Regards
BI User                   

Hi,

There's a problem with your assumption (in bold), above. Within a DMR model (or any OLAP environment), members in a level cannot have multiple parents, so different company members cannot have the same children. Although it may appear that different companies have a child member with the same caption, under the covers these are entirely different child members with different Member Unique Names (MUNs). What you are seeing is entirely correct.

Cheers!

MF.

[cognosbiuser]

Hi MFGF,

Thanks for your prompt reply.Yes your correct each child belongs to only one parent .But I have requirement as mentioned above.

I want to group all same Names (Member) form different company and i want to show measure total for each Names instead of showing them multiple times.Is there any way to do this? Please suggest.

Regards
Bi User

[bdbits]

It sounds to me like perhaps you need another dimension for the "names" level, either replacing the current company level, or just an additional dimension.