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

AI Data Platform - Creating High Code Agents and Using Developer Tools in AI Data Platform
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | Americas and Europe
Agenda Presentation: Optimize FDI Workbook Performance Learn best practices and optimization strategies for building performant workbooks in Oracle FDI. We’ll share practical tips and lessons learned to help report authors avoid common pitfalls and design workbooks with performance in mind from the start. As a special…
AI Data Platform - Deploying Agents and Agent Hub in AI Data Platform
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…