unable to browse data in cubes 2

[ajitt]

i am running mssql analysis server on a windows 2000 platform. I am able to process data in cubes, but cannot browse the data (error displayed: unspecified error). this error is common for all cubes i have generated (including teh sample cubes available for the foodmart database)

also while tyring to run the MDX sapmple application i am unable to connect to the provider. I am running mssqlserver olap service also.

 

[JayKusch]

Have you applied the latest service pack for Analysis Services? This may remedy your situation!


Thanks

J. Kusch

 

[ajitt]

thanks a lot , i applied the latest service pack for analysis server and it worked .

regards
Ajit

 

[Sres]

I had exactly the same problem, however I solved it myself. It's good to know that it isn't just me that got caught with this problem

 

[room24]

Hi i am having the same problem i have downloaded the latest service pak(spk2k3) and applied it but to no avail. What folder should it be intsalled to?? or how is the patch actually applied?? I am actually trying the foodmart database example

 

[jtamil2001]

update microsoft sql 2000 service pack 3a for ananlysis service

sql2kasp3.exe

Hope this will solve your problem

 

[Recce]

Good day,

I have applied the service pack a long time ago already however, I stil get the following error "Unable to connect to data". Does anyone have any suggestions as far as this is concerned. Thanks

 

[Recce]

Would anyone be able to say if the fact that, my users are running Windows NT and Office 97, is the cause for them not being able to see the Pivot Tables ? Thanks

 

[Bufsabres]

I am running Windows XP Pro and Office 2003, have applied the service pack, re-processed the cubes and nothing, same error "Unable to browse the cube".

 

[Recce]

Hi Bufsabres,

I am having some successes with the Windows 2000 and Office 2000 users but not with my NT users. I would like to remind you to add the site as a trusted site. That solved my problems on the Windows 2000 users. Let me know what's happening,

 

[Bufsabres]

Do you mean add a trusted site to my Internet Explorer's security tab? And which site is that?

 

[Recce]

Yes, that is correct, if you are browsing your cubes on the web then, I would suggest that you add the site from which you view it as a trusted site in IE on the security tab under Tools -> Internet Options.

 

[SQLBI]

Spot on JayKusch, was starting to tear my hair out.

Thanks.

Leigh Moore
Business Systems Manager
Vets4Pets Veterinary Group

http://www.vets4pets.eu.com