locked
KPI: filter two facts by date RRS feed

  • Question

  • Hello.

    I use Sharepoint 2010 with PerformancePoint Services and SSAS as a datasource.

    I want to create Dashboard with KPI scorecard and two filters. 

    KPI with 2 facts:
    - Fact1 is a sum over a measure (int) filtered by date: from the earliest till the date from filter1 (filter by time dimension)
    - Fact2 is a sum over a measure (int) filtered by date:  from the earliest till the date from filter2 (filter by time dimension)

    Finally, I want to get a sum of measure on the start of period and on the end of period.

    I can't realize how to connect two different filters with two different columns in KPI. Could anyone help me?

    Wednesday, June 22, 2011 11:34 AM