Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Cube browser hangs (SQL Server 2008 and XP)

Author  Topic 

marky222
Starting Member

5 Posts

Posted - 2010-10-28 : 13:04:49
Hello and sorry for my english.

I created cube and wanted to view it through browser cube. During this operation it hangs. I see only "loading" - nothing more. I have to kill the process, because without this I'm unable to back to normal work.

Could i ask for help? Thank you very much.

X002548
Not Just a Number

15586 Posts

Posted - 2010-10-28 : 13:10:01
What's a cube and what is it used for?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx





Go to Top of Page

marky222
Starting Member

5 Posts

Posted - 2010-10-28 : 13:12:32
Cube is used in Data Warehouse.
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-10-28 : 13:39:23
you have permissions on the cube?
Go to Top of Page

marky222
Starting Member

5 Posts

Posted - 2010-10-28 : 14:08:52
Yes, and even runs on full administrator mode.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2010-10-28 : 14:42:08
ok, how big is the data wharehouse, how is it built andhow long did it take to build the last time it was run?


"I use the BI tools..."




Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx





Go to Top of Page

marky222
Starting Member

5 Posts

Posted - 2010-10-28 : 15:14:05
Thanks for answers.

Sorry, i don't know, I just have to learn this and understand this. I completly new to SQL Server. So really sorry for my english, i hope you understand me.

1. I use this standard AdventureWorks database - just for test.
2. I created Analysing Service Project
3. I created New Data Source
4. I created New Data Viev
5. I created Cube

(i have script for that - I just need to follow step by step and to this moment everything went fine)

Ok - i have some minor problem with deploying and processing a cube. It hangs too, but i just stop deploying and start again and everything was ok.

And i clicked "Browse" in my Adventure Works DW.cube (because this is next step in my script) and i see "loading". For a very long time (more than an hour). Then again, and again. It just hangs...
Go to Top of Page
   

- Advertisement -