How to create a report using OTBI (single subject area)

A report is useful to fetch the data. Based on the requirement we need to select the subject area to fetch the data. If you are new to fusion technical this post will make you understand how to create the report using OTBI.  Lets take an example with the following requirement, i need list of employees whose assignment status is "Active - payroll eligible", whose hire date is after 01-jan-2018. Lets see how to create a report.

Login to the application as BI admin

https://hosturl.oraclecloud.com/analytics

After logging to the application, following screen appears

Click on New – Analysis

Select workforce management - worker assignment real time subject area to get the above mentioned desired output

Select the worker folder under the subject area

Double click on the Assignment status

Double click on Employee ID and Enterprise Hire date

Now let use filters to achieve our requirement. Click on settings icon beside Assignment status under the selected columns section. Filter “Active - Payroll”

By clicking on filter a tab will pop-up then click on search as shown in the below image

Select the Active – payroll eligible from the list and click on on ok and search

Follow the same for enterprise date, click on settings icon

Select is greater than option from the drop down and click on OK

Verify the conditions applied in filters section tab. Now click on Result tab on top left corner of the screen as shown in below screenshot

Now wait for the output

How to save the report and how to export?

Click on the save icon on the top right corner of the screen

Click on Excel 2007+ to export the achieved result

The report will download in excel format.

Note: employee id field can vary from organization. It can also be named as person number, few custom fields can be differed, seeded fields will remain as is

Check out the next post how to fetch the report from different subject areas 

Thanks for the reading the post. If you like the post please subscribe and if you need Oracle fusion training both technical and functional  please fill the contact form.