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".

Joy Smith San

SSC-Insane

Points: 24877
More actions
February 13, 2012 at 3:29 am

#256680

Hi,
I created a simple cube by following exactly the same steps as mentioned in the below link.
http://www.accelebrate.com/sql_training/PDF/SSAS_tutorial.pdf"> http://www.accelebrate.com/sql_training/PDF/SSAS_tutorial.pdf
Everything works fine and cube got deployed successfully as well. The problem is when I browse it.
When I right clink on the cube and "Browse", the screen goes into "Not Responding". Looks as if it's stuck.
Is it normal ?. How long will I have to wait for the browser to open for the above cube to open ?. Or is there any other settings that I need to do ?.
Can anyone help me please...
Edited ==> It's SQL Server 2005 with SP4. Windows XP professional (32 bit, SP3)
Thanks in advance.
Smith.

Viewing 15 posts - 1 through 15 (of 21 total)

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Can you browse the cube in BIDS?

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 2

..No. I tried in BIDS as well as in SSMS... It juts hungs.. not opening at all.

Searched in google, found many people facing the same issue, but no solution at all.

Getting lost.

Thanks for the response.

Smith.

herladygeekedness SSCertifiable Points: 5878 More actions · Answer 3

herladygeekedness

SSCertifiable

Points: 5878

February 14, 2012 at 11:04 am

#1446975

Has it processed successfully? Process FULL.

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

Everything's done.. but no luck. What else could be the problem ?

I saw many people posted the same issue on different forums. But nowhere the proper solution is given.

Dou want me to give any further details of the cube ? Everthing gets completed successfully (proces... deploy...), but only the browser is not opening.

Since 3 days I am strugglinh with this now.

Missed...... I have MS Office 2007 installed in my PC. Does it make any difference ?

Thanks for the response.

Smith.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

Joy Smith San (2/14/2012)
Missed...... I have MS Office 2007 installed in my PC. Does it make any difference ?

No.

Do you have permissions to browse the cube?

Do you have calculations in your cube (MDX)?

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 6

Do you have permissions to browse the cube?

I am using windows authentication and my id has "Sysadmin" role.

Do we need to create/assign any roles or rights in Analysis Service. ?

Do you have calculations in your cube (MDX)?

I created the cube by following exactly the same steps as mentioned in the below link.

http://www.accelebrate.com/sql_training/PDF/SSAS_tutorial.pdf

I am totally new to Analysis service. Kindly guide me if anything else to be checked ?

Thanks a lot.

Smith.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 7

When you installed SSAS, did you include yourself as Administrator.

SSAS Administrator <> database administrator

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 8

Koen Verbeeck (2/15/2012)
When you installed SSAS, did you include yourself as Administrator.
SSAS Administrator <> database administrator

I don't remember. Where to check now ?

Thanks.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 9

Log in into SSAS using Management Studio. Right click on the server, select Properties and look at the security tab.

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 10

Nothing was there in security tab. I added my login there and am able to BROWSE in management studio now. Thanks a ton.

In visual studio, it still doesn't open. Do I need to recreate the cube ?

Thanks again.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 11

Joy Smith San (2/15/2012)
Nothing was there in security tab. I added my login there and am able to BROWSE in management studio now. Thanks a ton.
In visual studio, it still doesn't open. Do I need to recreate the cube ?
Thanks again.

Hmmm. Try processing the cube again in BIDS.

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 12

Thank you somuch....... It started working now.

Almost 3 days I was struggling with this. I hardly know Analysis Service. So I couldn't even look into the possible issues also.

Thanks a lot again.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 13

Joy Smith San (2/15/2012)
Thank you somuch....... It started working now.
Almost 3 days I was struggling with this. I hardly know Analysis Service. So I couldn't even look into the possible issues also.
Thanks a lot again.

Allright. Glad that you got it working!

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 14

It opened as expected.

I placed some of the fields in rows and some amount field in Totals.

When I was placing the fields in Columns, it got hung. When I added the first field it shows the "Totals" properly. After that the same problem again... "Loading.............". both in Visual studio and SSMS.

Anyway, I will scrap everything and create a new project right from the beginning.

Let me check.

Thanks.