BI Publisher (MOSC)

MOSC Banner

BIP11g - Logical query with VALUEOF(NQ_SESSION.USER)

edited Sep 17, 2013 2:50AM in BI Publisher (MOSC) 6 commentsAnswered
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>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center