Hi @CarolineAnderson You could add an ELSE condition to your CASE statement and then add a fact measure column to the ELSE part of your condition. As far as your query is not evaluated for ELSE and satisfies your first criteria, this calculation measure would give you the desired results and this way it can be treated as a…

Hi In such cases, when there is missing last update date/create date in the PVO, do a full data extract of the PVO and do a comparison with last extract with current extract to identify the delta changes (MINUS operation) in the target system/extraction process. The PK of this PVO is Fullfilllineid Other method is to use…

Hi Abhishek You need to replace the D_DAY with your actual time dimension table. This table is given for reference purpose. If you are using FAW, then I think the table is W_DAY_D. Pls give a try Regards Venkat

Hi Below query snippet will help to identify the days excluding weekends. D_DAY is the time dimension at day level. You need to pass requisition creation date as 1-Jan-2022 and requisition end date as 15-Jan-22 in the query as commented below to calculate requisition posted days. You need to replace them with actual db…

This feature is currently not available. There is an ER Enhancement Request 34045416 - FREQUENT FAW REFRESH is already logged. This feature will be able in future release of FAW (probably by End Of September 2022).

Hi Amrita, You could try running an OTBI report on the PO Headers subject area for the DFF attribute to see if it has an reference to this PVO in the query log. Ideally you should be able to add via a custom data store as illustrated here which was last updated on Sep 8, 2022. So I presume, this content is latest. FA BICCC…