How to connect Oracle Database in Microsoft Analysis Services

Hi All,

I am not able to connect oracle database from MS-Analysis Services.

All my Fact tables and Dimension tables are residing on Oracle
database.Both the Oracle database and MS Analysis Services are on the
same server.

I am working on the node and I was able to create the datasource using
"Microsoft OLE DB Provider for Oracle " and the test connection also
succedded but while creating the cubes using the cube wizard it throws
error saying " Connection to the data source Failed".

Any one could help me in this regards.

What are the ways to connect the oracle DB from MS Analysis Services.

Is this problem becoz of any permission settings, how do I give permissions for the users.

Regards
Saravanavel

What users are you talking about?

Are you going to let someone else to design cubes using your data source? In this case anyone trying to run cube wizard should have permissions to access Oracle database. Cube wizard requires access to relational database.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.