Skip to Content
Author's profile photo Tammy Powlas

Activating Conditional Formatting from Analysis Office to Design Studio

I was not clear in the steps I took Checking out Features from Analysis Office to Design Studio  so I added more steps here in Analysis Office, where I set up the conditional formatting to send to Design Studio.


In my previous job, we had a daily “SitRep” aka Situation Report, with the usual red/yellow/green lights.  I programmed those in ABAP so the lights would display in the Web Application Designer on the portal.


Now I can avoid this by setting up the conditional formatting in Analysis Office as shown below, where I highly projects over budget in red:

1analysisofficetrend arrow.PNG


This time I am using the down arrow.



I also set up a filter in Analysis Office based on dates.  Then I select the Create Web Application ribbon which will take me to SAP BusinessObjects Design Studio:


Design Studio treats the date filter from Analysis Office as a Dimension Filter:


At start, the conditional formatting from Analysis Office is not honored (project is not showing a down arrow on over budget projects):


I set the Conditional Formatting property to True on the Crosstab and the down arrow appears:


This is how it looks at run time:



So perhaps Analysis Office can start as a prototyping tool and in Design Studio no code or even CSS was required to highlight over budget projects.  Note I am using Design Studio 1.2 and Analysis Office 1.4

Assigned Tags

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

      Hi Tammy,

      I'm trying to do conditional formatting on cross tab which is based on unx universe. As you suggested in couple of threads conditional formatting is not supported in unx universe and try to use Analysis Office to Design Studio. I'm looking at analysis office and there seem to be limitation on connecting to unx universe in analysis office. It would be really helpful if  you can provide some more information on using analysis office for conditional formatting based on unx universe.




      Author's profile photo Juan pablo Montero de Blas
      Juan pablo Montero de Blas

      Hi Tammy,

      Is it possible to apply conditional formatting to Cell Background?

      Thanks in advance & Regards


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

      Hi Juan - this is a really old blog post; may I ask that you ask this as a question at  Thank you