Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Star scheme issue with factless Fact-Table

Hi together,

 

I have the following datamodel:

 

 

I have the behaviour, that the table DimResource can filter the table FactBudget what I don't want and what leads to incorrect behaviours.

I think it is because of the factless Fact-table and the filter direction from DimCostCenter (both directions)

Maybe there is a misunderstanding from my side regarding the modelling approach, but is there any other way to do it?

The DimResource has absolutely no relation with the FactBudget table, but I need the both-filter direction.

Thank you in advance!

 

Best regards,

 

Andreas

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.


  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak 
    Thanks for your feedback.

    The Fact Budget table is only available until the Cost Center level (therefore the relation with Dim Cost Center)

    With my Data Model, the Fact Budget can also be filtered with the table Dim Resource, but the Fact Budget has absolutely no information about the table Dim Resource.

    I assume, that it is because of the factless Fact Table and the filter directin both within the Dim CostCenter table.

    So my question is, why is the table Dim Resource filtering the Fact Budget table? I don't have any relation between those tables.