Hi BI Gurus,
When I login as Mr.X user to check a report, it throws me "[nQSError: 27005]:A general error has occurred. [nQSError: 27005] Unresolved column:Country.Region" error". Though it is a generic error which comes up when any column is missing/misspelled in RPD, it seems to occur only for Mr.X.That particular column has got 'READ' permissions to 'Everyone'. When I login as Admin or as Mr.Y who has same privileges as Mr.X, I'm not getting the error. Pls help me to fix this issue.
Thanks in advance.
Please perform a troubleshoot .... uncheck "Mr.X" (don't give read access ) and give Read permission to everyone . Then check whether the same error message is displayed .
If so , revert back to read permission to everyone and check . Could be an abnormal behaviour of OBIEE and this practice worked for me earlier .
This is related to privileges. This column has been made as part of data level security. You can change the permissions who can view this column by going into the RPD Presentation Layer and clicking on the Permissions of the column.
Hope this helps.