Please put me out of my misery.

I need to get hold of the child of the current member that has the same name
as the current member and I'm struggling.

Why is it that this works:

[SalesPerson].CurrentMember.Children("Central"))

but not this:
[SalesPerson].CurrentMember.Children(MemberToStr([SalesPerson].CurrentMember
))

or this:
[SalesPerson].CurrentMember.Children(([SalesPerson].CurrentMember.Name))

I promise you that there is a member with the name "Central" in both levels!

Thanks in advance

Thanks for the reply Brian but this didn't work for me.

Any other ideas anyone?

Please?!

"Brian Altmann" <findme@thesignaturewebsite> wrote

What about

Filter([Sales Person].CurrentMember.Children,
[SalesPerson].CurrentMember.Name =
[SalesPerson].CurrentMember.Parent.Name)

HTH,

Coen

Thanks but this is not quite what I want.

This is testing the current member name against the parent member name,
whereas I want to compare the current member name against all the children.
And not being able to loop through each of the children I am well and truly
stuck.

"Coen" <stumpie at xs4all dot nl> wrote

On Thu, 8 Jul 2004 15:57:42 +0100, "James Taylor" <a@b.com> wrote:

As fas as I know, this doesn't test the current member. I use a
similar function to hunt down a member that has a member property set
by the back-end system. Don't get fooled by the CurrentMember in the
filter statement. I'm pretty sure it'll do the trick. Just try it.
Either way, one of us will learn something :-)

Coen

Hi Coen,

I did try this with no success. Let me give some more details: I have a very
simple cube containing a "SalesPerson" dimension with levels: Country,
Brokerage, Sales Person.

For some measures in the cube I want to aggregate the dimension in the
normal way (SUM of children) whereas for other measures - percentages - I
don't want to aggregate, instead I want to use the specific value of the
child of the current member that has the same name as the current member.

So, in the Custom Rollup formula of both the Country and Brokerage levels,
using your Filter code I have:

Iif([Measures].CurrentMember.Name="PercentMeasure1" or
[Measures].CurrentMember.Name="PercentMeasure2",
Filter([SalesPerson].CurrentMember.Children,
[SalesPerson].CurrentMember.Name = [SalesPerson].CurrentMember.Parent.Name),
Sum([SalesPerson].CurrentMember.Children))

This gives me the following error in each member cell of the higher levels:
"Formula error - syntax error - token is not valid:
"Filter([SalesPerson].CurrentMember.Children,
[SalesPerson].CurrentMember.Name=[SalesPerson].CurrentMember.Parent.Name)^,^
Sum([SalesPerson].CurrentMember.Children))"

The middle bit is the problem! You can see why I came up with this first:
[SalesPerson].CurrentMember.Children(([SalesPerson].CurrentMember.Name))

If you have any more suggestions I'd love to hear them.

Thanks!

Hi James,

A similar problem is discussed here...

http://blogs.msdn.com/bi_systems/articles/162850.aspx
(Comparing CURRENTMEMBER From Different Contexts )

Guess with little fine tuning u can solve yours... Hope this helps...

Cheers,
Sanka

"James Taylor" wrote: