how many aggregations should be added, the more the better?

ZengDingding 26 Reputation points
2022-12-27T07:39:28.32+00:00

274225-aggregation.png

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,007 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 25,906 Reputation points
    2022-12-27T07:48:42.84+00:00

    It's similar to indexes in relational databases, many indexes can (!) speed up queries, but slow down writes; in SSAS cube processing.
    See Aggregations and Aggregation Designs


  2. Seeya Xi-MSFT 12,821 Reputation points Microsoft Employee
    2022-12-28T06:36:46.733+00:00

    Hi @ZengDingding ,

    Everyone's situation is different and there is no way we can give the best advice. You can refer to my answer in this case.
    https://learn.microsoft.com/en-us/answers/questions/1127990/ssashow-to-add-the-aggregations-by-referencing-the.html

    Best regards,
    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    No comments