Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Subquery in data filter in Admin Tool

Hi.
does anyone know is it allowed to put subquery in data filter like this?
"ADW_TEST"."Costs"."Prod id" IN (SELECT "ADW_TEST"."Products"."Prod id" FROM "ADW_TEST"."Products" WHERE "ADW_TEST"."Products"."Prod category id" != 205 )
205 value is currently hardcoded, it will be changed by a variable later.
Answers
-
You could create a 2nd Analysis which returns the "Prod Id" subquery, then apply it to your main Analysis in the filter as below:
0 -
mmajdana1 wrote: @joel I want to apply this in RPD as a part of security.
Did you look at Row-Level Security (Data Filters) in the RPD? This is what they are there for, to filter data retrieved by business models / subject areas based on some conditions.
0 -
Adding to @Gianni Ceresa's row level data filtering suggestion, you'd also need to add your PRODUCTS table as an additional Logical Table Source in your COSTS logical dimension. Once you've done that, then the data filtering should fit your use case.
0