Mesaures not aggregating by attribute

Amy Jandreau 61 Reputation points

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

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

    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,

    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