Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Handling of ValidFrom//ValidFrom Dates in InfoCube

Hello,

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.

Sincerely,

Sonya

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question