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 Analytics and AI

Child Item

How to Dynamically filter Data in FDI/FAIDP 26R1?

Santa_B-Oracle

I am not getting how to filter data using variable in semantic layer extension → Security.

There is no step for adding data security available any more. Now I know Custom Security Context is an option but that is more of Hardcoded Solution So, Want to understand how is it possible now ?

Find more posts tagged with

Accepted answers

Daniel Ryan

@Santa_B-Oracle, my environment is 26.R1.P1 and I seem to have the option for this

You would just need to create the session variable in a sandbox first.

Apologies if I am missing something.

All comments

Daniel Ryan

Hi @Santa_B-Oracle, if I am understanding correctly, you should be able to go into SME>Security then Add Data Security Step. This should enable you to add filters to the data based on certain conditions. If you want this to be more dynamic, you could create a session variable first to drive a variable filter in the security expression.

Hope this helps

Santa_B-Oracle

https://community.oracle.com/products/oracleanalytics/discussion/comment/76472#Comment_76472

Yes , Daniel my point was in 26 R1 that option is unavailable . even documentation for 26r1 skips it

Daniel Ryan

@Santa_B-Oracle, my environment is 26.R1.P1 and I seem to have the option for this

You would just need to create the session variable in a sandbox first.

Apologies if I am missing something.

Santa_B-Oracle

https://community.oracle.com/products/oracleanalytics/discussion/comment/76526#Comment_76526

let me check.