Not getting same values in rep04

[Brj73]

 

Can anyone help having issue in getting different value in rep04

 

[BrunoRodriguez]

Hello @Brj73 ,

Your syntaxis is on point and the numbers look OK. You may need to repivot the dimensions if you want to compare data. It is just on the right hand side of the blueprint . You are also looking at the summary for the entire year rather than specific months.

Cheers!

[Brj73]

 even after repivot values are not matching , some values are matching but not all.

Need values in year only 

[BrunoRodriguez]

Hello again,

It seems like the formulas are OK, so it must be that the data is not fully correct/mapped in the previous modules. I would recommend going to SYS08 and EMP02.

Keep us updated!

[Brj73]

Can your help in importing in sys08

Not getting how it is should be done

[BrunoRodriguez]

Sure, share information about how you are currently importing it 🙂

[Brj73]

 

[BrunoRodriguez]

Hello @Brj73 ,

Ok, good news. EMP02 does not need an import, this is good news as we have identified at least one issue.

You need to define whether an employee is employed or not, and based on that condition you will bring the data from SYS.08 or make it 0.

Let me know how you get along with it.

Cheers!

[Brj73]

Need help in importing source and target not matching

 

[BrunoRodriguez]

Hello @Brj73 ,

As I mentioned earlier, you do not need to import any data into EMP02. You currently have that data in SYS.08. You need to make sure that the data is cleansed when an employee is no longer employed.