Home Forums Reporting Services SSRS 2014 SSRS Report with MDX parameters. Need to utilize the DESCRIPTION property ON COLUMNS. How can this be added? RE: SSRS Report with MDX parameters. Need to utilize the DESCRIPTION property ON COLUMNS. How can this be added?

  • Hi Rick,

    If you want a member property to be returned in your result set you need to do that as a calculated member as you are returning a values. To get the Description property you should access it using the Properties keyword. I don't think it's possible to access those properties in the way you described.

    WITH MEMBER [Measures].[WidgetDescription] AS

    [Widgets].[Widgets-Factory-H1].CurrentMember.Properties("Description")

    MEMBER [Measures].[PayorsDescription] AS

    [Payor].[PAYORS-H1].CurrentMember.Properties("Description")

    SELECT

    NON EMPTY

    { [Measures].[WidgetDescription], [Measures].[PayorsDescription], [Measures].[Periodic] } ON COLUMNS,

    NON EMPTY

    { ([Widgets].[Widgets-Factory-H1].[Widge-Fac LEV5].ALLMEMBERS *

    [Payor].[PAYORS-H1].[PAYORS-TOT].ALLMEMBERS)} ON ROWS

    FROM ( SELECT ( STRTOSET(@TimeMONTH, CONSTRAINED) ) ON COLUMNS

    FROM ( SELECT ( STRTOSET(@WidgetFactory, CONSTRAINED) ) ON COLUMNS

    FROM [WidgetInfo]))

    You cannot use the description for the parameters values in a StrToSet function but you can use it as the parameter Label. So as an example you would want your @WidgetFactory parameter dataset to look like this:

    WITH MEMBER [Measures].[ParameterLabel] AS

    [Widgets].[Widgets-Factory-H1].CurrentMember.Properties("Description")

    MEMBER [Measures].[ParameterValue] AS

    [Widgets].[Widgets-Factory-H1].CurrentMember.UniqueName

    SELECT

    {

    [Measures].[ParameterLabel],

    [Measures].[ParameterValue]

    } ON COLUMNS,

    { [Widgets].[Widgets-Factory-H1].[Widge-Fac LEV5].ALLMEMBERS } ON ROWS

    FROM [WidgetInfo]

    Obviously I'm unable to run the above so they may contain errors, but hopefully they should give you an idea of how to correctly return the member properties.