Business Intelligence – Oracle

Oracle BI EE 10.1.3.3/2 – Changing Column Indent Color in Pivot Tables

Posted by Venkatakrishnan J on March 7, 2008

I saw another question in one of the forums today wherein the user basically wanted to change the Column Indent Color in a Pivot table. As you might know, all the attributes of a pivot table are exposed to end users and can be customized using Section, Page and Column properties. But in the case of Column Indent there is no property in the UI to change the background color. If you are not sure what i mean, check the sample Pivot table below

      

The above pivot table shows you the Column Indent. Unfortunately, there is no property within the pivot table to change this color. lets look at an approach today to change the color of this cell. Remember, by following the below method, it will affect all your Pivot tables. The steps to modify this color are

1.   Go to {OracleBI}\web\app\res\s_oracle10\b_mozilla_4. Open the Views.css file in a text editor and Search for PTIndentCell. This is the Property which handles the color of the column indent. Now, change the background color to the desired color. For example,

.PTIndentCell {
background-color: #CC3333;
}

      

2.   Save the above file and repeat the same procedure to the Views.css file under {OracleBI}\oc4j_bi\j2ee\home\applications\analytics\analytics\res\s_oracle10\b_mozilla_4.

3.   Restart Presentation Services. Now, if you go to your pivot table, you would notice that the color for this cell would have been changed.

      

But just be careful while doing this since it would affect all your pivot views. Use this approach only if you have no other choice.

Advertisements

3 Responses to “Oracle BI EE 10.1.3.3/2 – Changing Column Indent Color in Pivot Tables”

  1. Philippe Lions said

    Hi,
    here is an adapt that I think reduces impact of the change to only a single dashboard page, and not the whole system. This works on my test setup, and could be applied to other css format classes : create a static text view in the dashboard page where you post your report with the pivot table, or on the report itself, that contains : .PTIndentCell {background-color: #FFFFFF;}
    Make sure you tag the ‘html content’ on that view. Run the dboard, you should see this impacts only the pivot table formatting for the dboard page you are looking at, not the other pages.

  2. VIjay said

    Please can you provide me snaps of how to apply css property to particular dashboard.
    As I tried a lot but was unsucessfull.
    kindly mail me on vijay.yajurvedi@gmail.com

  3. Nilley said

    Hi,

    I need, change border style en this example cell “Year”. I Changed PTRH and PTIndentCell, I included this propertys:
    border-width: 1px 1px 1px 1px;
    border-style: solid;
    border-color: #000000;
    padding: 2px;
    but, and I don´t see any change.

    Thanks for help me.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

 
%d bloggers like this: