EXECUTE DIRECT DATABASE REQUESTS

3512682

Hi Folks,

Is 'EXECUTE DIRECT DATABASE REQUESTS' has been deprecated for BI ADMINISTRATOR ROLE?

If yes, then what are the alternatives for accessing the DB directly?

Thanks

Robert Angel

it isn't, that I know of, have you seen ->

https://www.micheledinuzzo.it/obiee-12c-direct-database-request-configuration-nqserror-13017/

n.b. You also have the option to create an opaque view; -

https://gerardnico.com/dat/obiee/obis/opaque_view

3512682

Even after setting "Allow"  for "DDR" in Identity Manager for BIAdministrators Role, I am still seeing the same error.

Am I missing something here?

Gianni Ceresa

3512682 wrote:I am still seeing the same error.

So you have an error in front of you, that's new ...

Help the community in helping you

Robert Angel

You changed the setting against the connection pool also, as described in the link I posted?

3512682

Finally, I got the results.

There was a mismatch between Roles from the privileges from Presentation Admin to Identity Manager.

Thanks guys for pitching in.