Mesaures not aggregating by attribute

Amy Jandreau 61 Reputation points
2021-09-29T20:45:58.443+00:00

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
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,258 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CarrinWu-MSFT 6,866 Reputation points
    2021-09-30T07:05:51.963+00:00

    Hi @Amy Jandreau ,

    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.

    0 comments No comments