When implementing Oracle Fusion HCM on Cloud, customers more often than not rely on the simplest reporting tool called Oracle Transactional Business Intelligence (OTBI). The tool is meant to be user-friendly, extensible and flexible.
While OTBI does not cover the reporting needs for all the fields available on the product, Business Intelligence (BI) Publisher offers the whole suite of fields on the product, the difficulting is the need to have the technical skills to build data models and layouts.
One of my customers had a reporting requirement. They needed a excel report to show an excel output of 3 different tab pages, one to show new joiners, one to show who were terminated and the third tab to show who were transferred.
The first approach was to make the report in OTBI. Unfortunately, OTBI does not have a feature to have different tabs, unless you make a dashboard which has different tabs. The difficulty of using the dashboard feature is that it's not as excel friendly when exported together. My first approach was to search for a solution on My Oracle Support (MOS). However, I wasn't able to find anything there. It was at this point that I thought about exploring features in BI Publisher. I ended up searching on google for some keywords such as excel tab and found a blog which talks about BI publisher features to solve the problem.
https://blogs.oracle.com/xmlpublisher/multi-sheet-excel-output
The fundamental lesson is that we have multiple sources of information, it's entirely up to us as consultants to leverage as many of them as possible in a quick and efficient manner.
While OTBI does not cover the reporting needs for all the fields available on the product, Business Intelligence (BI) Publisher offers the whole suite of fields on the product, the difficulting is the need to have the technical skills to build data models and layouts.
One of my customers had a reporting requirement. They needed a excel report to show an excel output of 3 different tab pages, one to show new joiners, one to show who were terminated and the third tab to show who were transferred.
The first approach was to make the report in OTBI. Unfortunately, OTBI does not have a feature to have different tabs, unless you make a dashboard which has different tabs. The difficulty of using the dashboard feature is that it's not as excel friendly when exported together. My first approach was to search for a solution on My Oracle Support (MOS). However, I wasn't able to find anything there. It was at this point that I thought about exploring features in BI Publisher. I ended up searching on google for some keywords such as excel tab and found a blog which talks about BI publisher features to solve the problem.
https://blogs.oracle.com/xmlpublisher/multi-sheet-excel-output
The fundamental lesson is that we have multiple sources of information, it's entirely up to us as consultants to leverage as many of them as possible in a quick and efficient manner.