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

Answer 1

Hi Yerkhan ,

Did you try to ignore this errors ? 

https://www.mssqltips.com/sqlservertip/3476/sql-server-analysis-services-ssas-processing-error-configurations/

---

Regards, David .

Answer 2

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

Answer 3

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 Zhi

---

MSDN 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 [e-mail].

Answer 4

Hi Zoe Zhi,

Could you please explain a bit more? I'me quite confused regarding how to implement this code.

Thanks.

Regards,

Yerkhan

Answer 5

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 Zhi

---

MSDN 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 [e-mail].