Forum Discussion

LivioLanzo's avatar
LivioLanzo
Solution Sage
7 years ago

Hello Anonymous,

 

as far as I see, you can link the project code dimension directly to the fact table, you do not need to traverse any of the three other dimensions. The relationship between 'Project Code' and and Area, Location, Building is already present in the fact table. 

 

 

Also, are you sure that Building, Location and Area do not have a one to many relationship going from Building > Location > Area?  Can a building really belong to multiple locations? Can a location really belong to multiple areas?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hello LivioLanzo;

     

    Many thanks for your reply.

     

    If I do what you suggested, I can not filter building, Area and Location related to that project code. For doing this, I have to build both sided relationship between Fact and (Location, area and building) as below. (Please correct me if I am wrong)

     

     

    But I don't want this, because I want to see all Locations even if it has no value on the fact table.

     

    And yes, I asked many times unfotunately building, location and area has no link. They named the data like this. But it has no common column except Project Code.

    • LivioLanzo's avatar
      LivioLanzo
      Solution Sage
      7 years ago

      Hello Anonymous!

       

      if you get rid of the bi-directional filter (highly suggested) then the 'Project Code' dimension will filter the fact table but then the fact table does not filter the other three dimensions (giving you the effect that you want). 

       

      Also notice that there are columns in the fact table that you do not need anymore and can be removed to make your model lighter, for instance 'Area', 'Location', 'Building Code' are all attributes of the three dimensions so they can go and probably there're a few more like this 

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Thanks LivioLanzo;

         

        Yes I understand, I will clear the columns. 

         

        I don't want both sided becuse they want to see the zero values also. For example, All the Locations, that project A has. If I build a both sided relation to the fact, fact also filter the Location table. So I can not see the Location which havent got a value on the fact. 

         

        But they want to know all Locations, for asking why there is no transaction to this Location.

         

        In this case, I tried many relationship scenarios, but I couldn't solve.