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

Question

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.

1391185 · Answer

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

Robert Angel · Answer

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 · Answer

FITB MNPI Answers is the role which I created