Have you looked at or tried Reporting Services yet?  It will let you paste the MDX and then returns a flattended result that you can then put into a crosstab,...

PTS is Pivot Table Services, it's what's used by Excel (and ultimately everything else) to connect to Analysis Services 2000.  Why don't you want to use the Excel pivot tables? ...

have you included or referenced the pth correctly within your xp_commandshell call?  mormally getting  'not recognised' error means that either you haven't included the path to the executable or the...

Kitkat -> hope you get it to work.

Coach James -> Don't flame the messenger   Just so you're sure it isn't just me that's...

might have been  typo, but do you have '=' (without quotes) at the start of your sql statement e.g.

= "select abc, def, ghi from some_table....."

re: the msmdarch not working, you need to check which account is being used to run the sql agent service and whether or not they're a member of the olap...

Hey Kitkat,

if your current query for the dataset is a call to a stored procedure ( in Generic Query Designer mode) the drop down at the top right is set...

Have you now secured this site/page?  Everytime i try the url it wants authentication for the machine at 192.168.2.120 (internal ip i'm guessing?)

That's an annoying 'feature'.  The way i usually get around it is to write a similar stored proc that returns the anticipated column names.  It's obviously 'cheaper' to just write...

Have you checked your RS log files?  Maybe a check of the even log could also shed some light on whats happening?

If you search for Teo Lachev and also Hitchhikers guide to Reporting services (first ones an author, the second a book by 2 guys who've written similar books for other...

As per BMiller's post, you can definitely query AS2K via TSQL using linked servers (ie use openquery) but you could also try opendatasource (ie don't have to have a permanent...

The connection string will be stored in a file named <something>.oqy, so if you earch on your drive/s (usually in the C:\documents and settings\<user>\... for *.oqy you should come up...

Is there anything special about your stored procs?  I just tried this against a SQL2K (sp3) DB via SSManagement Studio (June CTP) and it worked fine both to query window...

Do you have a Role set on the catalog/cube?  What context are the reports on the server being run under? What security setting/s do you have on the datasource (windows authentication?)