MDX Format from Secondary Alias
SummaryMDX Format from Secondary Alias
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 220.127.116.11.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)))