Measures two fact tables

[credencial]

Hi folks,

I need help.
I have the following model with two fact tables:

My currency measurements refer to the table "fVendasItens", which is linked to my table dimension "dProdutos". The total value is my gross value and to get the net value, I need to subtract some calculated measures from the "fVendasCabeçalho" table.
What is the best way to do it?

NOTE: The table "fVendasItens" has *:1 with the "fVendasCabeçalho" with the column "ID_VENDA".

Best regards,

[lbendlin]

This looks good so far. What have you tried and where are you stuck? Does fVendasCabeçalho have any logical relationship to dProdutos?  Maybe your business question requires a different data model?