Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
MDX Format from Secondary Alias — Cloud Customer Connect
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
8
Views
2
Comments
edited Aug 2, 2018 2:36AM in Essbase 2 comments

Summary

MDX Format from Secondary Alias

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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