nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

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

Find more posts tagged with

Security

Configuration

Oracle Fusion Analytics

HCM

FDI

Comments

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

New Announcements

Upcoming Events

Oracle Webinar OCI AI Foundations Certification
Prepare-se para sua certificação em OCI AI Foundations Inteligência Artificial está transformando a forma como empresas desenvolvem aplicações, automatizam processos e utilizam seus dados. Para aproveitar esse potencial, é essencial compreender os principais conceitos de IA e como essas tecnologias se conectam aos serviços…
AI Data Platform - Product Roadmap Update October 2026
Description: Join the Oracle AI Data Platform Product Management team for a deep dive into the latest product roadmap updates and upcoming innovations. During this webinar, we’ll cover key roadmap highlights, showcase product demos, and share insights into what’s ahead for Oracle AI Data Platform. The session will conclude…
Analytics - Oracle Fusion Data Intelligence (FDI) Product Roadmap Update
Description: The Oracle Fusion Data Intelligence (FDI) Product Roadmap Update provides an overview of the latest developments and future plans for FDI. Oracle Product Management experts will share upcoming capabilities, key enhancements, and product direction, helping attendees understand what is changing and how these…