Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / OLAP и DWH Новый топик    Ответить
 SSAS performance maintenance powershell script with AggregationDesign.DesignAggregations  [new]
Evolex_
Member

Откуда: Екатеринбург->Москва
Сообщений: 230
Всем привет.

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

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
23 окт 17, 02:09    [20890692]     Ответить | Цитировать Сообщить модератору
Все форумы / OLAP и DWH Ответить