I have four pages in my report .I have to apply RLS for first three pages with source country =HK. And for fourth page first condition will be src_country=HK and if it as associated source country then it should display as well in matrix visual.
For example :
Country IDMatch
HK 2024_CP_657
SG 2024_CP_657
HK 2024_CP_900
SG 2024_CP_801
In fourth page of matrix visual it should display first three records because source country =HK and Id Match is equal for both HK and SG.(2024_CP_657). I have applied logic for this and its working fine. In all four pages two tables have been used CP Table and retention table with link table as common in both of them and have filtered with source country=HK in CP table .It has been working for three pages but in fourth page i cant use this filter because it will filter only HK but i want other associated country as well. So have duplicated CP table and retention table .
Data Model:
CP table(One ) --->;(to Many) Link table(One) to ---(Many)Retention table .Relation ship is both.
Duplicate CP Table (One)--(Many)Link Table (One);-----(Many)Retention table.
Relation ship is single and duplicated CP table is filtering Link table but my requirement is Link table should filter Duplicated CP table and direction should be single. And have removed duplicates but link table will have many values only .And for above logic i have applied in duplicated CP table for RLS to bring associated id. But due to relationship between link table and duplicated CP table fourth page is not working .How to resolve this so that my first three pages should filter HK and fourth page should filter HK as well ass associated ID match country as well. Any ideas appreciated
