Tuesday, March 20, 2012

problem olap process

Hi,
I have a cube in analysis manager. This cube is processed via a DTS in sql server 2000 with an incremental update.
The sql task finishes successfully but there is no data moreover in the cube.
So, I proccess manually the cube with the dialog box "process a cube" and I select Incremental Update : the step finishes successfully but there is still not data moreover!!
I have to process the cube with a full process each time!!
Why that doesn't work?? any ideas??There is no quick way to resolve but you may try review this http://www.databasejournal.com/features/mssql/article.php/1582491 link to troubleshoot the issue.

HTH

No comments:

Post a Comment