Changing the Precession of Percent of columns in Pivot table of OBIEE

14 Sep

We have an added feature “Percent of” to find the percentage for a measure w.r.t a dimension in pivot table. Here using this “Percent of” feature we will get the percentages up to single Decimal place only.
If the requirement comes like to increase the Decimal places for this percent of calculated columns. In OBIEE there is no direct option to achieve this requirement. For this we need to alter the Advanced XML to achieve this.
The detailed procedure is as follows. I had worked this task with Paint Repository (Which came by default with OBIEE)

1. Take Markets. Region and Sales Measures. Dollars from Criteria
2. Go for pivot view
3. And create one duplicate column for dollars and rename the duplicate dollars column as “Percentage of Region”
4. Now to get the “Percentage of Region” values as percentage of dollars w.r.t Region go for column properties tab and click the Show Data As->Percent of->Column

5. Now we will get the percentage of values for “Percentage of Region” Column

6. Here Observe the percentages values and their Decimal places, we have only one decimal place for the values

7. Now to increase these decimal places we need to alter the Advanced XML as there is no direct option to do this.
8. Click the Advanced Tab to alter the XML

9. To Increase the Decimal places for percent of column we need to change the “mindigits” and “maxdigits” values to require no. of Decimal places we want to search for the “minDigits” and “maxDigits” tags

Percentage of Region

10. Now change this mindigits and masdigits values to ‘3 ‘ to get 3 decimal places percentage values

Percentage of Region

11. Now click the button and view the results in pivot table
12. And observe the results for percent of column with 3 decimal places as follows

13. By this way we can show the required no. of decimal places for pivot table’s percent of column


Posted by on September 14, 2008 in OBI EE


9 responses to “Changing the Precession of Percent of columns in Pivot table of OBIEE

  1. Sid

    October 7, 2009 at 3:27 am

    Good post. Even some simple formatting can get complicated for the end users sometimes 🙂

  2. Krishna

    October 8, 2009 at 1:42 pm

    Was looking for this buddy 🙂 Awesome Post


  3. Ramarao

    February 21, 2011 at 1:02 pm

    Good Post

  4. Suresh

    March 22, 2011 at 3:57 am

    Super Post

  5. Aruna

    August 22, 2011 at 9:18 pm

    Awesome Post….Keep posting like this….

  6. cinds

    May 29, 2012 at 4:17 pm

    Hi.. How to do this in graph view???

  7. James

    July 3, 2012 at 10:01 am

    So useful.
    Thanks a lot.

  8. Nishaz

    October 14, 2013 at 7:10 pm

    Thanks. Fixed an issue in our project

  9. Tiffany VanderZanden

    August 24, 2015 at 10:35 pm

    Is there a way to do this when the original criteria is a direct database request? In these instances there is no advanced tab.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: