Direct Discover Where Clause Issue

[Anil_Babu_Samineni]

Hello Friends,

I am very fresher to Direct Discovery, All Inputs are Valid.

I am not sure what i made mistake here. While i am trying Normal it's working Good. Same thing i tried from Direct Discovery it's not working. Would you let me know if anyone have idea about this, Please assist me if anyone allows earlier by same pros.

And DB Connection is there.

Normal:

LOAD *, OSUser() as User;

SQL SELECT *

FROM "mydb"."public"."DDQ" where User = 'DOMAIN\anil';

Using Direct Discovery

[DirectDiscovery]:

DIRECT QUERY

DIMENSION

last_name,

first_name,

Images

MEASURE

OSUSER() as User,

contact_id

DETAIL

country

FROM

"mydb"."public"."DDQ" where User = 'DOMAIN\anil';

The Reason I intend to add User after DIMENSION,  Because I've read this portal Image

[sunny_talwar]

AFAIK, OSUser() is a QlikView function and cannot be used on DIRECT QUERY. There might be another way to do this using Section Access, but my knowledge of Direct Discovery is rather limited and I wouldn't be able to offer help related to the section access route. One thing I know is that the section access is done through QMC, rather than adding a section access script in the script for direct discovery.

[varshavig12]

Dimitri's comment:

DD & section access problem

[Anil_Babu_Samineni]

Yes, Sunny. As i know OSUSER() is QlikView Function. I am eagerly looking for Other way like this.

[Anil_Babu_Samineni]

Yes, I agree his response. I know Very Limitation offers by using Direct Query. I am looking for Sunny Suggestion again. In Fact, All inputs are valid too.

[Anil_Babu_Samineni]

Any other inputs. I am happy, If some one can try help so that i can follow the inside link-link.