OBE   OBIEE   Tutorial     
          Using Oracle BI Office Add-Ins  




Setting up the “Paint” repository and catalog


Q: The Office Add-Ins tutorial says to use the “Paint.rpd repository and the Paint Demo presentation catalog”.  How do I set these up?


The “paint” repository and catalog are copied to disk as part of the default installation procedure.  All you have to do is to modify the configuration files so that OBIEE will make use of them.


To configure the BI Server to make use of the “paint” repository, navigate to directory “<oracleBI home>\server\config”, and edit the configuration file “NQSConfig.ini”.  In the “repository” section of the file comment out the current default repository definition, and add a definition for the “paint” repository; for example:


#Star = sh.rpd, DEFAULT;
Star = paint.rpd, DEFAULT;


To configure the BI Presentation Services to make use of the “paint” catalog, navigate to directory “<oracleBIData home>\web\config”, and edit the configuration file “instanceconfig.xml”.  Comment out the current catalog definition, and add a definition for the “paint” catalog; for example:


<!-- <CatalogPath><HOME>/web/catalog/sh</CatalogPath> -->


where "<HOME>" is the Oracle BI Data home directory.



Location of configuration file "bioffice.xml"


Q: The Office Add-Ins tutorial refers to the bioffice.xml configuration file.  I can’t find it in the Office directory under OBIEE?


Logically, that’s where you might expect to find it!  But, instead, you’ll find it in directory:


*  <oracleBI home>\oc4j_bi\j2ee\home\applications\bioffice\bioffice\web-inf



Can’t find “Chart Object” menu item


Q: In the Office Add-Ins tutorial in PowerPoint it says to “right-click the chart and select Chart Object > Edit”.  When I right-click on the chart the pop-up doesn’t have a Chart Object menu item.  Is this because I’m using PowerPoint 2003 instead of 2007?


No, “Chart Object” is supported in PowerPoint 2003.  I suspect the reason the menu item is missing is because you’ve inserted the chart as an image, which is not editable, instead of as a PowerPoint chart, which is.  When you insert a chart by right-clicking on a particular chart node in the “Presentation Catalog” window within PowerPoint you’ll see options of “Insert”, “Insert as Image”, and “Insert as Flash”.  The last two options will create non-editable images that look similar to the chart you’ve seen in BI Answers.  The first option will produce a PowerPoint chart that contains most of the same information, but which will look rather “rough-n-ready” by comparison.  It’s this first option that you need at this point in the tutorial.