MDX: How To Aggregate Hierarchy Level Members With Same Name?

I think your cube design is flawed The best way to design a dimension is so all its members are unique, and the aggregation path follows the natural hierarchy of the dimension You could remove the WEEK level from SEGMENT and create another dimension (if I remember correctly, you can't have more than one hierarchy in AS 2000), say WEEK, with the following structure: Week. Week- 1 Week. Week- 2 Week.

Week- 3 etc Then you just have to filter by SEGMENT and by Week. For example, to get all the Week1 of Flow A you'd do: SELECT {Measures. Members} on 0 FROM MYCUBE WHERE (Week.

Week- 1,Segment. A).

I think your cube design is flawed. The best way to design a dimension is so all its members are unique, and the aggregation path follows the natural hierarchy of the dimension. You could remove the WEEK level from SEGMENT and create another dimension (if I remember correctly, you can't have more than one hierarchy in AS 2000), say WEEK, with the following structure: Week.

Week- 1 Week. Week- 2 Week. Week- 3 etc Then you just have to filter by SEGMENT and by Week.

For example, to get all the Week1 of Flow A you'd do: SELECT {Measures. Members} on 0 FROM MYCUBE WHERE (Week. Week- 1,Segment.

A).

I agree with your assessment that the cube design is deficient. Unfortunately, design changes to the cube are not feasible. – Dave Frautnick Mar 17 '10 at 22:05.

Week. &1 (Week. Week - 1 (flow1)) Week.

&5 (Week. Week - 1 (flow2)) For reference, in the 'Adventure Works DW Standard Ed' Cube for 2008, the key for Customer Aaron A. Allen is Customer.Customer.

&20075 UPDATE: Sorry, just reread your question, it looks like you're not trying to get the specific week to a flow, you want to aggreagate them. What about a CASE Statement like this: CASE WHEN Week.CURRENTMEMBER.NAME='Week - 1' THEN Week. CURRENTMEMBER ELSE 0 END Not very generic or flexible, but it might be a start...

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.