Hi, Kindly find below the physical sql: -------------------- Sending query to database named MIGRATION (id: <<2061598>>), connection pool named MIGRATION, logical request hash 6d4c347a, physical request hash d2e3e7ae: [[ WITH SAWITH0 AS (select distinct T275032.PERIOD as c1, cast(T275084.BRANCH_CODE as INTEGER ) as c2,…

Sir, I 'm not able to generate physical sql even after enabling LOG_LEVEL to 5.

SET VARIABLE QUERY_SRC_CD='Report',SAW_DASHBOARD='/shared/Real Time Analysis/_portal/Real Time Analysis',SAW_DASHBOARD_PG='Planning',SAW_SRC_PATH='/shared/Real Time Analysis/vibatest/test_session';SELECT 0 s_0, "cbssybpocpr"."Dim Branch"."Region Code" s_1, "cbssybpocpr"."Dim Branch"."Region Name" s_2 FROM "cbssybpocpr"…

The query i have sent is user-specific and if a user belongs to 'Zone-A' it would return 4 codes as mentioned and if user belong to 'Zone-B' it would return 1 row. But atleast 1 row would be returned for any user. Also i have tested the above init block in offline mode and it returns 4 rows as below. V_ZONE_CODE 805…

Yes . Even i have tried using IN operator in the filter query of the criteria tab still the same .

DM_BRNCH.REGION_CODE = VALUEOF(V_ZONE_CODE)

My init block contains the following query: select 'V_ZONE_CODE' , c.region_code from dwhbiusr a, ur_level b, dm_brch c where a.user_level = b.user_level and a.id = '38900' and a.branch_code = c.branch_code and a.branch_code not in (select terry_code from terry_mstr) union select 'V_ZONE_CODE' , r.region_code from dwhbiusr…

Yes i'm getting the result in offline mode as below: V_ZONE_CODE 805 V_ZONE_CODE 806 V_ZONE_CODE 807 V_ZONE_CODE 808 Only when i use the valueof(NQSESSION.V_ZONE_CODE) in answers i'm not getting the value as desired. Even the valueof(NQSESSION.V_ZONE_CODE) returns valued if it has only one value. Kindly help.