Qlik Sense Data Modeling

[StacyCui]

Hi, I am a new in Qlik Sense. I meet an issue of data modeling in my work.

Business Background:

We have two order tables that are respective CY ORand PY OR.  In business scope. We have district structure that Territory→Branch→Office. Each year, we adjusted the structure a little, like maybe office A belongs to Branch AA in last year, but this year, it maybe belongs to Branch BB. So, the  district structure in CY and PY order table, it doesn't completely same.

Q:

When I design the modeling, Is it necessary to build a district structure table as a dimension table to connect with the fact tables. Besides, for PY district structure, we don't has a record. I have to distinct the structure in PY OR table to obtain. Kindly appreciate to your reply.

[hic]

On the situation with the two order tables: I would concatenate these so I get one single fact table:

Orders:
Load ... From CY ... ;
Concatenate (Orders)
Load ... From PY ... ;

If there is a mismatch with fields, a missing field will be padded with NULLs.

On the problem with the changing district structure: This is a situation with a "Slowly Changing Dimension". See more on
https://community.qlik.com/t5/Qlik-Design-Blog/Slowly-Changing-Dimensions/ba-p/1464187
https://community.qlik.com/t5/QlikView-Documents/IntervalMatch-and-Slowly-Changing-Dimensions/ta-p/1...

But for this to work, you need to have some historical data, so you can recreate the district structure of previous years.