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

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