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.
LOAD *, OSUser() as User;
SQL SELECT *
FROM "mydb"."public"."DDQ" where User = 'DOMAIN\anil';
Using Direct Discovery
OSUSER() as User,
"mydb"."public"."DDQ" where User = 'DOMAIN\anil';
The Reason I intend to add User after DIMENSION, Because I've read this portal Image
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
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.