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?