Skip to Content
Former Member
Apr 07, 2006 at 02:34 PM

Handling of ValidFrom//ValidFrom Dates in InfoCube



We are designing a master data InfoCube for Human Resources demographic data. The data from each applicable InfoType is loaded into an ODS and then updated to the target InfoCube. Our question/concern is regarding how to handle the ValidFrom/ValidTo date InfoObjects in order to ensure that the date assignments are being handled correctly. In traditional data warehousing, the ValidFrom/ValidTo dates would be placed in the fact table with SIDs handling the proper reference to each dimension record. Since we cannot add the ValidFrom/ValidTo InfoObjects to either the Time or Key Figure dimensions in BW, my thought is to create a separate "Validity" dimension for them.

Can anyone share thoughts on how to handle this situation?

Thanks in advance.