none
How to hide a particular value in parameter drop down list in ssrs ? and here data source is Cube.

    Question

  • Hi friends,

    Here i have a parameter called "Weeks" in my report and it has values like week1 ,week2, week3 to week 50 and also i have value called "Date Not Assigned".

    and i don't want to show the value "Date Not Assigned" in parameter drop down list. so please help me with this, how to hide this value. in parameter drop down list.

    and the data source is cube.

    Thanks

    Naveen


    • Edited by NaveenMSBI Wednesday, August 21, 2013 8:44 PM
    Wednesday, August 21, 2013 3:24 PM

Answers

All replies

  • Hi friends,

    Here i have a parameter called "Weeks" in my report and it has values like week1 ,week2, week3 to week 50 and also i have value called "Date Not Assigned".

    and i don't want to show the value "Date Not Assigned" in parameter drop down list. so please help me with this, how to hide this value. in parameter drop down list.

    and the data source is cube.
    Thanks

    Naveen
    Wednesday, August 21, 2013 8:47 PM
  • Hi

    It is more related to your MDX query behind the parameter source and it is even very simple to do

    1. Get the MDX source query behind it

    2. Exclude the Date Not Assinged member from it like

    [Date].[Calendar Week of Year].[Calendar Week of Year] - [Date].[Calendar Week of Year].&[Date Not Assigned]
    Provide your source MDX for more details

    Prav

    Wednesday, August 21, 2013 10:50 PM