Dynamics AX
  RSS Feed  LinkedIn  Twitter
Want to turn you're data into a true asset? Ready to break free from the report factory?
Ready to gain true insights that are action focused for truly data informed decisions?
Want to do all of this across mutliple companies, instances of Dynamics and your other investments?
Hillstar Business Intelligence is the answer then! (www.HillstarBI.com)

Hillstar Business Intelligence for Microsoft Dynamics AX and NAV on Mobile, Desktop, Tablet

Let us prove to you how we can take the complexity out of the schema and truly enable users to answer the needed questions to run your business! Visit Hillstar Business Solutions at: www.HillstarBI.com

Wednesday, July 22, 2009

Backing up an SSAS OLAP Cube Database, by command

So you have Dynamics AX 2009 up and running, you have deployed everything, got the SPN's set and working, and the OLAP cubes deployed.

You go and run Role Centers, and some KPI's are failing and some Cubes and reports are. You investigate, and go through the motions of fixing the OLAP cubes. (A later post on this to come)

After getting the cubes fixed, dimensions set, KPI's working, and the underlying Data View for the Cube Database all correct, what's next?

Well you will need to make sure and create a SSIS packge, that will backup a SSAS Cube Database. But, looking at the SSAS command task, there is not a simple option for this.

The following is the command used to backup the SSAS OLAP Cube Database with, for an SSIS package, that can execute as a scheduled job.:

SSAS Tag Based Backup Command

The above is stored as a link to a text file, because the command is Tag based, and blogger wants to make it into HTML.

Notice there is a password section. If this is given, then the password is set as that password, and must be supplied if used for restore.

This backup process takes and backups to the file location, and file name the meta-data that describes the Cubes and all that make up those cubes. This does not back up any data for these cubes.

If a restore is needed, simply take and restore from the file, and re-process all the cubes. This will get OLAP back up and running for your cubes, with your latest transactional data processed.

Well more to come, including looking at Role Centers, SSRS and SSAS across forest and domains. See you then!

"Visit the Dynamics AX Community Page today!"

Labels: , , , , , , , ,


Post a Comment

<< Home

Copyright 2005-2011, J. Brandon George - All rights Reserved