none
Multiple executions of MDX filter queries RRS feed

  • Question

  • Hello,
    I have performance issues on my PP dashboards. By using SQL server profiler, I have noticed that each PPS Filter that I have on a dashboard page is executed several times (from 3 to 5 times). 
    I spent hours to try to understand why and to find any link between my dashboard's items and the number of times the query is executed. But I still don't understand....

    I tried to play with the connection parameters (unattented service account, per user idendity, cache duration..), but I always have the same resulty in SQL Server Profiler.

    Have you also noticed this ? Is there a way to avoid multiple execution of MDX queries ?
    I am using Sharepoint 2013 ona 2008R2 SSAS.

    Thansk for your assistance
    Franck

    Wednesday, December 23, 2015 5:32 PM