Having issue with the LDM and one filed. Feature. It is not mapped to anything but it keeps saying it is. Should I just duplicate it? It should just work like all the others but its not for some reason
m
Moises Morales
02/19/2025, 9:40 PM
Hi Doug, the foreign key "Feature id" seems to be mapped to "sidd analytic standard line call topic". If the dataset "Dim sidd features" is not supposed to be mapped to this other dataset, could you remove the foreign key? If the issue persists, you may want to remove the dataset and recreate it as needed. There must be some broken reference or key that no longer exists or changed id.
d
Doug Creighton
02/19/2025, 9:41 PM
I have had to map as a duplicate key as you seen above. I'm not sure why it didn't just map to begin with
Doug Creighton
02/19/2025, 9:42 PM
Dim feature does map to multiple fact tables which usually isn't a problem
Doug Creighton
02/19/2025, 9:42 PM
I want to connect feature id to "Feature id" to "sidd analytic standard line call topic" but i had to duplicate feature id to do it
m
Moises Morales
02/20/2025, 8:04 PM
Thank you for the additional details. In that case, you can try removing and re-adding the dataset, although be aware of any destructive changes this may have on your workspace. I recommend creating a backup to be on the safe side.
d
Doug Creighton
02/20/2025, 8:30 PM
I think i figured out why - we need to convert to attribute