none
Default cascading parameters

    Question

  • Using SSRS 2008 R2 on top of SSAS 2008 R2. I have cascading parameters @CompanyType and @Company pulled from the top 2 levels of an SSAS hierarchy. @Company is dependent on @CompanyType. @CompanyType is populated from the following query:

    WITH MEMBER ParameterValue AS [MyDimension].[MyHierarchy].CURRENTMEMBER.UNIQUENAME
    
    SELECT {ParameterValue } ON COLUMNS, { ([MyDimension].[MyHierarchy].[Company Type].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( -{ [MyDimension].[MyHierarchy].[Company Type].&[U] } ) ON COLUMNS FROM [MyCube]) CELL PROPERTIES VALUE
    

    And then @Company is populated using the following:

    WITH MEMBER ParameterValue AS [MyDimension].[MyHierarchy].CURRENTMEMBER.UNIQUENAME
    
    SELECT { ParameterValue} ON COLUMNS, { ([MyDimension].[MyHierarchy].[Company].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@CompanyType, CONSTRAINED) ) ON COLUMNS FROM [MyCube]) CELL PROPERTIES VALUE
    

    @CompanyType has it's label set to CompanyType and the value set to ParameterValue. The default is also ParameterValue, i.e. all values are selected.

    @Company has it's label set to Company and the value set to ParameterValue. The default is ParameterValue, i.e. all values are selected.

    When I select one Company Type, the Company parameter is appropriately populated with the correct values and all the values are selected. Now I go back to @CompanyType and select all values. Although @Company is populated with the correct values, the defaults are still only the ones which I had selected previously for the specific Company Type and not all.

    How can I select all parameters in the second cascading parameter when all parameters are selected in the first one?

    Thanks,

    Louis


    Louis Young
    Monday, December 20, 2010 11:44 AM

Answers

  • Hi Louis,

    There is no process to select all parameters for the second parameters in current reporting services. However, you can check "Select All" to select all parameters, which is also quick.

    thanks,
    Jerry

    • Marked as answer by louisyoung187 Wednesday, December 22, 2010 6:36 AM
    Wednesday, December 22, 2010 6:11 AM