Forum Discussion
Helper IIGetting BLANK on my measure
"So in hotels i have a PPA_ID which is foreign but there will be empty rows because not all hotels have a target."
This is a candidate for a Dummy Target member in the Targets dimension. If you want a name for this target, you can call it "No Target" or sth similar. So, the rule of thumb is this. If you have a dimension with meaningful members and there are rows in your fact table where no meaningful member can be referenced, create a dummy member that will signalize the situation of not having a valid member and reference it.
All I'm telling you is to never have a model with RI problems. If you allow this, you'll have a lot of hairs pulled out of your head. I promise you 🙂
Community SupportHi, justivan
It seems to be a long story here and I need some time to figure it out
May I ask if you have found a solution, if you do please consider sharing it to help the other members find it more quickly. Thank you.
Helper IIHi v-angzheng-msft ,
Things got hectic at work and I ended up changing my model and created an ID for all hotels without targets as daxer-almighty suggested. Got rid of the RI violation resulting to a cleaner model.
Here's what my model looks like now.
- daxer-almighty
Solution Sage
It's good you've addressed the issue of RI violations. Have you finally managed to get this right?
- justivan
daxer-almighty
Yup. I got it right after addressing the issue of RI violations. Thanks for the advice.