Cube Refresh

From DataSelf Knowledge Base
Jump to navigation Jump to search

Separate cube refresh step in SQL Agent job: see Refresh Configuration SQL 2005.pdf

The script you need:

<Process xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<Object>
<DatabaseID>DataSelf BI</DatabaseID>
</Object>
<Type>ProcessFull</Type>

</Process>

Where:

DataSelf BI needs to be the exact name of the cube database.

(Open Analysis Services and start to Rename the database, so you can copy/paste it into this script)