Custom Security in Fusion Analytics Warehouse.

Krithika Raghavan-Oracle

Summary

FAW Custom Security features

Content

Below are the list of Blogs we have currently published on Custom Security

Custom Data Security in nine simple steps

Blog on Custom Duty Role  (Soon to be made available)

Version

FAW 21.R1.P3

Alvaro Couto

When new FAW Security release will be published?

Ravi Guddanti-Oracle

Hi Alvaro
I'll notify you as soon as it's available. Tentatively, this month.

Thanks
Ravi

Naeem Akhtar Khan.

Can we have security in FAW ERP Analytics by Cost Center? e.g. Cost center (COA segment) owner should see data only relevent to his cost center.

Krithika Raghavan-Oracle

Yes. Please refer to the blog where we have documented an ERP use case example

 

 

Naeem Akhtar Khan.

We are getting below error while trying to implement following the blog.

 

 

Nupur Joshi-Oracle

Hello Naeem ,

Request you to share a detail doc with all previous steps that you have performed for setting up custom security.

Another point, update from FAW development team, Are you trying to evaluate / preview SQL with  [WHERE  USERNAME = ‘: USER’]

If yes then either you need to replace all input values based on your custom table data or evaluate SQL without where clause and then click on preview button to see the data on UI.

 

Regards,

Nupur

Naeem Akhtar Khan.

Hi Nurpur,

Yes, we were trying to preview while including where clause.

Should we ignore the error while reviewing and progress to next steps?

Regards

Naeem

Nupur Joshi-Oracle

Hello Naeem ,

If you want to verify your custom table data in front end then you need to replace ':User' variable present in your SQL and then click on Preview  or comment/remove all variables present in SQL and then click on Preview button. This way you can see backend custom table data on front end in FAW UI.
 

I hope this helps. Let us know incase of any other queries.

Regards,

Nupur

Naeem Akhtar Khan.

Thanks. we ignored the error and progressed further and it was successful.

 

There is another question arise for this approach that we have to apply this security to multiple Subject areas. How we will know the logical Facts and dimentions for each subject area so that we don't miss any SA?

 

Regards

Naeem

Claudette Hickey-Oracle

this blog link does not work

Sinduja Sekar-Oracle

Here is the updated link:

https://blogs.oracle.com/analytics/post/configuring-custom-data-security-in-fusion-analytics-warehouse-in-nine-steps

Krithika Raghavan-Oracle

Hi

There is also another blog that can help.

https://blogs.oracle.com/analytics/post/configuring-customized-security-in-oracle-fusion-analytics-warehouse