Parser error while using Excel Analysis Tools - Goal Seek Algorithm

Question

I'm running Table Analysis Tools in Excel using the example spreadsheet DMAddins_SampleData.xlsx.  Since I'm new to these tools I’m not much familiar with the errors triggered by SSAS.  While running the "Scenarios Analysis: Goal Seek" algorithm, I'm getting the following error in the Goal Seek dialogue box:

Query (1, 46) Parser: The syntax for 'value' is incorrect.

Any idea what is causing this.

Thanks,

Zafar

 

Answer 1

I get the same error with What If analysis, but goal seek works fine. Not sure why yet.

Answer 2

I'm getting the same error in the "What-If" analysis as well.  just now i uninstalled and reinstalled the tool.  but same thing.

Answer 3

Are you connecting to an SSAS 2008 R2 server?

The word "value" is a reserved keyword in MDX and as such cannot be used as a parameter name in a query on an SQL Server 2008 R2 Analysis Services server.  This change was introduced in 2008 R2 as part of the integration of the DAX query language for PowerPivot and inadvertently broke the data mining add-ins since they generate DMX statements with parameters that may match MDX reserved keywords.

The data mining add-ins will still work against a SQL Server 2008 server, but for now may generate errors against a SQL Server 2008 R2 server.  A fix is planned to resolve this error by relaxing the keyword parameter matching restrtictions on SQL Server 2008 R2. The fix will be released in an upcoming Cumulative Update for 2008 R2 SP1.