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
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
lbendlin
Icon for Super User rankSuper 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?