Post reply

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

  • November 12, 2009 at 1:10 am

    #385772

    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 2:50 am

    #1078215

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic817651-150-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 12, 2009 at 3:11 am

    #1078221

    Hi Gila

    SSC is an ocean and people may or may not look at my issue. And moreover Business Intelligence forum includes SSIS, SSAS and SSRS, and we have separate forum for IS, AS and RS. Its just an attempt to find the solution. Sorry If I have wasted your time.

    Thanks

    Sunny

  • November 12, 2009 at 3:25 am

    #1078229

    Sy-1148362 (11/12/2009)

    SSC is an ocean and people may or may not look at my issue.

    Yes, that's true, however forum etiquette (here and virtually everywhere else) is to pick the one best-fitting forum for your question and post there. Besides, there's nothing more irritating than spending half an hour writing up a detailed answer to someone's question only to find that the person posted in several places and the question was answered hours earlier. That's why virtually every time someone crossposts another person will come along and point all threads but one to a common place.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

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