Stardard FDI controls
Can someone help me understanding what kind of data control can be done in Oracle FDI by standard?
Categories
- All Categories
- 118 Oracle Analytics News
- 21 Oracle Analytics Videos
- 14.4K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 48 Oracle Analytics Trainings
- 6 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 7 Oracle Analytics Industry
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Stardard FDI controls
Stefano_Mazzocca
Rank 5 - Community Champion
Best Answer
-
Please take a look into the following Oracle document for detailed understanding. It has some detailed tables outlining the comparison among various roles.
Administering Oracle Fusion Analytics Warehouse
Also, please take a look into the following blog which might be helpful to understand the concept for customizing any security config.
Hope this help.
Cheers,
0
Answers
-
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.
0 -
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
0 -
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.
Hope this help.
Cheers,
0 -
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?
0 -
0
-
Hi @Bhaskar Konar , it's Oracle Cloud HCM
0 -
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.
Hope this help.
Please give me a shout if you need any more information.
Cheers,
0 -
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 you0 -
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.
Hope this help.
Cheers,
0
