Post reply

Cascading parameters MDX

  • August 3, 2006 at 4:36 am

    #169222

    I know that what I need is cascading parmeters but I cant seem to find way of doing it. Below is the MDX  code from the second parameters Dataset. I need to filter this dataset by the first paramter which is @p1. I am using rs 2005 and as 2005.

     

    Any Help or pointers greatly appreciated.

     

    WITH MEMBER [Measures].[ParameterCaption] AS '[Broker Contact].[Full Name].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[Broker Contact].[Full Name].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[Broker Contact].[Full Name].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Broker Contact].[Full Name].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@p2, CONSTRAINED) ) ON COLUMNS FROM [Any Cube])

    www.sql-library.com[/url]

  • August 7, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • August 7, 2006 at 1:21 pm

    #653718

    I assume this is the code you are using to return a dataset in reporting services?

    I think this will work, though I have not tried it.

    ="WITH MEMBER [Measures].[ParameterCaption] AS '[Broker Contact].[Full Name].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[Broker Contact].[Full Name].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[Broker Contact].[Full Name].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Broker Contact].[Full Name].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(" & Parameters!ParameterName.Value & ", CONSTRAINED) ) ON COLUMNS FROM [Any Cube])"

     

    I'm not too familiar with MDX but I saw something like this in my googling.

  • August 8, 2006 at 5:24 am

    #653808

    Thanks very much for this the it seems and to compile this code but cant run it.

    After i select the first parameter( which then whould filter the available valuse for the second based on the data set you suggest.

    It tells me that 'cannot set the command text for data set'

    'error during processing of command test exprssion for data set ...'

    Thanks very much for your help, MDX is a nightmare.

    Jules

    ="WITH MEMBER [Measures].[ParameterCaption] AS '[Broker Contact].[Full Name].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[Broker Contact].[Full Name].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[Broker Contact].[Full Name].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Broker Contact].[Full Name].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(" &Parameters!BrokerOrganisationName.Value & ", CONSTRAINED) ) ON COLUMNS FROM [Any Cube])"

    www.sql-library.com[/url]

  • August 8, 2006 at 11:39 am

    #653898

    Will your query run in the sample application?

    I found this while trying to find something else (as always seems to be the way )

    http://www.developmentnow.com/g/115_2004_10_0_0_452423/Reg-MDX-in-Query-issue.htm

     

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

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