Topics Map > University of Chicago > IT Services > Business Systems > Reporting Systems > Payroll/HR Data Warehousing

Business Objects - WebI - Payroll Pay and Benefit Amounts on the Same Report Line

This article explains how to place the payroll pay and benefit amounts on the same line in a Business Objects report table.

This article explains how to place the payroll pay and benefit amounts on the same line in a Business Objects report table.

When querying Payroll data you can normally select measurement objects for [Pay Amt], [Benefit Amt] and/or [Pay or Benefit Amt] to display the payroll distribution amounts. The result object; [Pay or Benefit Amt] will have a value depending on whether it is a pay or benefit record and should be using in conjunction with the [Pay or Benefit Type Cd] result object (value P or F) to show what the type of value for the measurement is and allow for grouping. The other two fields will only have a value if they are the matching type of record; otherwise, they will contain a zero.

If you are trying to put the two matching amounts (pay and benefit) on the same line in a table, you must not include any information that differentiates the separate rows, for example, a subaccount number. Hence, in many cases you cannot enter the matching sets of data on the same row in one table; one record will always be a zero.

However, you can create a formula from the pay line information to calculate the benefit.

  1. Modify your data provider query to include only pay records. You will calculate the benefit amount. You can leave the benefit records in initial status to verify the calculated amounts, but do not forget to remove them later.

  2. Make sure the following dimension objects are in your data provider results objects:

    1. [Benefit Level Cd (PAR)]

    2. [Pay or Benefit Amt] (or alternately [Pay Amt]; change the formula below to match).

    3. [Benefit Rate]

  3. Create a variable with the formula:

    =If ( [Benefit Level Cd (PAR)] ="0" ) Then 0 Else Round( [Pay or Benefit Amt] * [Benefit Rate] ;2)

  4. Add the new variable to the table with your data.

  5. Consider adding a condition to your query to not pull imputed income (non-cash, but taxes items).

    [Hrs Indicated Cd] ≠ N.




Keywords:BO, Formula, Variable   Doc ID:29244
Owner:James I.Group:University of Chicago
Created:2013-03-27 13:00 CDTUpdated:2017-03-06 12:13 CDT
Sites:University of Chicago, University of Chicago - Sandbox
Feedback:  0   0