Skip to Content

Apply conditional formatting- Crosstab based on Universe- SAP design studio 1.6

Hi guys

I have a crosstab based on a BO universe where it has a set of columns for table names and some columns for flags which say Y or N based on the state of the table- fully loaded/partially loaded.

I want to apply some conditional formatting to show a green box when the load flag is 'Y' and red box when its 'N'...

How do I do that?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Apr 11, 2017 at 09:12 PM

    Hi, In my Opinion using universe you can not define conditional formatting because cross tab conditional formatting options inherit from bex alerts.

    Not sure if some one can give better suggestions...But incase if your table list is not very huge and dyanmic then i have an option to call colours or alerts for the data.

    BR,

    Lakshmikanth Adharapurapu

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 12, 2017 at 10:35 AM

    Hi,

    There is no option to do conditional formatting using Universe in crosstab. Instead of that I like to suggest you to use Scorecard component.

    Please refer the below URL,

    https://blogs.sap.com/2015/12/29/introduction-to-sap-design-studio-scorecard-component-part-2/

    Regards,

    Vidhya.C

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 15, 2017 at 09:10 AM

    Since my table dos not have any 'Measure' values, I am not sure if the scorecards will work

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks Lakshmikanth!

      looks really technical to me...

      I am still learning design studio so don't know how long it will take me to create this.... any help from you will be greatly appreciated.. would love to know how you learnt Design studio using BI universes as I find it really hard to find any useful links relating to creating apps using BI universes...

      thanks

  • Jul 25 at 06:58 AM

    Why not try to upgrade to Lumira Designer 2.x version. It has more features and capabilities then the 1.6 version and it is possible to create conditional formatting inside the Designer and use this on your crosstab.

    Add comment
    10|10000 characters needed characters exceeded