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.

SELECT
{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:

MDX

 

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s