Report Portal

SSAS Dimension Process Update

More and more often the requirement comes up to create a "Real-Time Data" cube and SSAS provides several techniques to solve this. One step is, to frequently process dimension data to update them. If you are not using ROLAP storage mode (e.g. in Standard Edition) you could "Process update" the dimension, if it's possible.

For every SSAS database from a given list, this Powershell script loops through all dimensions, validates if the dimenson can be processed with option "Update" and by some predefined criteria, if it should be processed.

Read more...

Tags: management, process, script, powershell

 

2007-2015 VidasSoft Systems Inc.