Does this support AS 2000?
Whenever I try to add a calculation in Excel 2010 pointed to AS 2000, I'd get the following error. My Calculation is very simple - only referencing just another measure, e.g., [Measures].[Actual Sales].
Data could not be retrieved from the external data source.
Error message returned by the external data source:
Syntax error in axis definition, near: '[Measures].[Actual Sales]'
There was a problem creating the calculation:
Exception from HResult: 0x800A03EC
Here is my connection string:
Provider=MSOLAP.2;Integrated Security=SSPI;Persist Security Info=True;Data Source=Server;Initial Catalog=OLAPDB;Client Cache Size=25;Auto Synch Period=10000;MDX Compatibility=1