Victor Fagundo, in ORACLENERD, discussed the problem of while calculated items in OBIEE are easy and flexible, they do have one important drawback: they take on the data and display formatting of the fact column they are calculated against.
He discussed 3 possible and common solutions:
Use HTML formatting tricks to “hide” trigger text in the results, then conditionally format off those triggers.
Convert the pivot table to a regular table with some complex column formulas.
Convert the calculated result to text and manually add your formatting characters.
He then explained another solution – read the blog here.
In his blog of September 10th, Jeff McQuigg states the Single Most Important Thing to Know About the OBI RPD is Dimensional Hierarchies. He advises to follow three simple rules a) get into the habit of doing it correctly from the beginning, b) make sure that the stuff you build works, c) be prepared for when your RPD grows much larger – pay a dollar now or 10 later.
Have you ever sailed faster than the wind?
Challenge yourself and your friends by helming Oracle Team USA 17, the defender of the 34th America’s Cup! Download the Oracle Team USA game for Android or iOS now!