MDX and calculated members

#1

Hello,
I have the following MDX statement which is a calculated member.

sum(descendants([OmrÃ¥de].CurrentMember,,LEAVES)
([Measures].[BefolkningsmÃ¤ngd]/([OmrÃ¥de].CurrentMember,[Measures].[BefolkningsmÃ¤ngd]))
/
([Measures].[Antal]/([OmrÃ¥de].CurrentMember,[Measures].[Antal])))

The problem is that the member [OmrÃ¥de].CurrentMember in the
divide-statement refers to the leaf-member, but I want it to refer to its
parent-member, namely the member that follows right after the
Descendants-statment.

How do I do this?

How do I do this?

#2

Hi,

did you try <...>.currentmember.parent?

cheers
Matthias

"peterw" <peterw (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:022627BE-116C-4961-8BC8-7352A46E77D7 (AT) microsoft (DOT) com...

Quote:

Hello,
I have the following MDX statement which is a calculated member.

sum(descendants([Område].CurrentMember,,LEAVES),
([Measures].[Befolkningsmängd]/([Område].CurrentMember,[Measures].[Befolkningsmängd]))
/
([Measures].[Antal]/([Område].CurrentMember,[Measures].[Antal])))

The problem is that the member [Område].CurrentMember in the
divide-statement refers to the leaf-member, but I want it to refer to its
parent-member, namely the member that follows right after the
Descendants-statment.

How do I do this?

How do I do this?

#3

No, because as i am using LEAVES in the descendants-statement, I do not know
at which level the parent is in. It may not be the parent, it might as well
be the parent of the parent and so on...

"Matthias" wrote:

Quote:

Hi,

did you try <...>.currentmember.parent?

cheers
Matthias

"peterw" <peterw (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:022627BE-116C-4961-8BC8-7352A46E77D7 (AT) microsoft (DOT) com...
Hello,
I have the following MDX statement which is a calculated member.

sum(descendants([OmrÃ¥de].CurrentMember,,LEAVES),
([Measures].[BefolkningsmÃ¤ngd]/([OmrÃ¥de].CurrentMember,[Measures].[BefolkningsmÃ¤ngd]))
/
([Measures].[Antal]/([OmrÃ¥de].CurrentMember,[Measures].[Antal])))

The problem is that the member [OmrÃ¥de].CurrentMember in the
divide-statement refers to the leaf-member, but I want it to refer to its
parent-member, namely the member that follows right after the
Descendants-statment.

How do I do this?

How do I do this?

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

MDX and calculated members

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

MDX and calculated members - 08-26-2005 , 04:28 AM

Re: MDX and calculated members - 08-26-2005 , 06:51 AM

Re: MDX and calculated members - 08-27-2005 , 08:19 AM