I have pout together some reports in Excel 2010 that reference SAS OLAP cubes. These worked fine when initially set up. However, when the cube is refreshed I get an error back:
<?xml version="1.0"><Exception><SASMessage severity="Error">An MDX syntax error occured</SASMessage></Exception></Exeptions>
This seems odd given that the report worked before the cube refresh and nothing within the cube itself has changed.
Also, the area that I think is the problem is the:
=CUBEMEMBER(connection, measure, caption)
Furthermore, after this occurs I am able to create a seperate cubemember and point this to another measure. However, is I point this to the same measure in a different cell it returns #N/A.
Has anyone else come accross this issue at all?