I am new to BW and struggling with the Headcount and Personnel Actions cube in 2004s/BI 7.0. I do not have knowledge of previous versions.
I have identified 0HR_PA_0 and 0HR_PA_1 as my 2 datasources and can extract successfully. However my transformations result in a row from each source for the same employee and time period. How do you get these joined? Do I need a DSO?