Skip to Content
Tammy Powlas
Tammy Powlas
January 2, 2014 1 minute read

Looking at Analysis OLAP to Design Studio

Follow RSS feed
2 Likes 1,421 View 8 Comments

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)

Assigned tags

Related Blog Posts

    Related Questions

      8 Comments
      You must be Logged on to comment or reply to a post.
      • Former Member

        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

          • Former Member

            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.