Post reply

Dimensions disappear from the dataset when add a new parameter to the SSRS report

  • November 12, 2009 at 1:08 am

    #227888

    Hi Everybody

    I have a report build on SSAS cube. It has 8 parameters already and works fine with those.

    Now I need to add date parameters like StartDate and EndDate to the existing parameters. I added them in the query parameters and included them in the MDX query.

    Once I include them and execute the query, the dimension columns gets disappeared from the dataset. Only those of the measures are remained. So, the report table is missing all those dimensions and getting invalid.

    Could anyone just help me out why adding 2 new date parameters makes the dimension disappeared from the dataset?

    Btw, I am using SQL Server 2005 Analysis Services and Reporting Services.

    Thanks

    Sunny

  • November 12, 2009 at 7:56 am

    #1078362

    Hey Sunny,

    It might make it easier for ppl to help you with this issue if you post the MDX from both reports - that is, the MDX before the 2 new parms, and then the MDX after.

    Steve.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply