Territory and Location Dimension in a single Datawarehouse RRS feed

  • Question

  • Greeting guys 

    i have a  Question for the experts .. i created a DW where there is Location and Territory dimension (Check picture below ) it contains similar information just the location contain more detailed information i want to know is it okay to keep it like that ! will it makes the treatment better or no ! 

    Thursday, July 4, 2019 8:09 PM

All replies

  • Hi Ramyazo,

    there is no hard rule that we need to keep everything in single dimension. It's all depending on the business logics which we are going to do.

    Territory contains multiple location and if you want to keep it in location, then territory values would be repeated.

    if at all, you need to find the total sales belongs to particular territory then you need to write a custom query to filter all the duplicate data in territory id.

    i would prefer to go with the same design that you did and in this way  data anomalies can be avoided


    Srinivasa Rao G, MCSE(Business Intelligence) Blog: TechTalksPro

    Please mark as answer if my post is helped to solve your problem
    and vote as helpful if it helped so that forum users can benefit

    Thursday, July 25, 2019 3:33 PM