Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OTBI PAYROLL BALANCE REAL TIME DOES NOT SHOW YTD BALANCES

81
Views
5
Comments

Organization Name

WM MORRISON SUPERMARKETS PLC

Description

BI Payroll Balances real time has no facts for Ytd Balances E.g. Ytd Gross Pay, Ytd PAYE Etc

Use Case and Business Need

Analysis of YTD Payroll Balances

Original Idea Number: 83905cfbba

1
1 votes

Submitted · Last Updated

Comments

  • RamaKrishna Vemula
    RamaKrishna Vemula Rank 1 - Community Starter

    this functionality greatly help End users

  • KellyReed1976
    KellyReed1976 Rank 1 - Community Starter

    Help in reporting on balances

  • Scott Cycmanick
    Scott Cycmanick Rank 1 - Community Starter

    Hi Stephen,

    Only "Run" information is available currently in OTBI (e.g. Assignment Tax Unit Run) . To obtain the YTD values you will have to aggregate the values using the process date from the beginning of the year to the current date.

    Kind regards,

    Scott

  • Karen Long
    Karen Long Rank 3 - Community Apprentice

    Agreed that this would be super helpful!

  • Andrew_Schmitz
    Andrew_Schmitz Rank 5 - Community Champion

    Scott, do you have to run some sort of process do to that aggregation? or is that done in how you would build the report?