How to create OTBI reports in Oracle Fusion HCM
You must go through the first part of OTBI Reports before starting the second part. Please find the below link for the first part.
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 –
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 .
– Done, now you would be able to see below result
So these are the steps to create and run OTBI Reports.
Frequently Asked Questions(FAQs)
** check out the First part – OTBI Reporting in Oracle Fusion HCM with worked example (Part 1) **