Still nothing :( It may be a bug…

Thank you @Sumanth V -Oracle , any other idea? It didn't work 🙄

Almost… @Sumanth V -Oracle At the moment I can access this: https://oaxfditestbper-frfnl2gkhkex-fr.analytics.ocp.oraclecloud.com/ui/dv/?pageid=console But if I try to build your link I fail (I tried both): https://oaxfditestbper-frfnl2gkhkex-fr.data.analyticsapps.us-ashburn-1.ocs.oraclecloud.com/ui/oax/?ojr=console…

Hi @Sumanth V -Oracle , and how can I access FDI console? I can only see this:

Hi @Bhaskar Konar , yes but your example was done in OTBI as you said, I need to do it in FDI. I just found this link where the "Data Validation" button is showed but in my Console I cannot find it:

Thank you @Bhaskar Konar but I think I may poorly explained my need: I don't actually need to correct data, I just need a way to highlight inconsistent values from FDI, something that tells admin "here there's something wrong, you should check". Is it possible? Thank you

Hi @Bhaskar Konar , it's Oracle Cloud HCM

Hi @Bhaskar Konar , thank you for the information! But how can I make it real? I mean, I guess I must act somewhere in the console, but where exactly?

Hi @Sumanth V -Oracle , @Bhaskar Konar , no I just need to know where in the system (FDI) can I set simple data quality checks like "bith date cannot be null" or "salary must be greater than 0" ecc. Thank you

Hi @Sumanth V -Oracle , the very first step of your guide says "Login to FDI -> Console -> System Settings" but this is my console: I have no "System Settings", just "Advanced System Settings":

Hi all, in previous posts you gave me this guide: Enable and Customize Content Delivery Through Agents It says: On the Classic Home page, click the user profile icon and then click Administration. Click Manage Privileges. Navigate to the Delivers section, and grant View Delivers Full UX to BI Content Author. Unfortunately…

Hi @JohnW-Oracle , this is a FDI question so it should be the right place. Also I'm not sure about your suggestion. The columns are exactly how they should be. Thank you

Hi @Bhaskar Konar , turns out that your guide seems to be outdated: BI Content Author role is missing, maybe FAW Licensed HCM Authors Role is the right one? Also System Settings is missing, we can only see Advanced System Settings but we cannot access it even though our user is FDI Service Administrator. Do you have any…

@Bhaskar Konar , my hero :) I'll check with the system administrator (unfortunately I don't have sufficient grants to do so autonomously). I will come back with a feedback for sure, thank you!

Found it! Thank you

Hi @Bhaskar Konar really close! I now just need to remove the am/pm format (24 hours format) . Is it possible?

Hi @Bhaskar Konar, I don't have a specific column, I need the current timestamp as column. My list is this one: So if I do CAST(DATE AS TIMESTAMP) I have the wrong time:

Hi @Bhaskar Konar , not really. I must do the count for every person, my initial image was filtered by just a person for simplicity sake. One person may have different rows and only one row for each person should have the +1: Person1 is ok because there is only one row with A >= 50 and B is always N Person2 is ok because…

Hi @Bhaskar Konar , unfortunately it doesn't help because current metric is: CASE WHEN (A >= 50 OR (A < 50 AND B = 'Y')) THEN (C + 1) ELSE C END This produces a +1 for both lines but I want +1 just for the second one since when there is a line with A >= 50 only that one should be counted. In fact the (A < 50 AND B = 'Y')…

Hi @Bhaskar Konar , it's FDI