Getting error while swithching relation between dimension and measure.

asked 2021-11-12T09:07:22.687+00:00
Bhaumik Upadhyaya 1 Reputation point

Hi Team,

I have two tables “Transaction” (Measure) and “Material” (Dimension) with below data.

  • Transaction

Country Material Amount
IT NULL 100
IT M1 200

  • Material

Country Material
IT M1

I have changed relation in Data Source View As Transaction - Destination (Primary key) Table and Material - Source (Foreign key) Table.

Dimension is made on Material table.

Measure is made on Transaction table having relation with Material (dimension).

Then I tried to build cube it’s giving error like “attribute is not found in Material table”.

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.
992 questions
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2021-11-15T07:12:45.823+00:00
    CarrinWu-MSFT 6,786 Reputation points Microsoft Employee

    Hi @Bhaumik Upadhyaya ,

    Welcome to Microsoft Q&A!

    have two tables “Transaction” (Measure) and “Material” (Dimension) with below data.

    May I ask what is the relationship between IT M1 in Country Material and IT M1 200 in Country Material Amount? If it's one to one, there might be will no errors because it is a bi-direction. If it's one to many, the direction only from IT M1 to IT M1 200.

    Then I tried to build cube it’s giving error like “attribute is not found in Material table”.

    Could you please provide a the first original error message?

    Best regards,
    Carrin


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.

    No comments