CODEWITHSUNDEEP
sqlssas
David Adlington
David Adlington

Reputation: 666

"Standard" method for refreshing production cubes SSAS

Relatively new to SSAS.

Just wondering what is best practice for refreshing data in the production environment.

One "method" under discussion is refreshing the data in Dev, checking it's fine and does not kill the cube. Then copying the cube from Dev to Live (changing connection strings etc)

The other is simply refreshing the cube data via an SSIS package.

Is there a preferred method that most people use or is it down to personal choice?

Upvotes: 0

Views: 237

Answers (1)

Mike Honey
Mike Honey

Reputation: 15027

I prefer to use an SSIS package, mainly for the logging. I send the logs to the msdb..sysssislog table so you get detailed logging with minimal effort. It's very useful when a build fails, as SSAS typically puts out hundreds of irrelevant "process cancelled" messages.

I do all the design work in Visual Studio, with an Environment configuration pointing to the DEV environment, then switch to a PROD configuration to release it. Note the VS environment setting for SSAS allows varying connection strings, so there is no post-release process to worry about.

Upvotes: 1

Related Questions