Forum Discussion
Role playing dimension issue
Super UserYou have one country dimension and two measures. If you want to show both sender and receiver country at the same time then indeed you need to pull these into the fact table.
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.
- lbendlin
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 ....- lbendlin
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)