Error Reporting in SSAS...

Is there a way to achieve the following on a UDM:

1) When an error occurs while processing a record
in a dimension, write the primary key of the record
along with the error to a record in a database.

2) Continue on all errors after logging them.

3) Launch a script when cube processing is complete
to notify affected parties of the errors.

Any suggestions to achieve something similar would
be greatly appreciated.

Filip

You can use SSIS package to put all that in one package.

You create a package using Analysis Services Processing Task. Then go to Menu -> SSIS -> Logging... In the Provider Type select SQL Server then check the "Details" tab. You have to try different Events and check it's logging all you want not more or less.

Continue logging on error is the properties setting on cube/dimension side also if you double click Analysis Services Processing Task you can set that in "Change Settings..."

Last one you have to query the log database table and use send email task in SSIS package.

Hope this will help - Ashok

|||

Thanks Ashok, I'll give that a try and report back ;-)

Filip