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.
Hi All, In our organization, data security is highly customized and complex. A single user can have multiple custom data roles assigned based on different security contexts, such as Line Manager, Regional Manager, Country, Area of Responsibility (AOR), Organization, and other business-specific access rules. One of the…
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } Hi All, In our organization, data security is highly customized and complex. A single user can have multiple custom data roles assigned based on different security contexts, such as Line Manager,…
Idea / Enhancement Request Oracle Analytics Cloud (OAC) has introduced the capability to provide public access to analytics content using the BI Public Role, allowing reports and dashboards to be shared with users without requiring authentication. I would like to propose extending similar functionality to Oracle Fusion…
hi All, The existing FDI pre-built artifacts/Common Subject Areas give us useful information about data reload and warehouse refresh activities. However, I see a gap when troubleshooting Data Augmentation execution at row level. For example, we have a BI Publisher report returning approximately 1M rows, but the…
In Fusion Data Intelligence (FDI) release 26.R3.P4, Reporting Configuration provides options to hide Human Capital Management (HCM) and Enterprise Resource Planning (ERP) content. However, an equivalent option is not available for Fusion Supply Chain Management (SCM) content. SCM content remains visible in the catalog…
