How to split the day wise absence entries in BI and OTBI reports

How to split the day wise absence entries in BI and OTBI reports

If we enter the multiple days as single entry in Absences records and we need report in day wise split, then we need to do the below steps:

Normally absence entries will store in ANC_PER_ABS_ENTRY_DTLS table.

 If we want to split or breakdown these entries as daily entry for reporting purpose, then we need to:

1.       1. Check the Include in daily report breakdown in Manage Absence Types --> Action Items

1.       2. Run the process: Generate Daily Breakdown of Absence Details

After we ran this process, we will get the daily breakdown values of Absence entries in ANC_PER_ABS_DAILY_DTLS table.

In OTBI Absence Calendar Details Real Time subject Area will work only after we ran the Generate Daily Breakdown of Absence Details process.

Navigation to run the process:

Tools à Schedule Process à Schedule New Process à Generate Daily Breakdown of Absence Details

Give the Absence Start Date and Absence End Date: for this range it will breakdown Daily wise Absence entries and stores those details in ANC_PER_ABS_DAILY_DTLS.

Here we can select population to whom this process must run:

Or

We can navigate as below to this process:

Navigation: My client Group à Absence à Absence Processes àSchedule and Monitor Absence Processes

It may helpful for you. please visit blog for more information and share your ideas.

Thanks

Sainath