Monday, August 17, 2009

OBIEE Prompt based on groupmembership

Somebody on OTN claimed that you can’t make prompts available based on the security setting of the user (See: http://forums.oracle.com/forums/thread.jspa?threadID=943712). Here is a workaround based on guided navigation:

First create a report which filters results based on the group  (noprompt) membership:

SELECT TIMES.CALENDAR_YEAR saw_0 FROM BM_SALES WHERE LOCATE( 'noprompt',VALUEOF(NQ_SESSION.GROUP)) > 0 ORDER BY saw_0

image

image

Based on being a member of nogroup the prompt will be available:

User1:

image

User2:

image

Till Next Time

1 comment:

Roel said...

Do you also have the issue that when having this setup with two prompts, with different default values, the reports are behaving wrong?

For example: two sections, both guided navigation based on either results or no results of a request.
Two prompts in the sections with different default values for the same field.

When testing this with both users, the users get the default values from the first section configured.

Any solution to this?

Thanks,

Roel