MS Office Integration with OBIEE 11g

I was interested to experiment the understanding of MS Office Integration with OBIEE 11g. Please find the detailed steps below to do so.

1. Go to the Home page and in the right corner you see Download BI Desktop Tools as shown below choose MS Office. exe file.




 2. Then install the file. I have encountered an issue because I didnt have the .Net Framework2. Please install it from the following link mentioned 

below.



 .Net2 Framework





3. Follow the screen shots mentioned below.











4. After the installation go to MS Office Excel or PowerPoint and when you open the application you will get a message as mentioned below.




     

5.Then we have to configure a server since we are doing it for the first time. for that once you click on OK you will be prompted with the screen below and  then click on new








 Here in

Server Name: Enter any name (eg. BI_Jethin)
BI Office Server: The server were 11g is hosted. In my case it is my local system so(eg. localhost)
Port: put it as 7001
Click on Test Connection and you are to get the message below



















6. After this step you can see Oracle BI tab in your Excel or powerpoint and then click on that and press Login.


7. You will encounter an error which is stated below for that we have to bring a change in the XML.






8.  Follow the below mentioned step to rectify this issue.

Go to the path mentioned below and edit the XML file


E:\OBIEE11G\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\bioffice_11.1.1\hsq62b\war\WEB-INF





 Here edit the tag



to




9. Restarted the services and after taht when you login again in Power point you will not face the issue and can use it.







Enjoy !!!







Advertisements

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 )

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