29 aprilie 2011 11:02
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.
2 mai 2011 13:13
I get the same error with What If analysis, but goal seek works fine. Not sure why yet.
2 mai 2011 21:41
I'm getting the same error in the "What-If" analysis as well. just now i uninstalled and reinstalled the tool. but same thing.
- Propus ca răspuns de Jufre Espinoza 7 octombrie 2011 17:55
28 noiembrie 2011 17:52
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.
- Propus ca răspuns de Dennis Baker 7 septembrie 2012 14:34