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.