none
PerformancePoint Dashboard - Control the Filter By Status using a PPS filter RRS feed

  • Question

  • I have a Dashboard with 3 reports and one Scorecard.  One of my filters has values for Compliance, Non Compliance and All that work correctly for the reports.  What I need is to connect that filter to my scorecard mapping On Target to Compliance, Slightly Off target and Off Target to Non Compliance and All to All.  I have attempted using the connection formula to dimension values using

    NON EMPTY
    [Craft].[Craft CODE].CHILDREN HAVING
    CASE WHEN<<SourceValue>> = [Compliance Completion].[Compliance Description].&[Compliance]
    THEN KPIStatus("Service Order Response - Priority 3 Routine") = 1
    WHEN <<SourceValue>> = [Compliance Completion].[Compliance Description].&[Non Compliance]
    THEN KPIStatus("Service Order Response - Priority 3 Routine") = -1
    ELSE KPIStatus("Service Order Response - Priority 3 Routine") < 99 END ON ROWS 

    which works in the MDX editor, it does not work in the dashboad. 

    Wednesday, August 22, 2012 12:03 PM

All replies