开发者

MDX - Concatenate level's properties and level's members

开发者 https://www.devze.com 2023-01-29 00:06 出处:网络
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 mem

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.Propert开发者_运维技巧ies("Prop").

Is this possible in some way?

Thanks. Matteo


In MDX it should look like that

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

The concatenation operator in MDX is + not ||

0

精彩评论

暂无评论...
验证码 换一张
取 消