how to avoid cascading in ssas parameters in ssrs report and load default "all" when report loads?

Question

i have a ssrs report which uses ssas data source and all of the parameter in report also come from ssas data source. the problem is parameters are acting as cascading parameters. i can not have values in parameter drop-down until i select parameter from previous drop-down.

i wanted to have default value "All" selected when report loads instead of waiting for selecting first parameter and then load subsequent?

i have removed @parameters from parameter data source and now here is how my MDX looks like:

WITH MEMBER 

[Measures].[ParameterCaption] AS [Category].[Category ID].CURRENTMEMBER.MEMBER_CAPTION MEMBER 
[Measures].[ParameterValue] AS [Category].[Category ID].CURRENTMEMBER.UNIQUENAME MEMBER 
[Measures].[ParameterLevel] AS [Category].[Category ID].CURRENTMEMBER.LEVEL.ORDINAL 

SELECT 
{
  [Measures].[ParameterCaption], 
  [Measures].[ParameterValue], 
  [Measures].[ParameterLevel]
} ON COLUMNS , 

  [Category].[Category ID].ALLMEMBERS 
  ON ROWS FROM 
  ( SELECT (  [OwningEntity].[Entity ID]  ) 
  ON COLUMNS FROM 
  ( SELECT ( [Organization].[Organization] ) ON COLUMNS FROM [PerformanceScores]
  ))

Daniel Hanczyc Daniel Hanczyc · Accepted Answer · 2014-06-06T07:55:02

Create Additional data source , point your first parameter with default value "from query" to that data source - This parameter need to be on the top of the list as in SSRS order of parameters is important. - Let me know if you got any problems. Thanks Daniel

how to avoid cascading in ssas parameters in ssrs report and load default "all" when report loads?

2 Answers