Share via

Incorrect final summation in tabular model

Acid Aquamarine 0 Reputation points
2025-06-03T14:12:59.0933333+00:00

Good day. I encountered a problem with incorrect aggregation. There is a dimension in the system with a hierarchy built in it. During aggregation, incorrect summation of data for hierarchy members occurs. At the same time, with each processing on the same tables in the database, the error can migrate to other members. If you do a summation check using SQL directly in the table, then the error is not observed. What could be the problem? What parameters and settings should I pay attention to?

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,343 questions
0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.