Forum Discussion
Userelationship not working between fact tables
Hello, I've got the following scheme, where the tables RESERVA_INVESTIMENTO and WALLET_OPERACOES are both fact tables. However, it is possible to use RESERVA as a dimension table for WALLET. The...
amitchandak
Super User
Super Userdgurgel , USERELATIONSHIP is to activate inactive between a set active/inactive.
First of check why this relationship is inactive ?
It's inactive because it would cause ambiguity between the other dimensions relationships, that are feed both fact tables. These need to be inactive for the circled relation to be active.
INVESTIDORES -> WALLET_OPERACOES
DimCalendario -> WALLET_OPERACOES
SOLICITACAO -> WALLET_OPERACOES