"You do not have access privilege for this subject area" when i use AGO

Frog Toad

Hello!

OBIEE 12.2.1.2.0

Not admins can't opened analysis to edit, when analysis have AGO. Error-message "You do not have access privilege for this subject area"

Example:

I have simple Analysis with only one subject area

Columns:

"YEAR" | "VALUE" | AGO("Value", "Calendar"."YYYYMMDD"."YEAR", 1)

When user try open analysis to edit, then he get message: "You do not have access privilege for this subject area"

(It's ordinary user. Not admin. User have privilegies to the Subject area in "Manage Privileges")

I (admin) can open this analysis to edit, without problem.

When i will delete column with AGO and save the analysis - ordinary user can open analysis to edit.

When i return column with AGO - user again can't opened it to edit

Funny, that user can make new analysis using columns with AGO. But after he save analysis, he can't open it to edit.

How i can fix it?

Christian Berg-0racle

Hi Frog, (ribbit)

Is the column itself blocked in terms of permissions? I.e. is it set to "No Access" in the presentation layer?

Frog Toad

Hi Christian

No:

Read for Authenticated User

And

Default for other roles

This is true for all columns and folders in subject area

Robert Angel

Just a thought, the AGO function uses the date hierarchy in its inputs, does the user in question have rights to those, or is your date hierarchy not exposed in the presentation layer?

And, is the AGO created in the rpd or in the analysis?

Also, is the date in question in the same presentation subject area as the other fields in the report?

Frog Toad

> Just a thought, the AGO function uses the date hierarchy in its inputs, does the user in question have rights to those, or is your date hierarchy not exposed in the presentation layer?

Hierarchy was maked in PRD. And was moved to presentation level (defauls permissions)

User see it

> And, is the AGO created in the rpd or in the analysis?

AGO is used in analysis:

AGO("Fact"."Value", "Calendar"."YYYYMMDD"."Year" , 1)

> Also, is the date in question in the same presentation subject area as the other fields in the report?

Yes, fact-table join with calendar-table, using a special date-field (join and in physical and in business level)

Sherry George

This might be a bug. I did see at least one other thread with a similar issue. Issue with Time Series Calculations . Also oracle support has a bug listed "Oracle Support Bug 24813298 (12C:AGO CAUSES "YOU DO NO HAVE ACCESS PRIVILEGE FOR THIS SUBJECT AREA")". But that is for version 12.2.1.0.160719. I would suggest to open a ticket with Oracle.

Ebin Cherian

Hi Frog,

We initially had the same issue in 12.2.1.1.0 and we applied patch 25187465. After that we were able to edit the report with "AGO" function. But now we are facing the same issue in certain other scenarios.

Scenario 1 - Different levels in the column formula.

TODATE("Margin Measures"."Gross Revenue","Time"."fiscal time"."Fiscal Quarter")-TODATE("Margin Measures"."Gross Revenue","Time"."fiscal time"."Fiscal Year")

Scenario 2 - Apply IFNULL condition with TODATE

IFNULL(TODATE("Volume Measures"."Volume","Time"."Fiscal Time"."Fiscal Year"),0)

We raised an SR and Oracle created a new bug for this issue.

Bug 26088535 : YOU DO NOT HAVE ACCESS PRIVILEGE FOR THIS SUBJECT AREA ERROR WHEN EDITING REPORT

Thanks

Ebin

Frog Toad

So, that is bug. Ok.

Yes, i will make SR

Sherry George, Ebin Cherian - thank you