topic Re: Direct Discover Where Clause Issue in QlikView

Direct Discover Where Clause Issue

Anil_Babu_Samineni — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Direct Discover Where Clause Issue

sunny_talwar — Fri, 04 Nov 2016 11:09:28 GMT

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.

Re: Direct Discover Where Clause Issue

varshavig12 — Fri, 04 Nov 2016 11:32:29 GMT

Dimitri's comment:

DD & section access problem

Re: Direct Discover Where Clause Issue

Anil_Babu_Samineni — Mon, 07 Nov 2016 16:27:36 GMT

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

Re: Direct Discover Where Clause Issue

Anil_Babu_Samineni — Mon, 07 Nov 2016 16:29:06 GMT

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.

Re: Direct Discover Where Clause Issue

Anil_Babu_Samineni — Fri, 11 Nov 2016 12:12:50 GMT

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