Trailing year numbers are a great way of making reports dynamic. PPM and ERP both have their own versions of Trailing Year Numbers, it would be very handy if HCM subject areas had the same.
Organization: Baylor University
These are very useful in ERP and should be standard across the application.
Hi Caroline, Can you please share any HCM-specific Use case - which you can accomplish easily with these time dimension addition in hcm subject areas ?
Hi @Nupur Joshi-Oracle ,
Say I've created a workbook with a couple of HCM key metrics like Current Headcount, Current Average Salary by Sex, and Current Open Job Positions. If I am able to add a trailing period number filter to the top bar and set it to 0, then the report is dynamic and I won't have to remember to change it manually each month.
I currently use Trailing Period number for many ERP reports, so I would use the HCM trailing numbers often as well.
Thanks!
It's particularly useful with ERP reports when you want to put the dashboard read only, and you want to send out to someone senior who doesn't need to know about having to change filters.
In that case you can simply put trailing period to 0 and it will always show them the current month's data, and you can use a FILTER calculation to say compare previous month's headcount with last month's using Trailing Period 1.
It's really, really useful. Yes you can probably achieve it with some data sets/flows but it would be better to have in the subject areas.
Hi @CarolineAnderson @Chris Allies This requirement you have mentioned above does not need the trailing period filter. Workforce Core has a daily snapshot. If you just have the 'Headcount' metric on the dv, it will always show the latest. If you want to be double sure you just need to apply a filter like below
FILTER(Headcount USING Time.Date IN MAX(Time.Date)) - gives you latest headcount
FILTER(Headcount USING Time.Date IN TIMESTAMPADD(SQL_TSI_MONTH,-1,MAX(Time.Date)) - gives you headcount a month ago
Raghu
@Raghavendra Raghunath-Oracle I tried to filter as you have recommended her but I get the error "Aggregate is not allowed within USING clause of a FILTER operator". I am trying to show in my workbook the headcount as of the day the user filters the dashboard by, so that if a user selects a date or a date range, the headcount for that time period will be displayed.
Currently, scheduling functionality is available primarily for workbooks and dashboards developed using the Classic reporting method. Extending similar scheduling capabilities to workbooks and dashboards developed using Data Visualization (DV) would significantly improve the usability and adoption of these reporting…
Fusion App data is frequently refreshed from our Fusion Production environment. As a result, in order to sync the data in our FDI non production environments a full reload is needed. Due to volumes of our Fusion Production, the task to perform reload of the data will take 1-2weeks to complete. Depending on the frequency,…
Hi All, I see several upcoming changes in Fusion HCM Core HR, including new employee attributes such as Preferred First Name and Preferred Last Name. Since we have multiple Oracle FDI workbooks currently live with business users, we need to assess whether these HCM changes have any downstream impact on our existing…
Requesting a toggle to suppress zeroes and nulls in tables and pivots in similar fashion to that of SmartView functionality. Currently there is native suppression, but this functionality rarely excludes zeroes appropriately resulting in many rows of non-meaningful data. Filtering zeroes out is theoretically an option, but…
Idea Enhance FDI Custom Data Security to allow permitted data values to be configured directly within a Data Role, rather than requiring all values to be granted separately through user-level Security Assignments. Use Case Our organisation uses row-level data security based on Chart of Accounts segment values that align to…
