Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Problem processing cubes on Oracle DB :(

Problem processing cubes on Oracle DB :(

Problem processing cubes on Oracle DB :(

Hi there,
newbie to Analysis Services.

My warehouse is on Oracle, and I've created MyOracleDB as the data source of my Analysis Server.  I can connect to the data source, browse the tables, create cubes and dimensions.  

However, when I try and process a dimension , I receive the ORA-12154 error: TNS cannot resolve service name.  

Can someone suggest why this might be, when I can see the Oracle database when I'm creating the objects?


RE: Problem processing cubes on Oracle DB :(

*edit* I mean process a Cube.  The database is in my TNSNAMES.ora (I can connect when I'm defining the objects, but not when I'm processing them).

RE: Problem processing cubes on Oracle DB :(

In its wisdom, Analysis Services uses the Oracle "HOME" string in the registry to find the TNSNAMES.ora.

When you're building the cube and the dimensions, it finds TNSNAMES.ora ok using HOME1, but then when you want to run the cube, it decides to use HOME0 as the Oracle Home directory - and I didn't have TNSNAMES.ora.

Why can't Microsoft write the software to use a standard Oracle Home location?  Just wasted my time faffing around for this.  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close