OBIEE 12c: Error "You do not have access privilege for this subject area." While Using 'AGGREGATE AT' Function ALONG WITH PERCENTAGE or When nesting the TODATE function inside IFNULL function as NON ADMIN user
(Doc ID 2714943.1)
Last updated on OCTOBER 05, 2020
Applies to:Business Intelligence Suite Enterprise Edition - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
When trying to use the AGGREGATE AT Function ALONG WITH PERCENTAGE or When nesting the TODATE Function inside IFNULL Function as a NON ADMIN user, receiving error message " You do not have access privilege for this subject area " when trying to edit the analysis.
NOTE: User having 'BIServiceAdministrator' can edit the analysis and the error does not occur but when user has 1) Authenticated User 2) BI
Consumer 3)BI Content Author roles only, this error happens.
Following are the examples :-
"Calculated Facts"."Actual Unit Price"/AGGREGATE("Base Facts"."Revenue" AT
........ adding percentage /making it calculated column, Following error is
"YOU DO NOT HAVE ACCESS PRIVILEGE FOR THIS SUBJECT AREA"
IFNULL(TODATE(FILTER("Base Facts"."2- Billed Quantity" USING "Products"."P1
Product" = '7 Megapixel Digital Camera'), "Time"."Time Hierarchy"."Month"),
NOTE: User having 'BIServiceAdministrator' can edit the analysis and the
error does not occur.
Also, NON ADMIN users can open this report but "edit" is an issue.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document