Not able to create analysis with custom Roles and Groups in OBIEE11g

1391185

Hi

I am using OBIEE 11g. I created a custom role and group and associate them with a new user in console and EM in obiee 11g.

Also associated BIAuthor group to newly created group in Manage catalog section in Application.

When I am trying to create report using corresponding SA, getting attached error in Result pane.

Also Advance tab and Prompt is not coming.

The view that was in this position in the Compound Layout (titleView!1) is no longer available. Please select a view from the list above. View Missing View titleView!1is missing from the analysis.

The view that was in this position in the Compound Layout (tableView!1) is no longer available. Please select a view from the list above.
View Missing View tableView!1is missing from the analysis.

Robert Angel

Take a look at this.

https://bifundamentals.wordpress.com/2017/01/06/security-roles-policies-in-obiee-11g/

See => Oracle BI Presentation Catalog to configure privileges for Users.

Have you worked down this to check the rights your role / user has compared with what they have using a standard role?

1391185

Hi Robert,

Thanks for replying.

I have done all steps mentioned in the attached link, still I am not able to create report with BIAuthor role.

Please help.

Thanks

Robert Angel

On all steps, can you post the rights granted to your new role - a screenshot or two would do it?

This screen =>

1391185

FITB MNPI Answers is the role which I created

Robert Angel

Okay - look at what you have written -

"also Advanced Tab and prompts is not coming" - now see the bottom of your screenshot against "Create Prompts" and "Access Advanced Tab" (bottom of the screenshot) - I see "FITB Admin" - but I do not see -> "FITB MNPI Answers" which is the role you say you have created. So without the explicit grant the role does not get the rights and the user with the role does not get the rights.

Custom roles tends to be a painstaking and iterative exercise.

If you must do it at all I would advise starting by entirely replicating a role, say 'BI Consumer' and then removing the rights in small sections and double checking what disappears - it is not always obvious as I think you are proving.

1391185

Hi Robert,

Thanks for your help, Now I am able to see the result in newly created report.

We upgraded from OBIEE 10g to 11g, so thought it supposed to work like that way.

After adding roles manually it started working fine.

Thanks