How to format "Percent of" in OBIEE pivot-tables

Sometime you want to set more then a digit for percent value. How to do that in OBIEE 11G. Here are steps to perform that.

Here is sample of report that we want to set 2 digit of decimal value

Go to advanced tab












Copy xml code to text editor then look for this xml code
<saw:dataFormat xsi:type="saw:percent" minDigits="1" maxDigits="1" scale="2"/></saw:formatSpec></saw:displayFormat></saw:showAs>

Replace minDigits and maxDigits value

<saw:dataFormat xsi:type="saw:percent" minDigits="2" maxDigits="2" scale="2"/></saw:formatSpec></saw:displayFormat></saw:showAs>

If you want to set 2 digit for decimal replace with above code.

Here is the result



Till next time