Skip to Content
Author's profile photo Tammy Powlas

Looking at Analysis OLAP to Design Studio

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

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      hi,

      Nice document ........ Thanks for sharing. 🙂

      Author's profile photo Sateesh Kumar
      Sateesh Kumar

      Thank you Tammy,

      Is it supportable with BI 4.0 SP6 and DS 1.2 ?

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      No, Sathish, you need to be on BI4.1

      Author's profile photo sandeep thandra
      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

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Sandeep: which versions/SP of BI4.1 and Design Studio are you using?

      Author's profile photo Chandra Mohan Reddy Bhogireddy
      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.

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog 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

      Author's profile photo Chandra Mohan Reddy Bhogireddy
      Chandra Mohan Reddy Bhogireddy

      Hi Tammy,

      As you recommended I have created a new discussion , please find the below thread

      http://scn.sap.com/thread/3949474

      Looking for fast resolution