Missing records in the Measure Group

Question

I have records in my measure group 1 where the link (foreign key) to another measure group2/dimension is null sometimes. When I process the cube, measure group 1 is not bringing those records that have a null as a foreign key.

I have tried several things: deleting and recreating the measure group, setting null processing to preserve, setting unknown member to visible, setting error options. 

Does anyone know a reason why it is ignoring null foreign key records?

Thanks.

Answer 1

Hi tsoukieh,

The issue might be caused by the foreign key is null, so it can not map the relationship, you may need to map the null values in your fact table to a surrogate key, please see Koen's reply in the following similar thread:
http://www.sqlservercentral.com/Forums/Topic865001-17-1.aspx

Please feel free to ask if you have any question.

Thanks,
Eileen

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 2

Hi Eileen,

Thank you. That solved it. I changed these NULLS to -1 and added -1 record to the foreign key table. On the first processing it was still not showing them, until I processed the dimensions separately.

Thanks again.