OTBI Reporting in Oracle Fusion HCM with worked example (Part 2)

How to create OTBI reports in Oracle Fusion HCM 

OTBI Reporting in Fusion HCM – This is the second part of OTBI reporting. In the first part, I have explained some of the starting steps to create OTBI Reports.

You must go through the first part of OTBI Reports before starting the second part. Please find the below link for the first part.

OTBI Reporting in Oracle Fusion HCM with worked example (Part 1)

Steps 7:

Now, we can see the result after and before applying the filter. Further
To see the result go to the second tab that is the result.

Before applying a filter :

After applying a filter :

Now, if you observe the result carefully, you can see that the “Organization Name” column has some empty fields, instead of getting the same organization name to each applicable rows, it is showing only for one row and empty for the rest.

In the above snapshot (After applying filter), you can see “Accounting US ” and “Consulting North US” as organization names, it did not repeat for the rest of the rows, instead of repeating it shows empty values.

Now, If I want to see the required values for each applicable rows instead of the null value in my report, what to do?

Thus, here is the answer for that –

Column Properties
Column properties

We have seen one option that is “Column properties” for each column. To know more about Column properties and its use, you can go through 

– Select “Column properties” option for Organization column
– On landing page , go to second tab that is “Column Format”
– you can see radio button under “Value Suppression”
– now choose second option that is “Repeat” and click OK .

Column Format
Column Format

– Done, now you would be able to see below result

Result

So these are the steps to create and run OTBI Reports.

Frequently Asked Questions(FAQs)

[sp_easyaccordion id=”445″]

** check out the First part – OTBI Reporting in Oracle Fusion HCM with worked example (Part 1) **

2 Replies to “OTBI Reporting in Oracle Fusion HCM with worked example (Part 2)

Leave a Reply

Your email address will not be published. Required fields are marked *