For more information, please refer to this announcement explaining best practices for getting answers to questions.
Strange OTBI Error:[nQSError: 27046] Inaccessible column
Summary:
Strange Behavior, getting the below error however respective Job Role/ Duty roles are assigned to the user but still users are getting the below error (Screenshot attached below).
Background:
I've created an analysis that filtered the data based on the logged-in Username Session. Here username is of Line Manager, the data is their Direct Reports.
Filter Used: (Screenshot attached below)
User Name is equal to / is in@{NQ_SESSION.USER}
Investigation
There are 2 Subject Areas used in the analysis.
a. "Workforce Performance - Performance Rating Real Time"
b. "Payroll - Element Entries Real Time"
I've checked the below Oracle Mapping and found