Setting some dashboard analytics to a date in a hidden dashboard prompt (e.g. 'Previous Year')

Content

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 sample OTBI analysis calculates the headcount as of an effective date which is defined in a dashboard prompt and displays it in a Performance Tile.  This allows you to create two performance tiles for headcount, one using the current date and the other one year previous (using the hidden dashboard prompt).

You can view a sample image of the output below.

To add this performance tile to your environment: