Getting error BIA-4045 while connecting BI excel plug in with Oracle Olap cube

3241376

Hi All,

We are trying to create datasource for integrating Oracle BI excel Plug in  with Oracle Olap .

for Creating Datasource I have provided all the information Hostname ,port name and SID but its giving error BIA 4045 , I tried the same in Toad and I am able to connect it .

Any idea ,whats wrong here ?

Thanks,

Pallavi

[Deleted User]

Which precise version of which product are you talking about? Both sides by the way...your plugin and your Oracle DB with OLAP option.

3241376

Hi Christian,

Oracle DB with OLap option  is 12 c and excel Plug in is 11g ,thats the latest I could get in the Oracle website to download.

is there version mismatch?

Thanks,

Pallavi

[Deleted User]

No but which "plugin" are you talking about? SmartView?

3241376

here is the link  from where I downloaded and its called

OracleBI Spreadsheet Add-In 11g

Download OracleBI Spreadsheet Add-In

let me know if you have any questions

[Deleted User]

Question: Why are you using that one?

3241376

We are doing POC in our company where we want to see if Excel can be used by the business partners as a front end for Oracle olap cube to  view reports and data for  analysis.

So did some research and found out Oracle provides this plug through which we can integrate Oracle Olap cube .so I was trying to create data source to start off the POC.

Is there any other alternative where we can excel apart from this Plug in ??

Please let me know in case of any further question.

[Deleted User]

Ok it was a but surprising that you post this into the OBI(SE) community. For OBI the obvious answer is: Smart View. So you only want Oracle OLAP in Excel and I see you already have a whole list of threads over in the OLAP community so why not post this question there? OBI is really different tech stack and the name of the plugin is misleading...

3241376

Hi ,

I did but David suggested me to post in these forum mentioned below :  Can you please tell me where I can get answers for my questions . Our company is really planning to buy enterprise edition of Olap Cube I really need to provide them with these informations.

DavidBardwell-Oracle (to 3241376) 5 days ago

I want to make sure I understand exactly what you tried to do.

Did you download 'Oracle BI excel Plug' from this link? or something else?

Download OracleBI Spreadsheet Add-In

The Oracle BI Spreadsheet Add-in is an Oracle Business Intelligence technology not Oracle OLAP.

The OLAP Option of Oracle partnered with Simba who provides an integration point for the OLAP option for use with MS Excel.

This is the recommended way to work with Excel with Oracle OLAP.

Here is a link for this:

Using Microsoft Excel With OLAP Cubes

I am not familiar with the Oracle BI Spreadsheet Add-In. If this is exactly what you are asking about, I would ask the

Oracle Business Intelligence folks about how to use it and getting any forum support for your error.

David

ou may want to post this issue to the BI forum.

Business Intelligence Standard Edition One

another forum might be

Business Intelligence Applications

[Deleted User]

Neither really. Maybe try the main BI one which isn't necessarily tied to a specific product like the other two: