Bypass Data level security for a one report but not all

AnkitR Gupta

Hi team,

I have a scenario which I am struggling with.

there are 10 reports built out of a subject area and data level security on location is applied on fact and dimension table. any user logging into obiee get data on 10 reports as per their defined location specific security.

we have to create one more report from above mentioned subject area but it should not have data level security applied. All the user group are same for this report as well.

I tried direct database request reporting but once I implement one report showing data without security, I have 4-5 more reports to be developed on similar type of data access and complex view with high formatting (so direct database request is ruled out).

require experts opinion/thought on above scenario.

Thanks

Ankit