Subquery in data filter in Admin Tool

Question

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.

Joel Acha · Answer

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.

Gianni Ceresa · Answer

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.

mmajdana1 · Answer

@joel I want to apply this in RPD as a part of security.