"Direct Query Failed" Error using Direct Discovery

[#1]

Hi

I am using QV 11.2 SR7 version client. Using the Direct Discovery feature, I am trying to fetch data from SAP HANA database(Calculation View) using ODBC connection.

So my script reads like below:

ODBC CONNECT32 TO HDB;

DIRECT QUERY

DIMENSION

SALESMANNAME,

COUNTRYNAME,

REGIONNAME,

AREANAME,

OUTLETGRPNAME,

TEOUTLETTYPECODE,

OUTLETTYPENAME

MEASURE

CALLFREQ,

NO_STORES

FROM

"_SYS_BIC"."CPG.dra/Z_CA_DIST_OUTLET_COUNT";

This all works fine.

However when I create a bar chart or straight table with any of the above mentioned Dimensions and Expressions,

it just displays an error message saying "Database connection failed" or if I create a table box with any of the Dimension,

it gives error as "Direct Query Failed".

Has anyone come across similar errors?
Your help and inputs are highly appreciated.

Thanks in advance

Sabal

[Sarye]

Hi,

I ran into the same issue with SQL Server. In the script part, setting the following parameter solved the issue for me :

SET DirectEnableSubquery=true;

Here is the doc explaining what this parameter does : https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/DirectDiscovery/using-s...