Corrupted data in olap cube

[Jan M.]

Hello,

There are 25 projects in our database. Cube data is correct for all projects
exept one:

Work reads 74 000 hours instead of 10 000,
Actual work reads 24 000 hours instead of 4 000,
Baseline reads 77 000 hours instead of 12 000.

The cube is built every week and every other project data is updated
correctly, but rebuilding the cube isn't doing any good to this particular
project.

What should be done to get rid of this corrupted data?

Any suggestion would be appreciated.

Thanks.

Jan M.

 

[rroszko]

Okay,

As with any fixes anyone suggests, it is uber-highly recommened that you
back up everything prior to proceeding so that at worst, you will be stuck
with you old problem and not introduce any new ones

Two methods:

(1) Just go to "Admin", then "Manage Enterprise Features" and rename the
cube name. Creat new cube.

CAVEAT: You need to go into each analysis "View" and point the "View" to the
new Cube name (after it's built, of course). Also, the old cube may/will
still exist (depending on configuration, hot fixes, SPs etc.), so you may
want to delete it to save space...

Or:

(2) Delete the cube from the SQL server. (Just go to the server, open
Analysis Manager, drill down to the cube, right-click to delete it.)

CAVEAT: After the cube is rebuilt, users may not be able to get at it. Why?
Becuase of intricate permission problems due to whatever you may have done
and whatever hot fixes and/or service packs you loaded. All you have to do
is go to the new cube, drill down to "database roles" of the cube and
right-click "manage roles" and click on "New". Under the Memebership tab,
Click on "Add". Choose and add "Everyone". Go to the Cubes tab and select
all views and check them all.

Done.

 

[rroszko]

Oh oh oh... I forgot:

Sometimes the cube is fine.. Maybe the PM didn't do a "Colloborate,
Republish all Assignments". Try that first. Or:

The project and/or pointers in PWA/SQL is corrupt. If the OLAP fix as
outlined below doesn't work, save the project as a file and delete the
project from PWA and re-import the project and do a Colloborate Publish All
Information.