Skip to Content
0

Scorecard - conditional formatting not seeing Bex defined exceptions

Jan 16, 2017 at 05:56 PM

262

avatar image
Former Member

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?

japhl.png (18.1 kB)
0ualm.png (23.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

avatar image
Former Member Jan 16, 2017 at 06:13 PM
0

I have tried different approaches. And using binding type Conditional Format Value, I don't get to see my exceptions, or generic 1-9 exceptions either:

Very confused :-( Please can you guide me to some blog that explains how to set this all up from start to finish. The only link that I found in another thread wasn't working:

https://archive.sap.com/discussions/thread/3914774


3lstr.png (27.8 kB)
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 16, 2017 at 06:32 PM
0

Update. I have found the above-mentioned blog, but it does not have an explanation how conditional formatting for Colomn 3 is set up:

https://blogs.sap.com/2015/12/29/introduction-to-sap-design-studio-scorecard-component-part-2/comment-page-1/#comment-359810

When I go to Cell Font Color and bind it with Conditional Format Value I still I don't see any conditions in the dropdown:

I am definitely selecting measure for which the exception exists in BW.


dcwmj.png (17.3 kB)
Share
10 |10000 characters needed characters left characters exceeded
Tammy Powlas
Jan 16, 2017 at 07:12 PM
0

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


1agata.jpg (18.0 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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.

0
avatar image
Former Member Jan 18, 2017 at 01:55 PM
0

I think I am getting closer to solving this mystery. I have added another exception into my Bex query, so I have three in total now. What I can see in the dropdown now is this:

If you look closely, there are three empty lines there, as in three exceptions! There used to be two empty lines (when I only had two exceptions). So Design Studio is "seeing" my exceptions, but not really seeing them :D Another bug, I guess...

I have "selected" the second empty line which is the exception that I want and applied formatting, but still nothing is happening:


pd3gf.png (14.1 kB)
7vci5.png (15.4 kB)
Show 3 Share
10 |10000 characters needed characters left characters exceeded

I think you also need to include the icons which was a question from your other thread.

0
Former Member
Tammy Powlas

I have tried this on both Icons and Font Color, as the logic is the same, and it doesn't work in either case:

Nothing happens. I think DS can see that the exceptions exist but can't read their definitions, and, therefore, can't apply the formatting. I'm adding this to the list of bugs :-)

0
Former Member
Former Member

Hi Agata,

I am facing the exact same issue. The dropdown for 'Conditional Format' is empty eventhough there is exception set in the bex query.

Any update on this ?

Thanks & Regards,

Kesavan.

0
avatar image
Former Member May 15, 2017 at 09:58 PM
0
Hi Agata,

I am facing the exact same issue. The dropdown for 'Conditional Format' is empty eventhough there is exception set in the bex query.

Have you managed to find some solution for this ?

Thanks & Regards,

Kesavan.

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Unfortunately, not.

0

Hi all,

we are facing exactly the same issue. Any solution?

Regards,

Martin Zluky.

0

Hi all,

finally i have found the solution. You need to reset the initial view of the datasource with the bex query using exceptions.

Best Regards,

Martin Zluky

1