Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Issue with Data Model

Hi together,

I have the following data model (reduced view):


I need to have the relationship between DimCostCenter and FactAllValues active but it is not possible due to the both filter direction of DimResource and DimCostCenter with the table FactCCLocationOrg.

The main reason why I have the filter direction both for the table DimCostCenter is that I need to filter the FactBudget with the DimManager.

Is there any other way to set up the current model to get the relationship active between table DimCostCenter and FactAllValues?
Maybe by setting up the relationship with DimManager in another way to avoid the filter direction in both ways with DimCostCenter?

I'm really stuck here and already tried a few things. Could somebody help me out?

Thanks in advance.

Best regards,

Andreas

 

 

2 Replies