Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
row wise initialization for session variables not working in obiee 11.1.1.7.0
Answers
-
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"
WHERE
("Dim Branch"."Region Code" = VALUEOF(NQ_SESSION."V_ZONE_CODE"))
ORDER BY 1, 3 ASC NULLS LAST, 2 ASC NULLS LAST
FETCH FIRST 100000001 ROWS ONLY
0 -
Can you give us the physical SQL? What you just posted is actually the logical SQL.
0 -
Sir,
I 'm not able to generate physical sql even after enabling LOG_LEVEL to 5.
0 -
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,
cast(T275084.REGION_CODE as INTEGER ) as c3,
T275084.REGION_NAME as c4,
cast(T275084.TERRITORY_CODE as INTEGER ) as c5
from
DIM_BRANCH T275084,
BI_DEPADV T275032
where ( T275032.BRANCH_CODE = T275084.BRANCH_CODE and T275032.PERIOD = 20161222 and cast(T275084.REGION_CODE as INTEGER
) = 805 ) )
select distinct 0 as c1,
D1.c1 as c2,
D1.c2 as c3,
D1.c3 as c4,
D1.c4 as c5,
D1.c5 as c6
from
SAWITH0 D1
order by c5, c4, c6
Regards,
Bhuvan R
0 -
But where you are using the logged in user details in query to find the appropriate group?
0
