When I right clink on the cube and "Browse", the screen goes into "Not Responding".

Question

When I right clink on the cube and "Browse", the screen goes into "Not Responding".

Viewing 7 posts - 16 through 22 (of 22 total)

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

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 1

I created a new Role and assigned the user to it. Gave Full Control permission and it started working. I did it from SSMS. When I tried same in Visual Studio, again the problem occured.

I restarted SSAS, Dropped and created the Role again in SSMS and it works...!

It may stop working later..

I don't understand what's wrong.

Thanks.

Smith.

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 2

Joy Smith San (2/16/2012)
I created a new Role and assigned the user to it. Gave Full Control permission and it started working. I did it from SSMS. When I tried same in Visual Studio, again the problem occured.
I restarted SSAS, Dropped and created the Role again in SSMS and it works...!
It may stop working later..
I don't understand what's wrong.
Thanks.
Smith.

Me neither. Do you self have enough permissions to do everything in SSAS?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 3

Yes... I have administrator rights.

This is quite emberassing... Everything is is fine.. gets deployed... gets processed... sucessfully. When opening Browser it's just "loading.........".

I see a query being generated while processing..

Will you be able to do anything if I send it ? Will it be useful ?

Thanks,

Smith.

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 4

Joy Smith San (2/17/2012)
Yes... I have administrator rights.
This is quite emberassing... Everything is is fine.. gets deployed... gets processed... sucessfully. When opening Browser it's just "loading.........".
I see a query being generated while processing..
Will you be able to do anything if I send it ? Will it be useful ?
Thanks,
Smith.

I won't be able to do anything, I don't have SQL 2005 installed.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 5

Hi All,

Has it got anything to do with the Internet Explorer version that's installed in the PC ?

Thanks,

Smith.

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 6

I doubt it, as SSMS and Visual Studio don't use IE to browse the data.

You can try connecting with Excel to the SSAS cube and see if you can create a pivottable.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 7

Hi All,

I don't know if it makes any difference. But tried something and it's working now. I also don't know if it will show the same issue later.

Actualy SQL Server and BIDS everything is installed in my local PC. And usually we will be in client's network by logging into client's VPN. I tried by disconnecting and restarting the PC (Only disconnecting VPN din't work). Din't connect to VPN at all and I was in local network. Tried ro browse both from BIDS and SSMS, and it worked. Tried many times by closing and opening again. It worked all the time.

Was that the real problem, any idea ? Anyone faced this issue ever ?

Thanks to all.

Smith.