OLAP Cube won't rebuild

W

wacNTN

Our OLAP cube is not rebuilding. The admin page shows that the cube rebuild
was initiated but it never changes to completed.

This has worked fine for quite some time and it just stopped working.

Our DBA can manually rebuild the dimensions and cubes w/o any errors but we
don't see any change in our analyzer views.

What should we look at?

Thanks,

Walter
 
M

Marc Soester

Hi wacNTN,

We experienced the same issue a couple of weeks ago. I deleted the Cube and
Connection from Analysis Server and then rebuild the cube from Project
Server. This solved the problem.
I hope this works for you
 
M

MikeN

wacNTN said:
Our OLAP cube is not rebuilding. The admin page shows that the cube rebuild
was initiated but it never changes to completed.

This has worked fine for quite some time and it just stopped working.

Our DBA can manually rebuild the dimensions and cubes w/o any errors but we
don't see any change in our analyzer views.

What should we look at?

Thanks,

Walter
 
M

MikeN

One other item to note is that if you rename the cube you will have to
rebuild the Analyzer views also
 
M

Marc Soester

You dont need to rename the cube, just delete the connection in Analysis
Server and rebuild the cube Process in PWA with the same name. This will
recreate the cube with the original connection name.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top