Answered by:
Dimension to measure link

Question
-
Hi everyone,
I've got a question regarding dimension to measure link in OLAP cube. I have measure with ID and value and dimension with ID, name, surname. I made link with ID. However, there is problem, some IDs in measure are missing. As a result, it gives me error, while processing. How it can be overcomed?
Thanks.
Regards,
Yerkhan
Answers
-
Hi Yerkhan,
You could change your table in datasource view like below
Use join syntax to find data corresponding to the fact table, then it won't prompt error for key missing.
Best Regards,
Zoe ZhiMSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.- Proposed as answer by Zoe ZhiMicrosoft contingent staff Monday, June 24, 2019 9:45 AM
- Marked as answer by Yerkhan Wednesday, July 3, 2019 5:01 PM
All replies
-
Hi Yerkhan ,
Did you try to ignore this errors ?
Regards, David .
-
Hi David,
I've done this for cube and it worked. However, it works if I make "Process" for Cube section, if I click "Process" on Database, it gives me same errors as before. How can I make custom error configuration, so database process will work?
Regards,
Yerkhan
-
Hi Yerkhan,
When you import the dimension table, you could try to use join syntax to get IDs which are in fact table, then when you process cube or database, this will be work.
select d.* from dimensiontable d join facttable f on d.id=f.id
Best Regards,
Zoe ZhiMSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com. -
-
Hi Yerkhan,
You could change your table in datasource view like below
Use join syntax to find data corresponding to the fact table, then it won't prompt error for key missing.
Best Regards,
Zoe ZhiMSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.- Proposed as answer by Zoe ZhiMicrosoft contingent staff Monday, June 24, 2019 9:45 AM
- Marked as answer by Yerkhan Wednesday, July 3, 2019 5:01 PM