Post reply

RQPP = Report Query Performance Pain

  • September 15, 2010 at 6:53 am

    #226355

    Hello Experts,

    I am trying to create a SSRS report which retrieves its data from an SSAS cube. When I try to load the same query within the SSAS platform then it takes jut 0.5 seconds. The same resultset design in SSRS approx. 25 minutes!

    My only purpose is to locate two dimension hierarchies and 2 measures.

    here is the MDX query of the SSRS report

    SELECT NON EMPTY { [Measures].[Sale Unit], [Measures].[Sales Value] } ON COLUMNS,

    NON EMPTY { ([Dim Product MAX].[Hierarchy].[Style Code].ALLMEMBERS * [Dim Date].[Calendar].[Date].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [HCSALES_MAX] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

    P.S : I have attached two screenshots to describe the case.

    Any idea?

  • September 15, 2010 at 9:44 am

    #1221472

    When you say from SSRS, do you mean from within VS?

    The reason I ask, is that I have come across situations where for example a stored procedure runs like lightning from within Management Studio, but the same stored procedure takes a couple of minutes to run from within VS. Hoewver, once the report that calls the stored procedure is deployed, it runs normally (fast).

  • September 15, 2010 at 9:57 am

    #1221482

    No,

    I am trying directly via SSRS

  • September 15, 2010 at 10:02 am

    #1221486

    erdem1973 (9/15/2010)

    No,

    I am trying directly via SSRS

    You mean running the report off the server???

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

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