Essbase Multidimensional Expression (MDX) Query Scripting to Get Attribute Member Information

To get the attribute member information instead of the base member, use the DIMENSION PROPERTIES section of an MDX query scripting

For example, using Sample/Basic, the following MDX query will return the [Ounces] attribute of each Product member on the row axis.

{Sales} on COLUMNS,
[Product].Levels(0).Members DIMENSION PROPERTIES [Ounces] on ROWS

The screen shots below show the script and the results using the MDX Script Editor in the Essbase Administration Console:




Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s