Categories
- All Categories
- Oracle Analytics Learning Hub
- 17 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 224 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 84 Oracle Analytics Trainings
- 15 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
No access privilege for ifnull(aggregate())
Øyvind
Rank 2 - Community Beginner
we have recently upgraded to OBIEE 12c, and patched with the latest cumulative patch. Our version is 12.2.1.4.190416
Non-admin users are not able to edit reports having a certain formula. They get the following message: "You do not have access privilege for this subject area"
The formula looks like this:
ifnull(aggregate("Committed Cost" AT date.datedim.year),0)
- If I remove it from the analysis, the issue disappears
- If I remove IFNULL from the analysis, the issue disappears
I have seen a previous patch meant to address a similar issue: 28047277. However, if trying to install this patch, there is a conflict in opatch with the newest 28047277.
0