My Oracle Support Banner

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 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms


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
"Time"."Time Hierarchy"."Year")*100

........ adding percentage /making it calculated column, Following error is
displayed -

"YOU DO NOT HAVE ACCESS PRIVILEGE FOR THIS SUBJECT AREA"

                              OR

 IFNULL(TODATE(FILTER("Base Facts"."2- Billed Quantity" USING "Products"."P1
Product" = '7 Megapixel Digital Camera'), "Time"."Time Hierarchy"."Month"),
0)

 

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.

*******************



Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.