You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

MDX Format from Secondary Alias

Received Response
edited Aug 2, 2018 2:36AM in Essbase 2 comments


MDX Format from Secondary Alias


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

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)))

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!