Forum Discussion
Role playing dimension issue
Thnx lbendlin
But also If I don't want to show them both at the same time, I need to pull there logical names into the fact table. Otherwise how does the end-user know he is dealing with a sender- or receiver-country, since the country table only shows one general country name. Am I right?
And same would be if I have for instance an order-date and ship-date, both part of a role playing dimension. If the end-user wants details of all the items that were ordered on '2022-05-06' there should be a field 'order-date' in my fact table.
Remember you created a second measure with USERELATIONSHIP. Any date list will assume the role assigned to it by the measures.
I don't understand exactly what you mean, but suppose the end-user wants all the rows where order-date = '2022-05-05', he is not using the measure but just getting row information from the fact table.
Or do you mean that when oder-date is not the active relation (only one relation can be active) you can't get additional information from your date table?
If so, the end-user should be fully aware of that ....The date is interpreted by the Vertipaq engine according to the relationship in the measure. If you want to show items ordered in a certain month you use the order measure. If you want to show items shipped in the same month you use the ship measure.
What you cannot do in this scenario is show the orders with their order date and ship date (since you chose to hide these fields)
You are right. I hide them because they are surrogate keys, no use for end-user. But if it want to see order and ship date I can, in my view which is input for the model, translate the surrogate keys to logical keys.
But suppose ship date is the inactive relationship I won't be able to get information out of the date table, other then when using the measure. Am I right?