In SSAS Parent-Child-Hierarchy how to use MembersWithDataCaption
My problem was I used a translation (german) and left the translation for MemberWithDataCaption empty. An other pitfall is a formatstring without a '*' does not work.

Answers:


Set MemberWithDataCaption of the Parent and any translations
In the formatstring the first star is replaced with the original
name, succeeding star will not be replaced.


Examples:

formatstring   original name   resulting caption
------------------------------------------------
constant       Charly          Charly
* (dm)         Charly          Charly (dm)
(*) *          Charly          (Charly) *



The conditions are:


Set MemberWithData=NonLeafDataVisible
Use a Formatstring containing a '*'
If you use translations, provide a translated formatstring