Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In QV desktop level, Direct discovery qvw working properly, But in Accesspoint its show data connection failed.
while reloading in QMC , there is no issues.
How to solve this issue?
any one can u suggest ?
Regards,
Bala
Have You tried to test Connection via ODBC Data Source Configuration on the Server ?
Yes. connection Succeeded.
Can You attach piece of script (lines of Direct Query) ?
Hi,
DIRECT QUERY
DIMENSION
Account_Id
measure
Billing_Amount
detail
Order_Date,
Status_Name
FROM $(vSchemaName).$(vTableName)
where Document_Type in ('N','S') ;
HI Avinash,
can u give any suggestions?
try without the where condition once because it have some issues with the syntax. and also try with the forced ODBC32 bit
Try
Native('where Document_Type in ('N','S')');
Hi,
not working..
even without where condition also not working...
If You have any System Monitor of Query, You can see what QV sends to DB.
Or You can activate LOG Query directly in ODBC Data Source