Hi All --> I need to Change Member Caption of a member in a Hierarchy set.
Suppose if a Hierarchy had 3 members and their captions are as below.
Hierarchy 1
MemberName Caption
Member1 ABC
Member2 DEF
Member3 GHI --> I want to change GHI to "XYZ" while displaying on crosstab report. The Member 3had other members (under it) MemberA ,B and C.
I am able to change the display but when drilling, it is displaying "XYZ" for all the submembers(MemberA ,B and C) of Member 3 as well. I know the best option is to make cahnge @ cube but wanted to know if there is anything that we can implement at the report level.