Notifications
Clear all

Modelling of Budget/Plan-Values


Posts: 2
Topic starter
(@cmetz)
New Member
Joined: 2 years ago

Hi!

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.)

 

Reply
4 Replies