SAC Treshold on KPI1 is dependent from KPI2

[PeterSigi]

Hi all,

I am facing a Problem setting a treshold in SAC Application Designer on an KPI in a Table referring another KPI. I often have done this before in BEx Query Designer Exceptions. In there there was a possibility to set the structure element (KPI) on which the exception should work.

As Example:

I use KPI1 (Order Quantity) and KPI2 (Status). If KPI2 has the value xx, KPI1 should be displayed green on the table.

I have no idea how to resolve this in SAC.

Many thanks for your help.

Peter

[PeterSigi]

Hi Community, still noone has an idea how to implement such an scenario in sac

[vitran23]

I've run into the same issue but haven't seen a good solution in SAC to be able to display the threshold on another measure other than the one it's defined on.

[former_member743805]

Hi Peter,

I think this is only possible with a workaround, since the thresholds only compare two KPIs with each other depending on which value is i.e. higher or lower.

I have an idea to your case that eventually could work. I assume your KPI2 has a value 1 for green, 2 for yellow and 3 for red (as an example)

You could create a calculated KPI3 where you integrate If statements like:

If KPI2 = 1; KPI1 -1 -> KPI3 is lower

If KPI2 = 2; KPI1 -> KPI3 is identical

If KPI2 = 3; KPI1 +1 -> KPI3 is higher

I did not check if this is actually possible, but it could work from my perspective. This way you could define the Threshold like: if KPI1>KPI3 green; if KPI1=KPI3 yellow; if KPI1<KPI3 red.

Kind regards,

Sascha

[former_member27]

Hi Peter,

your question is part of the Community Answer-Thon Challenge - if you got the right answer please accept it.

Regards,

Dedi

[PeterSigi]

Hi Sascha, many thanks for your idea and sorry for the late reply. But this does not work für my problem. My KPI2 is independent to KPI1.

Best Peter