Practical MDX for Essbase Developers • 205
For his method, you will need to understand and leverage an MDX formula like the
following:
StrToMbr(ConCat([Time].CurrentMember.MEMBER_NAME, "_YTD"))
is function takes the member name of the current member and concatenates it
with the text string “_YTD.” e StrToMbr() function converts the newly concatenated
string that is being returned to an Essbase member name. e result of this formula
will point to a nonlevel-0 member of the primary Stored hierarchy in Pressman’s exam-
ples. Finally, you do have to make it a Tuple with the [Periodic] member of the View
dimension:
(StrToMbr(ConCat([Time].CurrentMember.MEMBER_NAME, "_YTD")),
[Periodic]).
In my opinion, Pressman’s method is the most ecient way of ...