Unable to see Cube with Excel 2007

Question

Unable to see Cube with Excel 2007

spawny25

SSC Rookie

Points: 33
More actions
March 11, 2010 at 12:55 am

#212367

Hello,
I am currently working on a BI solution for our company. And i have a very unusual problem. We have two cubes. I was always able to see both of them when i chose the OLAP database in EXCEL 2007. Now for some reason I am unable to see the second cube. I have specific permissions on it (even though i should not need it because i am admin). I checked the cube with another install on another server (which i can see both cubes) and it is exactly the same so theoratically i should be able to see my second cube as well.
Can somebody point me in the right direction becacuse i really do not know where this goes wrong.
So in short i can see Cube A but Cube B is invisible for me. Ow and through SSAS i can access them both offcourse.
THank you in advance

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Adtjob Mr or Mrs. 500 Points: 526 More actions · Answer 1

Hi,

Its worth trying to run Profiler against the one which is working and then against the one which is not. Ensure that the credentials are getting passed across correctly. Also are you using kerberos authentication. In this case it might be something to do with the service account that sql analysis services runs under.

In terms of excel check the connection properties for both servers. It usually looks something like below

"Provider=MSOLAP.4;Integrated Security=***;Persist Security Info=True;Data Source=*******\MSSQLSERVER2008;Initial Catalog=***

I hope this gives you some thought of how to maybe resolve it. Let me know how you get on.

Thanks

spawny25 SSC Rookie Points: 33 More actions · Answer 2

First of all thank you very much for taking the effort of replying. I found what is the problem. I ran a report on the cbe and it says visible false. Now i only need to find out what happened and make it visible again. Once i find out I will post the solution

spawny25 SSC Rookie Points: 33 More actions · Answer 3

Yes fixed!

I was unable to find it in SSAS and could not find it very fast in the XMLA script that created the cube. SO i went one step back and checked the cube in visual studio (before deployment). There you can find the option fairly easy visible = false and visible = true.

Thanks for the help mate