I am getting this error irrespective of cube size(even 0.03mb). If you get to sort this issue, do let me know.

Many Thanks

Daniel, I'll try the second option. Many Thanks to you and PW. Any further ideas/suggestions are still welcome.

Hi, Thanks for your reply.

I did exactly as per your instructions, but I get this error:

ADO error: Syntax error or access violation

when I specify the SQL for the lookup: SELECT...

My cube contains both private and shared dimensions and I am trying to do a Copy/Paste withing the same database. (Not across databases) and its running on SP4.

The error still...

I really need help on this error/problem. I have SP4 running on the server. Any other cause why I can't copy/paste a cube. There is more than sufficient hard disk...

The 2 cubes do share a few dimesions which I will process prior to processing the cubes. They can have similar private dimesions too. Will it be possible to process...

Thank U...I'll check the SP version.

Thank you.Wish there was an easier solution though.

Sushila, Thanks a ton! I hadn't explored the option you mentioned.

It worked and I've gained more SQL knowledge. Thank U once again

Thanks Steve. I'll check and get back definitely tomorrow.

Thank you for the valuable tip. Yes, you are right, I did notice the size increasing, but wasn't sure why. I'll incorporate your suggestion and hope it works fine.

Thank you once...

It worked!!! Brilliant..Thank you so, so very much.