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
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Cube processing confirmation?

Author  Topic 

Current199
Starting Member

3 Posts

Posted - 2011-08-06 : 07:06:00
Hi,
After processing my ETL package which loads data into the cube, how do I ensure and confirm that my cube has been processed?
Current

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-08 : 04:40:46
you can use a control table for that. in your package just add a sql task to populate this table with processing complete record and date processed once your step to process cube is over.
WHile package is executing you can go to backend and check this table and can confirm processing is complete once you see this record populated with current days date.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -