Hi there,
Our business requirement is to produce a BI report that shows the current and future values of a known and finite set of payroll elements for an employee.
For example, suppose Employee A currently has a Base Salary and Involuntary Deduction. Following a promotion - effective 30 days from now - the Employee's Base Salary and Involuntary Deduction will change (e.g., to a higher salary and a higher involuntary deduction, which is a percentage of the salary).
What we need is to:
- Display the calculated values of the two payroll element values as they are right now (that is, today's date and not the date of the last payroll)
- Display the calculated value of the two payroll element values as they will appear after the effective date of the promotion has passed
Essentially, we're looking to evaluate the value of each payroll element for the selected staff member and to display it to the end user through BI Publisher.
Is this possible? If yes, how? If not, can you think of a different way of meeting the business requirement? The only solution we've found is to effectively reproduce the fast formulas responsible for each element's calculation at the level of the BI report - however, this is neither scalable nor particularly efficient (we'd be doing the job of an ERP in SQL, which is crazy).
Thanks in advance,
George
