An Analysis Services 2008 nugget

Darren Gosbell · 23rd June 2009, 07:30 PM

I was experimenting with some of the PerformancePoint APIs today, but I was doing something wrong as I kept getting ERROR! back. I assumed that some of the parameters that I was using was resulting in invalid MDX being generated. I was running against a test database on SSAS 2005 and as I suspected there was a syntax error in the MDX. Unfortunately Profiler against SSAS 2005 showed me the error, but not the offending MDX, which was not much help.

On a whim I decided to move my test database to SSAS 2008 and what do you know - profiler now shows the full MDX in the error message! This allowed me to see that the it was the parameter that was mapping to the slicer that was not working.

I'm sure there are plenty of other little areas of fit and polish like this which don't make it into an official feature list, but make it worth upgrading to SSAS 2008.

More...

23rd June 2009, 07:30 PM	#1 (permalink)
Darren Gosbell Member Join Date: Jun 2009 Posts: 27	An Analysis Services 2008 nugget I was experimenting with some of the PerformancePoint APIs today, but I was doing something wrong as I kept getting ERROR! back. I assumed that some of the parameters that I was using was resulting in invalid MDX being generated. I was running against a test database on SSAS 2005 and as I suspected there was a syntax error in the MDX. Unfortunately Profiler against SSAS 2005 showed me the error, but not the offending MDX, which was not much help. On a whim I decided to move my test database to SSAS 2008 and what do you know - profiler now shows the full MDX in the error message! This allowed me to see that the it was the parameter that was mapping to the slicer that was not working. I'm sure there are plenty of other little areas of fit and polish like this which don't make it into an official feature list, but make it worth upgrading to SSAS 2008. More...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Market Analysis	JohnG	Open Source Analytics	5	9th November 2009 04:06 PM
JMP® Genomics 4.0 adds flexible analysis options, visual tools	Latest News Headlines	SAS Forum	0	5th May 2009 04:33 PM
Workshop: SQL Server Analysis Services 2008 Development	glove	TM1 Australian User Group	0	13th February 2009 09:25 AM
Business Analysis	binboy	BI Appliances	0	28th January 2009 09:48 AM
IBM Analysis Finds Consumer Expectations Remain High in 2008 Despite Dramatic Shifts	Latest News Headlines	IBM and Cognos Forum	0	23rd December 2008 09:29 AM