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
"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
Page 1 / 1
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.