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…

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

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?

Have also been seeing the requirement for field level redaction being asked for more often recently..

The other one is typically AD, I rarely see any other variants.

Probably only about 1 in 10 for SSO recently, but I foresee that this will probably be the thin end of the wedge and that demand will gradually ramp up...

Simple one to try in IE; - make the site a 'trusted site' and then ramp all security to minimal for trusted sites and retest.

See => Case Study: Emailing OBIEE dashboards with ad-hoc agent that dynamically passes dashboard prompt values based on user re…

Amen to that. Reminds me of a client who was cloning Essbase databases every year so in very little time what should have been 5 databases became 96... There is the value of the architect over the dabbler...

Not that is supported. But you can export your catalogue items to your client. Do a search and replace exercise using something like Notepad++ and then reimport, provided your naming discipline is entirely parallel, year to year.

Yes - it does not dynamically repoint the location of everything.

Hi Ritesh, Your answer made me smile... The idea is that you press the 'Assume Answered' button to just close the call without awarding points if you think no one has helped you or you are not feeling generous. At the other extreme you can click on 'Answered' and it will close the call and award points - if you are marking…

Thanks Ritesh, glad you got there and respect for the fuller documentation for the benefit of others. Can you close your question also please and mark as appropriate.

Possible! See => https://docs.oracle.com/middleware/12212/biee/BIESC/GUID-59844BCC-0EB0-4FDE-8011-75E7C8AEA82A.htm#BIESC3145 And Restricted below What Are the Proxy Levels? When you enable a user to be a proxy user, you also assign an authority level (called the proxy level). The proxy level determines the privileges and…

You can do it in answers using rank as a filter on the analysis; - RANK(ticket_number BY employee_id) = 1 Other ways exist using the rpd, like creating a max measure on the ticket number and pinning it to the employee_id level of your employee dimension hierarchy.

If I understand what you are asking for then; - Change your column prompt to sql and add the following on the end; - union Select distinct 'WhatEverYouWantForAllValuesHere' from dual - you may have to change dual if it is not in your DB - pick any SMALL table Then in your filter, change it to SQL and; - Dimension.Field in(…

Okay, on "simple" - it starts that way and then invariably another requirement comes your way, and another, and ... before you know where you are you are buried in user expectation with a tool which will not satisfy their requirements. At best you will build a limited functionality Frankenstein monster which will be flakey…

Is this what you are looking for => Case Study: Emailing OBIEE dashboards with ad-hoc agent that dynamically passes dashboard prompt values based on user re…

Possible, maybe... Advisable, definitely not. OBIEE is a BI tool, not an interactive planning and modelling tool. You might get it to work but it will not have the rich functionality you need and will probably not be so great for the users to interactive with. If your need is small then better to look into Apex;…

I always thought the idea of IT was to improve efficiency, effectiveness and achieve economies and improve business information. Maybe I am alone in this?