1

I an using mondrian and I have this issue: using a query mdx I need to concatenate in each member name belonging to a certain level, its name and a the value of a certain level properties for that member.

Something like CurrentMember.Name = CurrentMember.Name || CurrentMember.Properties("Prop").

Is this possible in some way?

Thanks. Matteo

user527820
  • 11
  • 2

1 Answers1

1

In MDX it should look like that

[Dimension].CurrentMember.Name + [Dimension].CurrentMember.Properties("YourProp")

The concatenation operator in MDX is + not ||

Spredzy
  • 4,982
  • 13
  • 53
  • 69