MDX question about Parent-Child relationship

#1

I have a Parent Child rollup where a Manager (called a VPP in my case)
could contain him or herself as a Direct Report (Child) as well. So as
an example for a certain measure:

Gail Christopher 9
-- Joe Burns 2
-- Gail Christopher 3
-- Jane Walsh 4

How would I structure the MDX to get the Child (or leaf level) Gail
Christopher value of 3 and not the Parent value of 9

#2

On Sep 30, 8:33*am, Scott C <scottcarm... (AT) comcast (DOT) net> wrote:

Quote:

I have a Parent Child rollup where a Manager (called a VPP in my case)
could contain him or herself as a Direct Report (Child) as well. So as
an example for a certain measure:

Gail Christopher * * * * * * * * * *9
* *-- Joe Burns * * * * * * * * * * *2
* *-- Gail Christopher * * * * * * 3
* *-- Jane Walsh * * * * * * * * * 4

How would I structure the MDX to get the Child (or leaf level) Gail
Christopher value of 3 and not the Parent value of 9

Figured it out. I need to use the DataMember function such as:

[Lead].[Report To].&[601].DataMember

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

MDX question about Parent-Child relationship

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

MDX question about Parent-Child relationship - 09-30-2010 , 07:33 AM

Re: MDX question about Parent-Child relationship - 09-30-2010 , 08:29 AM