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