For more information, please refer to this announcement explaining best practices for getting answers to questions.
A few OTBI Hints and Tips
Summary
Answers to some common OTBI questionsContent
This is part of a series of sample reports created by Oracle BI and HCM Product Management. You can copy the setup for this report and add it to your Oracle HCM Cloud Service environment.
The attached Hints and Tips document provides answers to common OTBI questions and explains some techniques that will be useful when building a range of reports. These include how to calculate a person's age from their date of birth, how to change the default aggregation on a calculation to show, for example, the average age of employees and how to limit a report to a specific rolling period eg events in the last 12 months. Included in the document is the XML for 2 sample reports that demonstrate the techniques discussed. The XML for the main report is also provided