Skip to main content
I get the following error while trying to "Export Data (XLSX)" from an OLAP Table:
"Failed! (Syntax error near < after reading () at line 2"
The Analysis settings allow excel and csv export of analysis components
"Export Cases (XLSX)" works fine

Hi @rebeca.padil12,

 

It sounds like your OLAP table contains characters that have a special meaning in the Excel File. An Excel file is in XML, which contains a lot of '>' and '<' signs. Also the backslash '\\' has a special function often. Based on your error code, do you have any of this signs in the table?

 

Kind regards,

Jan-peter


Hi, just to let you know the issue and solution

 

In my Dimension I had a variable, that inside the variable had another variable... This is the reason of the error message

 

Solution: I had to change the second variable for a direct constant


Reply