Translate

Friday, 11 April 2014

Shahed

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']} 



About Authors

Shahed Munir

Krishna Udathu

Shahed and Krishna are Oracle / Big Data Experts