Hello There,

Please follow below steps for the query to work. Please follow all the below steps in Query designer of SSRS.

Step 1 : Taking into consideration your sample code, You just need to add a variable @TopXCount instead of hardcoding it as '500'.

select

{ Measures.Meas1, Measures.Meas2 } on columns

topcount( nonempty({ dimension set}), @TopXCount, Measures.Meas2 ) on rows

from

cube

Step 2 : Goto 'Query Parameter' in query designer and Add below details

Parameter : TopXCount

Dimension : leave it blank

Hierarchy : Leave it blank

Multiple Values : leave it blank

Default : Say 5

Step 5 execute the query and check whether it is running for the default value.

If its successfully running then u r succeeded.:-)

Regards,

Nikita C.