Query timeout setting in Desktop

Fri, 04 Oct 2013 14:57:50 GMT

Hi,

I have a user who is loading from SSAS cubes to QlikView desktop, via an OLE DB connection. The query works fine in SQL Server, but in QlikView the load script ends without logging any error message. We think it might be a timeout issue--I know you can set the query timeout in QV server, but is there a way to do it in the desktop application? (Or any other ideas would be appreciated.)

Here is the query, in case there is any problem with this query in QlikView:

SELECT

{

[Measures].[Published Provincial Sales Volume],

[Measures].[Share of Published Provincial Industry],

[Measures].[Share of Published Provincial Price Segment]

}

DIMENSION PROPERTIES PARENT_UNIQUE_NAME,HIERARCHY_UNIQUE_NAME ON COLUMNS , NON EMPTY

CrossJoin(

{[Brand].[Item].Children},

{[Channel of Sale].[Anal Sales Sub Ch].Children},

{[Geography].[Province].Children},

{[SCENARIO].[Be Id].ALLMEMBERS},

{[Time].[Month].Children})

ON ROWS

FROM [PPS Complete]

Thanks

topic Query timeout setting in Desktop in QlikView

Query timeout setting in Desktop