Not getting same values in rep04

16583151995773938301142266251477.jpg

Can anyone help having issue in getting different value in rep04

Tagged:

Comments

  • 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!

    Kind regards,

    Bruno Rodriguez

  • 16583169798233471773948755387005.jpg

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

    Need values in year only 

     

     

  • 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!

    Kind regards,

    Bruno Rodriguez

  • Can your help in importing in sys08

     

    Not getting how it is should be done

     

     

     

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

    Kind regards,

    Bruno Rodriguez

  • 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!

     

     

    Kind regards,

    Bruno Rodriguez

  • Need help in importing source and target not matching

    16583194292496182010876105317041.jpg

  • 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.

     

     

    Kind regards,

    Bruno Rodriguez

  • But how to get values in rep04 correct 

     

  • Hello,

     

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

    Kind regards,

    Bruno Rodriguez

  • Where i have to make if statement 

  • Hello,

     

    In EMP02, sorry!

    Kind regards,

    Bruno Rodriguez

  • Hello again,

     

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

    Kind regards,

    Bruno Rodriguez

  • Data in sys08 in is imported sucessfully and no error