开发者

In SSAS, can parent-child DATAMEMBER name be customised

In a parent-child dimension in SSAS, the datamember is automatically named the same as the parent.

E.g.

  • Division X Risk Register
    • Division X Risk Register
    • Department A Risk Register
    • Department B Risk Register
  • Division Y Risk Register
    • Division Y Risk Register
    • Department P Risk Register
    • Department Q Risk Register

I want all the datamembers to be named "Executive Risk Register", as follows:

  • Division X Risk Register
  • Division Y Risk Register
    • Executive Risk Register
    • Department P Risk Register
    • Department Q Risk Register

(b.t.w. if the the children also have children, their datamembers must also be "Executive Risk Register").

Can this be done by setting something on the dimension in SSAS or do I have to handle it separately in every MDX query?


Have you looked at Changing the MembersWithDataCaption property in the Parent attribute to "Executive Risk Register"?

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜