My Oracle Support Banner

OAC: Cannot Enable Pivot Table Privilege For Custom Analyst Role (Doc ID 2807539.1)

Last updated on SEPTEMBER 17, 2021

Applies to:

Oracle Analytics Cloud - Version 106.1.0 and later
Information in this document applies to any platform.


Created a custom OAC application role (MyCustomRole). This role has create/edit analysis privileges on a specific subject area set in the Catalog.  Have granted this role the ability to edit the subject area in Answers and the role belongs to BI Content Author, which has the ability to create and edit views, including pivot tables.
However the button for adding a pivot table view is not present when a user is logged in with the custom role. Checked all the privileges and permissions but still don not know why the pivot table button is not appearing for this role.

Checkin other users with another custom role and they are able to see the pivot table button.
Replicated the permissions of a working user to the MyCustomRole role, but the pivot table button is still not appearing.


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

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