I already have a BEx query with exceptions defined to highlight projects that are over budget.
You can see in the above Analysis OLAP workspace that Analysis OLAP honors exceptions as “conditional formatting” – the flushing project is over budget.
I can send this to Design Studio by clicking the button shown above.
This is how it looks in a Design Studio application. You save the application in the BI Launchpad and open the application there.
The above shows how the application looks design time in Design Studio.
Notice at run time the conditional formatting from Analysis OLAP is not shown (i.e. the project that is over budget is not highlighted)
Back in design time, I select the Conditional Formatting property to True
Then Design Studio will show the project over budget in red (thus honoring the setting from the BEx Query)
hi,
Nice document …….. Thanks for sharing. 🙂
Thank you Tammy,
Is it supportable with BI 4.0 SP6 and DS 1.2 ?
No, Sathish, you need to be on BI4.1
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
Sandeep: which versions/SP of BI4.1 and Design Studio are you using?
Hi Tammy,
Sandeep and myself working on same issue.
Below are more details
OLAP Report : Version is 4.1 SP7
Design Studio : Version 1.6 SP02
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.
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
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