OBIEE - Dashboard Prompt with data level security

Saw Object

About

Example of dashboard prompt with a data level security.

The session variable can be row-wise initialized.

Parameters

Show

Logical SQL Result :

SELECT
  Organisation."Organisation Team" saw_0
FROM
  MY_SUBJECT_AREA
WHERE
  (
    (
      Organisatie."Organisatie Team Centercode" = VALUEOF(NQ_SESSION."MY_TEAMS_CENTERCODE")
    )
  AND
    (
      VALUEOF(NQ_SESSION."GROUP") NOT IN ('Administrators')
    )
  )
OR
  (
    VALUEOF(NQ_SESSION."GROUP") IN ('Administrators')
  )
ORDER BY
  saw_0;

Default value

Logical SQL Result :

SELECT
  ifnull(MIN(Organisation."Organisation Team"),'-') saw_0
FROM
  MY_SUBJECT_AREA
WHERE
  Organisation."Organisation Team Centercode" = VALUEOF(NQ_SESSION."MY_TEAMS_CENTERCODE")
ORDER BY
  saw_0





Discover More
Obiee 10g Server Variable Session Repository
OBIEE 10G/11G - The (dashboard|column) prompt

The dashboard prompt is the most used prompt to filter rapport in a dashboard but it can also set: a presentation variable variable prompt a request variable In 10g, for a repository...



Share this page:
Follow us:
Task Runner