Post reply

SSRS. Parameters mdx script doesn't work with multi-value

  • March 3, 2013 at 2:03 am

    #290147

    Hi ALL,

    I need your your help!!

    I want to create a report with multi-value parameters with SSRS.

    So, I wrote this mdx script:

    WITH

    -- Geography metadata

    MEMBER [Measures].[Geographie]

    AS StrToValue ( @SelectionGeographie + ".Hierarchy.Currentmember.Uniquename" )

    MEMBER [Measures].[Geographie_Label]

    AS StrToValue( @SelectionGeographie + ".Hierarchy.CurrentMember.Member_Caption" )

    -- Activity metadata

    MEMBER [Measures].[Activite]

    AS StrToValue( @SelectionActivite + ".Hierarchy.Currentmember.Uniquename" )

    MEMBER [Measures].[Activite_Label]

    AS StrToValue( @SelectionActivite + ".Hierarchy.CurrentMember.Member_Caption" )

    -- Date metadata

    MEMBER [Measures].[Temps]

    AS StrToValue( @Annee + ".Hierarchy.Currentmember.Uniquename" )

    MEMBER [Measures].[Temps_Label]

    AS StrToValue( @Annee + ".Hierarchy.CurrentMember.Member_Caption" )

    -- Perimetre metadata

    MEMBER [Measures].[Perimetre]

    AS StrToValue( @Perimetre + ".Hierarchy.Currentmember.Uniquename" )

    MEMBER [Measures].[Perimetre_Label]

    AS StrToValue( @Perimetre + ".Hierarchy.CurrentMember.Member_Caption" )

    SELECT NON EMPTY {

    -- display the parameters attributes on columns

    [Measures].[Geographie],

    [Measures].[Geographie_Label],

    [Measures].[Activite],

    [Measures].[Activite_Label],

    [Measures].[Temps],

    [Measures].[Temps_Label],

    [Measures].[Perimetre],

    [Measures].[Perimetre_Label],

    [Measures].[11 VA]

    } ON COLUMNS,

    ( STRTOSET ( "{" + @SelectionGeographie + "}") ,

    STRTOSET ("{" + @SelectionActivite + "}" ))

    ON ROWS

    FROM [MyCube]

    WHERE STRTOTUPLE ( "(" +@Annee + "," + @Perimetre + ")" )

    But It works with one value in parameter and not with muti-value parameters.

    I have null result in my metadata members when I have multi value.

    Any idea ?

    Thank

  • March 3, 2013 at 3:34 am

    #1592736

    Noone ? : (

    I don't know why That works when I have only one parameter and not with many parameters ? is it possible to use the uniquename functions with muti-value ?

  • March 3, 2013 at 7:41 pm

    #1592849

    Could be the fact that you double posted, or just that no one has an answer for you. I know I don't.

    Please post any further responses here.

  • March 3, 2013 at 9:55 pm

    #1592865

    yes. sorry

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply