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.

How to choose the default hierarchy for a dimension?

I created a server-time dimension and generated several hierarchies within the same dimension, does anyone know how to select a particular hierarchy as the default one?

I didn't see it on the properties for the dimension or hierarchy.What is default hierarchy semantics that you are looking for ? I.e. what will it be used for ? What special treatment will it receive ?|||It's a time dimension and there are 3 hierarchies defined:
Reporting Year -> Reporting Quarter
Year - Quarter - Month - Date
Year - Week - Date

It seems as though the Reporting Year -> Reporting Quarter hierarchy is used by default, how would I change the configuration to use a different hierarchy by default?|||

Can you please explain what do you mean by

"It seems as though the Reporting Year -> Reporting Quarter hierarchy is used by default"

|||The 'first' heirarchy is the default hierarchy. IE: The left most heirarchy in your model.

C|||Chris - can you please explain what does "default hierarchy" means in AS ? Thanks !|||From your browsing client, If you grab a Dimension containing multiple hierarchies, and drag it over (by whatever means you're using) to your Rows, or Columns, or Filter etc... it will show your default hierarchy.|||Ah, that explains it. Sorry for my confusing terminology. Thanks, Chris + Mosha.