SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Using Cube formulas in Excel 2010 with SAS OLAP cubes

Reply
Contributor
Posts: 22

Using Cube formulas in Excel 2010 with SAS OLAP cubes

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?

Post a Question
Discussion Stats
  • 0 replies
  • 298 views
  • 0 likes
  • 1 in conversation