Checking out Features from Analysis Office to Design Studio
I am using Analysis Office 1.4 SP5 and SAP BusinessObjects Design Studio
First I create the Analysis Office workbook with Conditional Formatting to highlight projects over budget. I include a cross tab and a chart. Below is how it looks in Analysis Office:
I included some filters in Analysis Office as well.
I click the “Create Web Application” button in Analysis Office. This takes me to Design Studio:
Note that it doesn’t highlight the conditional formatting for projects over budget until I set the Conditional Formatting property to True on the Crosstab, as shown below:
This is how it looks at run time in Design Studio:
I can interact and select the filters as well.
So in less than 5 minutes I can “mobilize” Analysis Office with no programming required. I need to work on the spacing some more so it is not so crowded with the filters in the future.
Nice 🙂 .
Hi Tammy.
Did you use a spesial CSS file to get the circles into the crosstab?
Is it possible for you to share the syntax ?
I tried the same in Las Vegas at Tech-ed, but only got the colored cells not the icons/cirkles.
Ingrid
Hi Ingrid - I did not use CSS
In Analysis Office I defined the conditional formatting and set it to a status symbol - see below:
Good luck!
Thank you Tammy
Ingrid
Hi again Tammy 🙂
We were hoping this could apply for conditional formatting set from the Bex Query,
and directly in Design Studio.
We expected the conditional formatting from the Bex Query could be interpreted into either background colour or status symbol. Directly in Design Studio.
In Analysis for Office, I am not able to change the display of the conditional formatting from bex. I have to make new ones to get the status symbol.
It might be that my SP is to low. I am currently on 1.4.0.2528.
Best Regards Ingrid
Hi Ingrid,
You can activate the BEx exceptions from the Query Designer in Analysis Office but I do not think you can change them.
In my case, I created the conditional formatting in Analysis Office
In your case, I think it would be good to upgrade to 1.4 SP5 Analysis Office.
On this:
I haven't tried this, but to me this is not expected behavior. I will try later today (the work day started here) but that is my take.
I know it is not possible for today,
but I hope this will be possible in the near future.
Maybe with CSS ?
Ingrid
Hi Tammy
this is a very cool functionality. i am developing Design Studio Application for Data Source "HANA CDS view". and HANA CDS view can not provide Conditional Formatting. using your method, i can connect my CDS view to Analysis Office, within AO, i extend the data source by introducing in the conditional formatting. and then from AO, i  move on with "create web application".
now, i met a problem:
after the Design Studio application was published to BI platform, when i execute the application from the BI launchpad, i could not see the result, but 2 error messages: could not instantiate the data source. and Can not load query.
am i missing any configuration within Design Studio? thanks Tammy!
Lizho, when you do this, you need to be on the same platform
For example, you need to use Analysis Office on the BI Platform and then use Design Studio on the BI platform