locked
Designing Scorecard causes update error (and a query against the entire cube) [PPS2010] RRS feed

  • Question

  • Hi

    I'm getting a timeout when designing a few of my scorecards.

    When I run a profiler trace, a query is being run against all the partitions of my cube.

     

    Is there a way to change this? To maybe filter the scorecard at design time to the current month?

    Thanks,

    Jason


    MCITP BI Developer - MCTS SQL Server
    Friday, October 14, 2011 9:09 AM

All replies

  • How about modifying your KPI metrics by changing the Dimensional data source mapping under Data Mappings to use time dimension with current month as default.

    This would filter the measures to use current month.


    http://dailyitsolutions.blogspot.com/
    Friday, October 14, 2011 7:24 PM