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

• Sy-1148362

  Right there with Babe

  Points: 759

  More actions

  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

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  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.