question

AmyJandreau-8392 avatar image
0 Votes"
AmyJandreau-8392 asked CarrinWu-MSFT commented

Mesaures not aggregating by attribute

Hi All,
I added a new dimension (Enterprise) which is related to another existing dimension (entity) , but not related directly to the FACT table. When i process the cube and do the cube browsing and Add ENTERPRISE KEY to the canvas it is the same values for all the attributes.. Please advice
Thanks136423-capture.png


sql-server-analysis-services
capture.png (19.9 KiB)
· 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 @AmyJandreau-8392, we have not get a reply from you. Could below answers help you? If yes, please do "Accept Answer". 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 CarrinWu-MSFT edited

Hi @AmyJandreau-8392,

Thanks for your posting.

Maybe you could try to set IgnoreUnrelatedDimensions, otherwise you should get rid of the problems by changing the design (splitting fact tables, using calculated measures, relating unrelated dimensions if possible). For more information, please refer to Properly showing values for unrelated dimensions (IgnoreUnrelatedDimensions).


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.