cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

I can't find any answered question or blog that actually explain in simple terms how to set up conditional formatting in the scorecard. I have been struggling for hours with, what seems to me, a pretty simple conditional formatting based on one exception set up in a Bex query. I have read all blog entries by Karol Kalisz so I know that in order to use exceptions, they need to be defined in at BW query level.

So, my Bex query definition has Debt value measure and a simple exception Bad 1 for Debt values > 2000. I want to highlight those values in my scorecard and/or add a relevant icon.

I display Debt values in the rows of my Scorecard:

Now, where do I set up my exceptions?

From what I have read in blogs and other questions I should be able to see drop downs in the Conditional Values? It says, 1 of 9 conditions defined, but I am not seeing any. Or, perhaps, I should see a dropdown of my conditions in the Icon's area? But it's all empty. I can't find my Debt > 2000 exception anywhere? How do I use it?

0 Likes
View Entire Topic
TammyPowlas
SAP Mentor
SAP Mentor
0 Likes

Following Karol's blog https://blogs.sap.com/2016/04/18/scorecard-step-by-step-to-nice-visualization-conditional-format/ looks like you need to identify the BEx values 1-9

Usually 1 is "Good"

Usually 7-9 is "Bad"

See below

Former Member
0 Likes

Thanks Tammy,

The problem is, I think, that Karol has set up his exceptions and called them Conditional Format for Result, Conditional Format for Members and he can see them in the dropdown. I don't. I don't see my conditions anywhere. I can see from your screenshot that you have a condition OverBudget. I don't see anything there. I will keep trying. Thanks!

A.