Skip to Content
author's profile photo Former Member
Former Member

Scorecard - conditional formatting not seeing Bex defined exceptions

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)
Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 16, 2017 at 06:13 PM

    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)
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 16, 2017 at 06:32 PM

    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)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 16, 2017 at 07:12 PM

    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)
    Add a comment
    10|10000 characters needed 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.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 18, 2017 at 01:55 PM

    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)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 15, 2017 at 09:58 PM
    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.