Headcount and Personnel Actions cube in 2004s/BI 7.0.

[Former Member]

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?

[Former Member · Accepted solution]

Clare,

Probably you can create a DSO and load the data from two datasources and do further update to cube. If it doesnt answer your question, please eloborate a bit on your query..

Thanks,

Gattu

[Former Member · Accepted solution]

You have couple of options.

1) Create a multiprovider by adding these 2 cubes and generate reports on multiprovider (Recommended)

2) You can create a DSO and update data from DSO to your Reporting Cube.