icarus2256
asked on
OLAP Cube is not visible from Client
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?
Can you browse the cube in SQL Server Management Studio?
ASKER
Yes I can.
Have you tried running Profiler to see if you can see authentication errors, etc.?
ASKER
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.
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)?
ASKER
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.
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?
ASKER
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.
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.
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.
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.
Hi icarus2256,
I have the exact same problem today, did you find a solution?
Thanks,
Vincent
I have the exact same problem today, did you find a solution?
Thanks,
Vincent
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.