Report Portal

SSAS SSRS : Bad Performance SSRS parameters and SSAS

SSRS Reporting parameters and SSAS cubes......There is a lot to read about on the internet about the bad performance of parameters that are generated by Reporting Services based upon a SSAS Cube. Today, I've ran into this problem too. I've a parameter with a dataset that queries a customer table of about 40000 records. Peanuts for a simple SQL query, but not for a SSAS cube (pfffff). And, I'm not the only one who has encountered this problem. You can read hundreds of blogposts, forumposts and more. This is one blogpost more about this bad cooperation between SSRS and SSAS.

Read more...

Tags: performance, ssrs

 

2007-2015 VidasSoft Systems Inc.