7 Replies Latest reply on Aug 20, 2018 2:00 PM by Gopi Mannava

OBIEE 12C Session Variables are not working as expected

Gopi Mannava Aug 20, 2018 12:43 PM

I would like to append the following code DISABLE_CACHE_HIT=SESSION VARIABLE.

The other one is the following variables are appending automatically.

SET VARIABLE QUERY_SRC_CD='Report';SELECT

SET VARIABLE QUERY_SRC_CD='Report',SAW_DASHBOARD='/shared/Fixed Assets/_portal/Fixed Assets',SAW_DASHBOARD_PG='Overview',SAW_SRC_PATH='/shared/Fixed Assets/Reports and Prompts/Acquisition/Financials vs Non Financials';SELECT

Can someone help on this. What i was trying to do is i want to pass disable_cache_hit on report run time for every user when they login by session variables.??

1. Re: OBIEE 12C Session Variables are not working as expected

Christian Berg Aug 17, 2018 4:24 PM (in response to Gopi Mannava)

You add this to the LSQL in the Advanced tab of an analysis. Prefix field.

SET VARIABLE DISABLE_CACHE_HIT=...

Or simply take it from John's blog: Oracle Business Intelligence OBIEE 101: OBIEE the "developersprompt"
Like Show 0 Likes(0)

Actions
2. Re: OBIEE 12C Session Variables are not working as expected

Gopi Mannava Aug 17, 2018 6:23 PM (in response to Gopi Mannava)

What about for the users when they logged in everytime.
Like Show 0 Likes(0)

Actions
3. Re: OBIEE 12C Session Variables are not working as expected

Saresh-Oracle Aug 18, 2018 5:08 AM (in response to Gopi Mannava)
Hi,

Please check the below notes:
OBIEE 11g - How To Disable Cache for a Single Report ? (Doc ID 2085805.1)
How To Temporarily disable Caching or Change LogLevel For A Specific Request (Doc ID 1272485.1)
How To Prevent Caching In OBIEE? (Doc ID 1955926.1)

Thanks,
Sareesh
Like Show 0 Likes(0)

Actions
4. Re: OBIEE 12C Session Variables are not working as expected

Christian Berg Aug 18, 2018 12:21 PM (in response to Gopi Mannava)

Put it into an init block in the RPD
Like Show 0 Likes(0)

Actions
5. Re: OBIEE 12C Session Variables are not working as expected

Gopi Mannava Aug 20, 2018 12:38 PM (in response to Saresh-Oracle)

Thank Sareesh. I will look in to it.
Like Show 0 Likes(0)

Actions
6. Re: OBIEE 12C Session Variables are not working as expected

Gopi Mannava Aug 20, 2018 12:43 PM (in response to Christian Berg)

Did the same way Berg but no luck.The variables are appending automatically.
Like Show 0 Likes(0)

Actions
7. Re: OBIEE 12C Session Variables are not working as expected

Gopi Mannava Aug 20, 2018 2:00 PM (in response to Saresh-Oracle)

Hi Sareesh,

The document you sent won't work for users. We are looking for user level.

Thanks,
Gopi.
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.