Skip to content

Instantly share code, notes, and snippets.

@agrohe21

agrohe21/mdx_prompt_reference

Created June 4, 2019 22:03
Show Gist options
  • Save agrohe21/017498fc43ba5d7704febfe8346a395c to your computer and use it in GitHub Desktop.
Save agrohe21/017498fc43ba5d7704febfe8346a395c to your computer and use it in GitHub Desktop.
Download ZIP
MDX Reference Data Prompt
Raw
mdx_prompt_reference
/* This allows you to have first column with the display value and second for parameter query substitution. */
WITH MEMBER [Measures].[Unique Name] AS [Order Status].[Type].CurrentMember.Properties("MEMBER_UNIQUE_NAME")
select
{Measures.[Unique Name]} on columns,
[Order Status].members on rows
from [SteelWheelsSales]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment