Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
4
Views
6
Comments
1391185
1391185 Rank 3 - Community Apprentice
edited Aug 13, 2024 5:46PM in Oracle Analytics Cloud and Server

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.
Format ContainerRemove View from Compound Layout
View MissingView 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.
Format ContainerRemove View from Compound Layout

View MissingView Missing
View tableView!1is missing from the analysis.

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    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
    1391185 Rank 3 - Community Apprentice

    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
    Robert Angel Rank 8 - Analytics Strategist

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

    This screen =>

    pastedImage_0.png

  • 1391185
    1391185 Rank 3 - Community Apprentice

    FITB MNPI Answers is the role which I created

    pastedImage_0.png

    pastedImage_1.png

    pastedImage_2.png

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    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
    1391185 Rank 3 - Community Apprentice

    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