|
SSAS Dimension Process Update |
|
Written by Olaf Helper
|
|
Sunday, 06 November 2011 15:52 |
|
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...
|
