BIP11g - Logical query with VALUEOF(NQ_SESSION.USER)
Hi,
when i execute a logical query to view VALUEOF(NQ_SESSION.USER), always BISYSTEMUSER returned.
I connect with other user.
An example:
SELECT
0 s_0,
"Test"."- Testa Data"."Cod. Data" s_1,
VALUEOF(NQ_SESSION.USER) s_3
FROM "Test"
The result is:
!--Generated by Oracle BI Publisher 11.1.1.6.9--><DATA_DS><G_1><S_0>0</S_0><S_1>#</S_1><S_3>BISystemUser</S_3></G_1><G_1><S_0>0</S_0><S_1>01EB</S_1><S_3>BISystemUser</S_3></G_1><G_1><S_0>0</S_0><S_1>01ES</S_1><S_3>BISystemUser</S_3></G_1><G_1><S_0>0</S_0><S_1>023M</S_1><S_3>BISystemUser</S_3></G_1><G_1><S_0>0</S_0><S_1>0CAB</S_1><S_3>BISystemUser</S_3></G_1></DATA_DS>
when i execute a logical query to view VALUEOF(NQ_SESSION.USER), always BISYSTEMUSER returned.
I connect with other user.
An example:
SELECT
0 s_0,
"Test"."- Testa Data"."Cod. Data" s_1,
VALUEOF(NQ_SESSION.USER) s_3
FROM "Test"
The result is:
!--Generated by Oracle BI Publisher 11.1.1.6.9--><DATA_DS><G_1><S_0>0</S_0><S_1>#</S_1><S_3>BISystemUser</S_3></G_1><G_1><S_0>0</S_0><S_1>01EB</S_1><S_3>BISystemUser</S_3></G_1><G_1><S_0>0</S_0><S_1>01ES</S_1><S_3>BISystemUser</S_3></G_1><G_1><S_0>0</S_0><S_1>023M</S_1><S_3>BISystemUser</S_3></G_1><G_1><S_0>0</S_0><S_1>0CAB</S_1><S_3>BISystemUser</S_3></G_1></DATA_DS>
0