Всем привет.

Занимался кто-нибудь еще таким? ))

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d05c57f8-7557-49c3-8501-2923c54f27e6/ssas-performance-maintenance-powershell-script-with-aggregationdesigndesignaggregations-method?forum=sqlanalysisservices

hey there.

currently i am thinking about how to establish some basic aggregations level in our system, especially with respect to

https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models-olap-logical-cube-objects/aggregations-and-aggregation-designs

After the aggregation has been created, if the structure of a cube ever changes, or if data is added to or changed in a cube's source tables, it is usually necessary to review the cube's aggregations and process the cube again.

It has occurred that there were some efforts in order to solve the problem which use

AggregationDesign.DesignAggregations Method (Double, Double, Int64, Boolean) method

https://sqlkiller.wordpress.com/2014/06/23/ssas-performance-maientnance-powershell-script/

With some corrections the script seems to be a working one (and i am going to enrich it with the second usage log designaggregations method) but perhaps there are some more current approaches to the problem - please advise if there are