OBIEE 12c Variables for Default Value

OBIEE 12c Default Values from Session Variables in Dashboard prompt

Using Variables in OBIEE Prompt 12c for Default Value

sql Results -- FROM is Subject Area Name

Use the Syntax Below for a session variable to be displayed in a dashboard prompt default value.

SELECT
valueof(NQ_SESSION.defaultyear) FROM "DELIVERBI Financials Reporting"

Variable Expression

Use the Syntax Below for a session variable to be displayed in a dashboard prompt default value.This is the preferred approach.

@{biServer.variables['NQ_SESSION.defaultperiod']}