Can someone help me understanding what kind of data control can be done in Oracle FDI by standard?
Hi @Stefano_Mazzocca,
Please take a look into the following Oracle document for detailed understanding. It has some detailed tables outlining the comparison among various roles.
https://docs.oracle.com/en/cloud/saas/analytics/23r2/fawag/managing-users-groups-application-roles-and-data-access.html#GUID-87C64605-96B0-4EC8-B040-9A8D0D1CC7D6
Also, please take a look into the following blog which might be helpful to understand the concept for customizing any security config.
https://blogs.oracle.com/analytics/post/configuring-custom-data-security-in-fusion-analytics-warehouse-in-nine-steps
Hope this help.
Cheers,
@Stefano_Mazzocca -
Are you specifically looking for information on OOTB (Out-of-the-Box) data security in Oracle Fusion Data Intelligence (FDI), or do you need details on custom data security configurations and access control? Let me know so I can provide the most relevant details.
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
Thanks for the details.
You can create some exception / data quality reports in your FDI instance based on the area that you want to check. i.e. You can create a report which will give you all persons details for whom Birth Date is NULL or Salary not present.
Now based on those data you can correct / modify / update your Applications Data and the corresponding data in FDI will be automatically corrected and now your exception / DQ Report will not return that employee whose data have been corrected.
FDI will show you that data that the Application hold (unless you are doing some transformation based on your business requirement within your data warehouse).
Now if your requirement is to stop user entering erroneous data then you have to do that check in the Source Application itself, like if some one entering their data, Birth Date or Salary Amount will be mandatory and system will not accept the data unless a valid Birth Date or Salary has been provided.
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?
Quick Question:
What is your source application (Transactional System) here?
Hi @Bhaskar Konar , it's Oracle Cloud HCM
Thank you!
In this case you have to have a look into the Oracle HCM Person Record and correct the data accordingly there.
Here's an example:
Say, there was no Date of Birth for Bhaskar Konar which is returned by the FDI Report. Now if you check into the HCM Application the same person has no Data of Birth. DoB needs to be updated in the HCM Application and then once the new data will be loaded to FDI, the report will get corrected automatically.
Please take a look at the following record from Oracle Fusion HCM where there is no DoB. If you want to update the DoB then this particular record needed to be updated in the Oracle Fusion HCM. I've highlighted the edit button with Yellow.
Please give me a shout if you need any more information.
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
No problem at all. Thanks for the details.
Yes, you can certainly do it. Just define few Exception (Data Quality) reports based on your requirement. These reports will only return data if that particular condition occurs.
Here's an example for you using OTBI SA: Workforce Management - Worker Assignment Real Time
PFB the XML of an OTBI Report. It'll return all persons whose DoB is NULL.
You can define a new report or extend this report based on your requirement accordingly.
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
HI, I am trying to get data from the Enterprise Contracts - Contracts subject area in FDI. However, it is not returning any records when I use this subject area. Are there additional configurations or setup tasks needed to pull enterprise contracts data in FDI? I have checked the following: In Oracle fusion, I have access…
How to Inject external data (Business central data) into Oracle Autonomous lakehouse via SFTP connector in FDI?
OOTB subject area fields are not available in DEV and PROD. Existing workbooks display "Error Loading Data" and report that standard fields are cannot be found. Local Subject Areas also display "Schema listing not available". The issue appears to affect the FDI semantic layer/metadata across environments. Can anyone facing…
I’m currently facing an issue with the Absence data in FDI. For example, in the screenshot, the Approved Absence measure is showing 1, while the correct value in Fusion 1,560. A few points: This is the standard/prebuilt dashboard; no customizations were made. There is no date filter applied. The FDI refresh runs daily, so…
Report 1 :We do have FRS report with 7 to 8 columns.HTML veiw of the report showing extra space .how to fit the output to the report .There should not be space in the html report.Attaching the report output. Report 1 output : Report2 : We do have an FRS Report where one connection has all ledgers except CSG IND STAT…
