Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Query timeout setting in Desktop

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

0 Replies