OBIEE - Dashboard Prompt with data level security

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Presentation Service (SAW/OBIPS)

1 - About

Example of dashboard prompt with a data level security.

The session variable can be row-wise initialized.

3 - Parameters

3.1 - 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;
Advertising

3.2 - 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