Not getting same values in rep04

Brj73
Occasional Contributor

Not getting same values in rep04

16583151995773938301142266251477.jpg

Can anyone help having issue in getting different value in rep04

16 REPLIES 16
BrunoRodriguez
Regular Contributor

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!

Best,
Bruno Rodriguez
Brj73
Occasional Contributor

16583169798233471773948755387005.jpg

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

Need values in year only 

 

 

BrunoRodriguez
Regular Contributor

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!

Best,
Bruno Rodriguez
Brj73
Occasional Contributor

Can your help in importing in sys08

 

Not getting how it is should be done

 

 

 

BrunoRodriguez
Regular Contributor

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

Best,
Bruno Rodriguez
Brj73
Occasional Contributor

16583186929067952506007840977930.jpg

BrunoRodriguez
Regular Contributor

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!

 

 

Best,
Bruno Rodriguez
Brj73
Occasional Contributor

Need help in importing source and target not matching

16583194292496182010876105317041.jpg

BrunoRodriguez
Regular Contributor

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.

 

 

Best,
Bruno Rodriguez