Annotations (MDX+)

Annotating the SELECT keyword, the #Prop annotation allows for overriding OLAP read/write properties as defined in the icCube.xml file. The example is showing how to reset the icCube.mdxEvalFastNonEmptyAxis property.

The list of properties is available here.

Query

//#prop( icCube.mdxEvalFastNonEmptyAxis = false )
SELECT
  [Measures].[Amount] on 0,
  NON EMPTY [Geography].[Geo].members on 1
FROM [Sales]

Result

Assertion : MDX Equals

SELECT
  [Measures].[Amount] on 0,
  NON EMPTY [Geography].[Geo].members on 1
FROM [Sales]

Annotating the SELECT keyword, the #User annotation allows for executing the request with the defined role (aka. impersonation) instead of the role of the user executing the request. Note that you must be logged as an administrator to impersonate a user.

Query

//#User( role = 'administrator' )
SELECT [Measures].[Amount] ON 0 FROM [Sales]

Result

Assertion : MDX Equals

//#User( role = 'administrator' )
SELECT [Measures].[Amount] ON 0 FROM [Sales]