Monday, December 5, 2011

Displaying Data Labels Inside the Vertical Bars on the Bar Chart Graph

There was a requirement for us where we needed to show the data labels inside the vertical bar graph. In OBIEE, by default it is set as on the top of each bar.


Data Labels position can be modified using editing pcxml Files which contain formats for Charts.

Update the  file column.pcxml ( this is the file for the Bar Charts) with "i
nsideBottom" .

This is the tag ,we need to update in the pcxml file:

<DataLabels Font='Size:9;Style:Bold;' Position='InsideBottom' TransparentBackground='False' BGColor='#FFFFFFcd' BorderType='None' /> 
ml files, then stop and restart the BI JavaHost and BI processes.

For a Bar Chart the File to modify is column.pcxml

This file must be found in 2 locations ,
1.- Back Up the files before modifying them
2.- <OracleBI>\web\app\res\<s_style>\charts
Example: C:\OracleBI\web\app\res\s_oracle10\popbin
3.- In the folder where the Projhect has been deployed in the app server
Example :C:\OracleBI\oc4j_bi\j2ee\home\applications\analytics\analytics\res\s_oracle10\popbin
4.-After this BI Services, Application Services and Javahost Service must be restarted
 

2 comments:

  1. can you please let me know how to do this obiee 11g
    Thanks,

    ReplyDelete
  2. Can this be done at the presentation level directly within a chart rather than a global change?

    ReplyDelete