I already have a BEx query with exceptions defined to highlight projects that are over budget.

1bexqueryaolap.PNG

You can see in the above Analysis OLAP workspace that Analysis OLAP honors exceptions as “conditional formatting” – the flushing project is over budget.

1copends.PNG

I can send this to Design Studio by clicking the button shown above.

2opensinds.PNG

This is how it looks in a Design Studio application.  You save the application in the BI Launchpad and open the application there.

3indesignstudio.PNG

The above shows how the application looks design time in Design Studio.

4runtimenocond.PNG

Notice at run time the conditional formatting from Analysis OLAP is not shown (i.e. the project that is over budget is not highlighted)

5condiformattingcrosstab.PNG

Back in design time, I select the Conditional Formatting property to True

6runtimecondformatting.PNG

Then Design Studio will show the project over budget in red (thus honoring the setting from the BEx Query)

To report this post you need to login first.

8 Comments

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

  1. sandeep thandra

    Hi Tammy,

    Thank you the document. I tried your approach and it is working out fine for background changes, but the text formatting is not reflecting. Is there any bugs or restrictions for text formatting. We are in BO 4.1

    (0) 
      1. Chandra Mohan Reddy Bhogireddy

        Hi Tammy,

        Sandeep and myself   working on same issue.

        Below are more details

        OLAP Report : Version is 4.1 SP7

        OLAP Report.PNG

        Design Studio : Version 1.6 SP02Design Studio.PNG

        there are two issues ,

        1. As you see in screen shot of OLAP report,  we have conditional formatting for both background and values , where as in the design studio we are getting  for background only  .

        2. In OLAP Report we have applied Percentage formatting and values are shown with percentage , where as in Design studio the Percentage formatting not applied

        Could please suggest if we have any sap notes or any solutions.

        Thanks in Advance ..!!

        Chandra.

        (0) 
        1. Tammy Powlas Post author

          Chandra – if you are looking for a fast response, I recommend creating a new discussion thread; I don’t know when I will have time to look at this.  Please create a new discussion and let the community help

          (0) 

Leave a Reply