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.

 

 

Brj73

But how to get values in rep04 correct 

 

BrunoRodriguez

Hello,

 

You need to make if statements depending upon the employees are employeed or not  based on the data from SYS008

Brj73

Where i have to make if statement 

BrunoRodriguez

Hello,

 

In EMP02, sorry!

Brj73

 

BrunoRodriguez

Hello again,

 

OK, that seems correct. What about your data in SYS08 then?

Brj73

Data in sys08 in is imported sucessfully and no error