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

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. 

Answer 1

If you are trying to use this in a connection formula you would just need the following portion:

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

Now I don't believe you are going to be able to directly connect this to your target.  To get this to work I believe you are going to need to put this logic either in your KPI status formula in the cube or you could try this type of logic in your tuple formula for the target mapping.  You would need to modify the logic though to be something like the following:

CASE WHEN [Compliance Completion].[Compliance Description].CurrentMember IS [Compliance Completion].[Compliance Description].&[Compliance]
THEN KPIStatus("Service Order Response - Priority 3 Routine") = 1 
WHEN [Compliance Completion].[Compliance Description].CurrentMember IS [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

---