We have to integrate some Costcenter-related plan values (KPI's) for future years and we want to track the changes for these KPI's (if someone changes a value for a certain year).
The source is an excel-file with this simple structure: Costcenter, Year, KPI_1, KPI_2, KPI_3
Our Modelling-approach (Standard-System-Fields omitted for this figure):
HUB: COSTCENTER_H (HK: COSTCENTER_H_HK, BK: Costcenter)
LINK: COSTCENTER_L_KPI (COSTCENTER_L_HK [Costcenter^Year], COSTCENTER_H_HK, YEAR)
LSAT: COSTCENTER_S_KPI (COSTCENTER_L_HK, LDTS, KPI_1, KPI_2, KPI_3)
Since YEAR is reference data, we dont want to model a hub just for supporting this relationship.
As of the CDVP2-Material Reference Data may/should be modelled as Hub (and an attached Sat if you want to track reference data's history) - so it should be possible to use this as a Link-Component(?)
So is there any problem with having reference data (YEAR) on a Standard-Link (Historized Link)? - even without a corresponding Reference-(Hub-)Table?
If so, is there any other approach for tracking this kind of data? (This question also applies to modelling of Budgeting-Values on other grains in general.)