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.