I want to ask, is there any kind of "official" solution, or step to test if an OLAP (XML/A) connection for MDX queries is alive? Just like "Check Db connections" step. I think Ping-ing a host is not enough.

I use Microsoft Analysis Service 2005, with the default XML/A settings, so my XML/A URL is http://host:80/olap/msmdpump.dll

Or should I make a transformation, with an OLAP Input, with a test query, and if it fails, it means, I have some problem with the connections?

Have someone any experience about this?

Thank in advance