Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Secured List Views and AOR
Philip Espia
Rank 1 - Community Starter
The customer has a report that displays the total number of records per table.
When a logged-in user views the report, they should be able to see the count of records they can access based on their data access permissions.
The requirement is that when the user has multiple AORs (Areas of Responsibility), they want to see the count of records per AOR in the report.
Sample Output
Table Name AOR1 Count AOR2 Count Total
PER_ALL_PEOPLE_F 20 10 30
PER_PERSON_SECURED_LIST_V 12 30 42
HR_ALL_ORGANIZATION_UNITS_F 30 25 55
Is this possible? Thanks in advance!
0