Hi,
Is there a way through calculation that will lookup the value from another column?
For example, I want to add a new column that if China Region Part is present in Other Region Part column and it will return 'Yes' else 'No'.
Thank you!
@JobDeLuna - There is not VLOOKUP functions in OAC DV. You can achieve similar by creating left outer joins between the current table and one to be the VLOOUP in the dataset, then in the DV report you can filter by nulls in the VLOOKUP table to determine if the row did not have a match between the table and the VLOOKUP table.
If both the table and the VLOOUP tables are the same, you can add the same table twice in the dataset and change the name of one in the dataset definition.
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,…