It is hard to answer without more information, but just to try to point you in the right direction, you can add a where to your query to select a...

I'm not going to say that there is anything wrong with that, I'm just going to provide an alternative that has worked for me. I set all of the...

To quote the developer of cozyroc "the only easy part of excel is the end user experience." couldn't have said it better myself. But go ahead and post your...

nah, just post on Monday and we can figure it out. It might take a ticket to microsoft, but someone knows the answer.

Nope, property of the package:

http://msdn.microsoft.com/en-us/library/ms141766.aspx

If you want to add this as to a sql agent job, be aware this property only applies to debugging in the package.

There is...

I think the jet engine is only 32 bit, so you would need to drop the package down to 32 bit if you wanted to use the jet engine.

can you capture the mdx and post it?

isn't that the all member? I'm not sure I follow?

wait, you write the data into a stage table as varchar and then you pull it back out to analyze it and write it back to another sql table?

I'm not...

That error seems to indicate a problem with the an ole db connection. What is the source? 9 times out of 10 this problem comes from conversion/truncation problems. ...

Not trying to sell software because I get nothing out of it, but if you need to do anything complex with excel use cozyroc.

This is not going to work... "2011" can not just be compared to members like that. Maybe lookup the filter function or the instr function.

That could be anything..what mdx generates the error...are any events logged...are any dump files written...what does your ssas config have for memory settings...did you run a profiler and capture all...

I like the step-by-step books. Also a big fan of the new mdx cookbook.

Can you post your exact MDX query? I am thinking you don't need to use sum function, but I need more data about your cube.