Search code examples
performancereporting-servicesdatasetssrs-2012ssrs-expression

Performance issues in SSRS? - Filtering measures

I am working on a report that I had no problems executing until I added two extra measures to my dataset. When I tried to preview my report it just kept loading and loading...

Here is a snapshot of the dataset. The measures that I am interested in here are Date of 2:nd markdown and Date of 3:rd markdown

enter image description here

Here's a snapshot of the dataset filter. Nothing fancy, just [Date_of_2_nd_markdown] > 20120101. I only want to retrieve articles that have been lowered twice and this should filter out the 0's

enter image description here

Am I doing something wrong?

Solution

  • I have found a solution! My dataset was filtering through a lot of rows and the best way to speed this up was by using an MDX query to retrieve and filter through the data directly in the Query Designer.

    I do not know why the filtering goes faster here, but this is the query that I used:

    FILTER([Product].[Article].MEMBERS, [Measures].[Date of 2:nd markdown] > 20120101)

    I also removed any unnecessary fields that weren't being used in the report.