Paginated Report is too slow

[Migasuke]

Hi community,

I am building paginated report. My goal is to have simple table with a few columns.
I have two options how to build my table:
1. I put all fields from one table (fact table)
2. I put some fields from fact table and some from dim table.

I would prefer option 2, since I don't want to keep redundant data in my fact table.

Problem is, the moment I use parameters from dim table, speed decreases extremely.

In my scenario I have 1:N relationship.


Any tips how to optimize Parameters / Filtering in Paginated reports?

[Medina]

Hi Migasuke,

Without knowing more detail, I would recommend

1. Create a view on top of your fact table and join it with the dim table or tables.
2. Create a stored procedure that uses the view you just created with the parameter you need to filter the dataset.

And give it a try. Also, check the server where the Reporting Services is installed, for any memory pressure, etc. Some time ago, we experienced performance issues, and the network card on the server was the source of the issue. 

Thanks!