question

44474512 avatar image
0 Votes"
44474512 asked CarrinWu-MSFT commented

SSAS.Process error and questions

A cube has three measure groups, and I change the partition of one of the measure groups.The next day, during the daily task, a processing addition was made to a partition of another measure group, and the results become bigger.Another error has been made.However, on the third day, after the daily tasks were processed again, it was normal again.
Does this mean that changes to one partition will affect partitions in other measure groups?But only once? This is a strange setting!

sql-server-analysis-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @44474512, we have not get a reply from you. Did the answer could help you? If yes, please do "Accept Answer". If not, please let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

Hi @44474512,

Welcome to Microsoft Q&A!

Could you reproduce the issue? If you could reproduce it, you could try to use SQL Server Profiler to digging the issue.

And the measure group reflects the combined data that is contained in all its partitions. This means that you must ensure that the data for a partition in a measure group is exclusive of the data for any other partition in the measure group to ensure that data is not reflected in the measure group more than once. Please refer to Partitions (Analysis Services - Multidimensional Data) to get more details.


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.