MDX Format from Secondary Alias
Summary
MDX Format from Secondary AliasContent
G'day All,
I'm attempting to use the essbase Associate Format String functionality to return some text\context information as measures. So far, this is working really quite well!
I'm now attempting to pull from a secondary alias table and I've hit a bit of a roadblock. This is all in an ASO cube on 11.1.2.4.003.
We have a position dimension as follows:
Member Name: <P>Position Number_<E>Employee Number
Default Alias: Employee Name (Position Number)
Position Alias: Position Name (Employee Number)
I then have members for the following:
Position Number: MdxFormat(Substring([Position].CurrentMember.MEMBER_NAME,2,(InStr(1,[Position].CurrentMember.MEMBER_NAME,"E",1)-2)))
0