re-creating cube

N

Nik003

I had a cube working, now we needed to redesign the RBS, and now I want to
re-create the cube. How do I remove the existing cube, and create a new one?
I can't find any documentation on this.

Thanks
 
B

Ben Howard

The cube(s) is recreated each time you build it, therefore deleting it is not
necessary. Not sure what version you are using, but both cube configuration
pages are found in the admin pages of PWA. The cubes are generally scheduled
to build each night, or for testing purposes, you can initiate a build.
 
D

Dale Howard [MVP]

Nik003 --

When the OLAP cube rebuilds again as scheduled, it will recreate itself
using your new RBS information. Hope this helps.
 
Y

yme

Hi everyone,

I have a similiar issue but my problem is that the Cube doesn´t have
any information related to RBS.

Can you tell me if there is any special procedure beside rebuilding
the Cube?




Dale Howard [MVP] dot at dot escreveu:
 
N

Nik003

Cube rebuilding fails with the following error:

Failed to build the OLAP cubes. Error: Analysis Services session failed with
the following error: Failed to process the Analysis Services database
IBS_ProjectServer_OLAPCube on the IBS-EPMTFS-SQL server. Error:


This is tracked in the steps:

===== Initiating cube build process =====
[29/06/2007 8:00 AM] Cube build request message has been added to the
Project Server queue
===== Verifying and running pre-build server event handler =====
[29/06/2007 8:00 AM] Verifying and running pre-build server event handler
===== Determining database and cube structure =====
[29/06/2007 8:00 AM] Cube build initialization started
[29/06/2007 8:00 AM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[29/06/2007 8:00 AM] Cube build session started
[29/06/2007 8:00 AM] Analysis Services session started
[29/06/2007 8:01 AM] Analysis Services session completed successfully
===== Verifying and running post-build server event handler =====
[29/06/2007 8:01 AM] Verifying and running post-build server event handler
===== Processing OLAP database =====
[29/06/2007 8:01 AM] Process OLAP database session started
[29/06/2007 8:01 AM] Analysis Services session started
[29/06/2007 8:01 AM] Analysis Services session failed with the following
error: Failed to process the Analysis Services database
IBS_ProjectServer_OLAPCube on the IBS-EPMTFS-SQL server. Error:
===== Process Completed =====
[29/06/2007 8:01 AM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Failed to process the
Analysis Services database IBS_ProjectServer_OLAPCube on the IBS-EPMTFS-SQL
server. Error:


Unfortunately there is nothing after the last Error: ... The logs are not
too helpfull either, not pointing me in any direction. As I was saying, this
happened after rebuilding the RBS and changing a couple of Enterprise Custom
Fields in Project Server 2007. I am afraid that we might have changed one the
cube's dimensions, so the cube can not build anymore, but I can't figure out
how to re-create it...

Thanks.
 
N

Nik003

The cube ended-up rebuilding itself as you said, but it took it 4 days (plus
the weekend possibly). During all that time it kept on failing. This is
weird, as I don't even know why the delay, and what to do next time besides
wait...
 
Top