One of the new features in Design Studio 1.3 is setting up Conditional Formatting without relying on the underlying BEx query set up.

/wp-content/uploads/2014/05/1fig_463067.gif

First as shown above I select a chart, and one of the properties is Conditional Formatting.

/wp-content/uploads/2014/05/2fig_463068.gif

Create a new rule by clicking in the “New Rule” button.

/wp-content/uploads/2014/05/3fig_463069.gif

In my example I want to highlight in red projects over budget.  I name the rule and state that if the balance is less than 0 show it in red.

/wp-content/uploads/2014/05/5fig_463073.gif

The example above shows the project overbudget in red.

This is very easy to set up and you don’t have to rely on the BEx query to set up conditional formatting.

Related:

Design Studio Sessions at ASUG Annual Conference in June (next week)

Suggestions to Install Design Studio 1.3 Client

BI 2014 Design Studio and Dashboards – Looking to the Future


If you are interested in SAP Delta training for Design Studio, please see Design Studio 1.3 Delta Training – WDES13 available and comment.

To report this post you need to login first.

10 Comments

You must be Logged on to comment or reply to a post.

  1. RAJAN Patel

    Thanks for sharing Tammy. I was expecting advanced formatting for Crosstab in 1.3 release similar to Charts. but no update on it! I am working on big project on Desing Studio and have lot of drill downs and custom headers n more on Crosstab.

    Is there any plan for enhancing Crosstab properties options?

    Thanks,

    Rajan

    (0) 
  2. Juan Carlos Velez

    Hi Tammy,

    Thanks a lot for this information.

    Now I am working with DS 1.3 SP01 and I am trying to apply conditional formatting to a Tree Map but it doesn’t work.

    I always get the standard green color.

    The point is that in DS 1.3 but when I opened the dashboard in SP01 it didn’t work. I have also tried rebuild the chart but it still does’nt work.

    It seems as if the start-end colors always prevail over the conditional formatting.

    Has anyone faced this issue?

    Thanks!

    (0) 
    1. Tammy Powlas Post author

      Juan – I just tried it on a treemap and it works for me.

      Maybe create new discussion thread with more details here on the forum and use the camera icon to share your chart, conditional formatting and the community can help see why it may not be working.

      (0) 
      1. Juan Carlos Velez

        Hi Tammy, thanks for quick response.

        I’ve tried again and building the chart from scratch on SP01 works fine but the charts migrated from 1.3 don’t work fine, I think we will have to rebuild them.

        Thanks for the information.

        (0) 
  3. Sara G Iyer

    Hi Tammy,

    I am in need of dynamic conditional formatting in charts, to be done in design studio level. I am using Design Studio 1.4 version.
    I couldn’t find any positive result from the relevant threads or blogs/document posts, all of them stated it can’t be done in DS without having the exceptions declared in BEx.

    https://ideas.sap.com/D25419

    Could you please help?

    Best Regards,

    Sara

    (0) 
    1. Mike Howles

      Hey Sara, I hope you are doing well!  I don’t have a specific answer to your question, however this is a relatively old release (and discussion thread.)  You may be stuck with a lot of limitations in 1.4.  Do you have plans to move off of it soon?  The SAP PAM states that 1.4 reaches end of maintenance in Nov of this year.  Many more options available in higher releases!

      (0) 
      1. Sara G Iyer

        Hey Mike, Am good, Thanks ,hope you are doing good too !

        Thanks again for your prompt reply! I ll look for the possibility to get it upgraded to 1.6. J

        (0) 

Leave a Reply