Solved

OLAP Cube is not visible from Client

Posted on 2008-06-10
11
1,073 Views
Last Modified: 2013-11-16
I recently restored a new cube to our SQL Analysis services database.  The problem is that I can't browse the cube from Proclarity or reporting services.  The interesting thing however is that if I manually type the cube name into reporting services it connects to it just fine, but I can't browse and see it.  The other problem is that I can't manually type a cube into the proclarity client so I can't connect that way.  Any ideas?
0
Comment
Question by:icarus2256
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
  • +1
11 Comments
 
LVL 2

Expert Comment

by:influent1
ID: 21754270
Can you browse the cube in SQL Server Management Studio?
0
 

Author Comment

by:icarus2256
ID: 21754285
Yes I can.
0
 
LVL 2

Expert Comment

by:influent1
ID: 21754300
Have you tried running Profiler to see if you can see authentication errors, etc.?
0
Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

 

Author Comment

by:icarus2256
ID: 21754319
Remember that I can view the cube out of reporting services when I manually type the name of the cube in, but Proclarity doesn't allow you to manually type in a cube name.  Because of that I don't see how it could be an authentication issues.
0
 
LVL 2

Expert Comment

by:influent1
ID: 21754353
I realize that doesn't make much sense but it'd be nice to know if anything is happening on the database server when you try to browse through RS without typing in the name.  Can you restart the RS service or ProClarity (I know nothing about ProClarity)?
0
 

Author Comment

by:icarus2256
ID: 21754373
I have tried restarting services already to see if it was an analysis services issue, but no luck.  I also did a backup of the database and then a restore to another server, but it also had the same problem.  Proclarity is a very popular OLAP client tool now owned by Microsoft.  Microsoft Performance Point implements a thin client Proclarity via Sharepoint.
0
 
LVL 8

Expert Comment

by:srnar
ID: 21758257
It seems like you have either problem to connect to Olap from ProClarity - are you using Desktop edition or PAS - or there are some security settings on Olap (e.g. read definition disabled). Are you aware of one of this issues?
0
 

Author Comment

by:icarus2256
ID: 21761244
srnar:
Reporting Services when browsing for a cube can't view it either, but Reporting Services allow you to manually add the data source which when I use that I can connect.  Proclarity however does not allow you to manually add the data source only browse.  I am using the full Proclarity client app.
0
 
LVL 8

Expert Comment

by:srnar
ID: 21763973
Sorry I forgot to mention both issues:
1. security issue - you did not answer - so I assuem it is not the source of the problem
2. (forgotten) - do you have default installation (only server name) of Analysis services or named (serverName\Instance) - what is the connection string when connecting to your Cube? There is sometimes problem with IP port where named Analysis services listen.
0
 

Expert Comment

by:larchevv
ID: 22064537
Hi icarus2256,

I have the exact same problem today, did you find a solution?

Thanks,

Vincent
0
 

Accepted Solution

by:
icarus2256 earned 0 total points
ID: 22115239
I solved the problem.  There was some corruption in the cube so I completely recreated it and have no problems now.  The strange thing was that Reporting Services could connect to it just fine so the corruption must have been isolated in a specific partition not affecting the entire cube.
0

Featured Post

Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question