Default cascading parameters
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, LouisLouis Young
December 20th, 2010 7:02am

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
Free Windows Admin Tool Kit Click here and download it now
December 22nd, 2010 3:27am

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
December 22nd, 2010 3:27am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics