Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Role playing dimension issue

Hello, let me try explaining the issue with a simple example.   I have a fact table with two country-keys: one for sender, one for receiver. The sender-country-key and receiver-country-key are bot...
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago

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)

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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?