Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OBIEE 12C Session Variables are not working as expected

Gopi MannavaAug 17 2018 — edited Nov 22 2018

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.??

Comments

Christian Berg-0racle

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"

Gopi Mannava

What about for the users when they logged in everytime.

Saresh-Oracle

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

Christian Berg-0racle

Put it into an init block in the RPD

Gopi Mannava

Thank Sareesh. I will look in to it.

Gopi Mannava

Did the same way Berg but no luck.The variables are appending automatically.

Gopi Mannava

Hi Sareesh,

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

Thanks,

Gopi.

1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details