Table of Contents

OBIEE - Dashboard Prompt with data level security

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