Hi,
Request any help the possibility for an expression filter to filter to the MAX Date.
"SCST - Savings Impact Reporting"."Time"."Snapshot Date"
You can use the TOPN function to get the MAX date. It should do the trick!
TOPN
TOPN(CAST("SCST - Savings Impact Reporting"."Time"."Snapshot Date" AS DATE), 1) = 1
Let me know if you face any challenges while implementing it.
Thanks @Jestin Rajan !!! It worked
Happy to help! 😊
Hello. We are using the HCM - HR Help Desk Requests Overview subject area in FDI for building workbooks. We need to modify the calculation for ticket Resolution Time to "pause" the counter during non-business hours. We don't want the tickets to age, when the person the ticket is assigned to is not working, and have our…
We are building dashboards in FDI, using HCM data. Can anyone advise on best practice for designing front-end access to FDI for different user groups (e.g., Executive, Line Manager, non-Managers, etc.)? Not from the security configuration side, but from the design planning side. We have granted access to only one group by…
Hi All, Previously, I used Data Actions → Analytics Link to navigate between two canvases in FDI. However, I can no longer find this option in the current FDI interface. Has anyone else experienced this? What is the recommended way to create canvas-to-canvas navigation now? Thanks in advance!
Hello, I need to grant users access to FDI without giving them the module security groups, such as ERP, HCM, etc. In FDI, I have other external connections, and I don't want them to see any other modules, so my question is: Is there any other FAW security group that grants access to FDI without allowing users to see the…
With the release of Fusion Operational Analytics, I understand that OTBI Subject Areas will be made available within FDI, but I'd like to know the following: 1) Can I migrate OTBI reports and/or dashboards over to FDI for use by FDI consumers? Are they brought through the OAC Classic layer of the FDI/OAC platform? If not,…