Skip to Content
0
Former Member
Nov 30, 2009 at 01:55 PM

transfering from HR app to Finance app

25 Views

I am trying to transfer data from a HR application, where salaries are recorded in detail, to a Finance application, where only the summary is shown. I want to use a SSIS package to run a script. I want to lookup the values in the HR application. I am seeking advices as I am not familiar with thesyntax to use for lookups and rec.

Thanks

DL

// -


Looking up the values from the HR_2009 app:

*lookup HR_2009

*DIM ENTITY="TOTALCOMPANIES"

*DIM ACCOUNT="HR_SALARIES_TOTAL"

*DIM EMPLOYEE_2009:EMPLOYEE_2009="M_SALARY"

*ENDLOOKUP

// -


Write to FINANCE application

// there are conversion rules based on the department. if the department is 946, then we derive the account

//we always want to write to category NBUDGETV2, HR_LOAD, and NON_INTERCO

//intco dimension does not exists in the HR application

*WHEN lookup(EMPLOYEE_2009)="M_SALARY"

*when datasrc

*is "ALL_FIN"

*WHEN DEPARTMENT

*IS "946"

*WHEN ACCOUNT

*IS "HR_SALARIES_TOTAL"

*REC(ACCOUNT="40360",CATEGORY="NBUDGETV2",DATASRC="HR_LOAD",INTCO="NON_INTERCO")

*ENDWHEN

*endwhen

*ENDWHEN

*ENDWHEN

*commit