Cube view export to CSV or XLSX fails with non-descript error
book
Article ID: 221001
calendar_today
Updated On:
Products
IT Analytics
Issue/Introduction
While exporting a cube view, the following error window is displayed:
An examination of the POST headers captured by the browser's developer tools reveals the following for DetailsGridExport.aspx:
error=XML for Analysis parser: The XML for Analysis request timed out before it was completed. Timeout value: 3600 sec
Cause
The XML process handled by the SQL Server Analysis Server (SSAS) is reaching the server's timeout limit before completing the generation of the export file.
Environment
Release : 2.9.x
Component : Cube Browser
Resolution
Change the value of the SSAS setting ServerTimeout from 3600 to 360000:
Using SQL Server Management Studio (SSMS), connect to the Analysis Services server hosting the IT Analytics cubes
In Object Explorer, right-click the SSAS server's hostname and select Properties
In the Analysis Server Properties window, select the General page
Select the box labelled Show Advanced (All) Properties