Skip to Content

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.

2fitler.PNG

 

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:

3createwebapp.PNG

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

4dimfilter.PNG

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

5nocondformatting.PNG

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

6condformattingtrue.PNG

This is how it looks at run time:

7runtime.PNG

 

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

To report this post you need to login first.

1 Comment

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

  1. Kumar Raghav

    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.

     

    Thanks

     

    (0) 

Leave a Reply