Thursday, January 17, 2008

OBIEE adding a customized graphtype

One of our customers had the need for some extra customized graphtypes in answers. It took me a while to figure out how OBIEE connects but here is how we did it.

  1. In the map {OracleBI}\web\app\res\s_oracle10\popbin make a copy of the PCXML for the graphtype you want customize.

  2. rename the file [FI:bubble2.pcxml]

  3. Open the file and make the custyomistions you want

  4. In the map {OracleBI}\web\app\res\s_oracle10\charts make a copy of the CXML for the graptype you want to customize.

  5. rename the file [FI:bubble2.cxml]

  6. open the file and edit in sawc:template => displayNameRef="kmsgChartCustomBubble"

  7. edit in sawc:seriesRules => displayNameRef="kmsgBubbleCustomSeries"
  8. edit in sawc:engineSpecific file="popbin/bubble2.pcxml"

  9. Save and close the file.

  10. Next we have edit the messages !you have to this for every language you use! (remember to back it up, else you loose it after every (re-)install/update of OBIEE) [EDIT: or make a custommessage folder for each language] go to {OracleBI}\web\msgdb\l_en\messages

  11. open "chartmessages.xml" and add the entry <-WebMessage name="kmsgBubbleCustomSeries"><-TEXT>Bubble - Custom

  12. Save and close the file

  13. open "charviewmessages.xml" and add the entry <-WebMessage name="kmsgChartCustomBubble"><-TEXT>Bubble - Custom

  14. Save and close the file

  15. restart the Java-host and the prestationserver.

note: replace "<-" with "<"

Till Next Time


Anonymous said...

How to show a dot or some mark for zero values in chart. For example. there product on y-axis and bug count on x.axis. For particular product bug count is zero then i get to see just the product name on chart no indication of bug count as zero in chart. Any suggestion?

John Minkjan said...

have a look here:



Anonymous said...

Thank you so much for giving this solution.