Thanks for the Response. I have read Joe's article, but he does not go into details of setting up the Cache - to quote "I am not going to explain...

Thanks for the quick response Steve.

Yes, I should have added that local disk could be an option. As the company is more geared towards the use of SANs and...

Hi Larry,

What Recovery model are you using on the Database?  If you are using the "Full" recovery model then you have a few options using the Transaction Log.

Kind Regards,

Nigel.

Hi Colin,

Thanks for your comments.

Yes, we are dropping and re-loading data each day, as the system that we are loading from does not have any way of identifying new or changed...

Hi Steve,

Many thanks for the response.

We are using SQL Server Enterprise.  We do not currently know if we can add physical memory (it is an old box, and will be...

Hi Clay G,

Thanks for your response.  I deliberately renamed all of the object names for anonymity, but this seems to have caused more confusion than it was worth.

We have now...

Hi Rockmoose,

Just to complete the post with info for others facing the same issue, we resolved the problem by re-applying the filter to the data returned by the Drillthrough prior...

hi Rockmoose,

Many thanks for your response.  In my example, "World" does not correspond to the All Level, so hiding the All level would not help.  Profiler is great for monitoring...

Hi Shaki,

Back in the days of SQL 7, we migrated it into a separate database and called it OLAP_Rep.

When the name change came with SQL 2000, some bright spark decided...

Many thanks, Andy, for putting me out of my misery.

I had tried various searches on gibtab and gibcol together - gibberish seems entirely appropriate here.

wibble, wibble, wibble (with apologies to...

Hi there, no response as yet!

Please could someone try the following:

Set up a trace on a SQL Server running Analysis Services 2000, under Events select 'Errors and Warnings' in addition...

Hi Control,

You're a bit off-topic with this question in this forum, but try the following url on this same site - the question has been answered before in the 'Administration'...

Thanks for your responses, Phil and Anzio - very clear.

Unfortunately, I was hoping to find a solution without changing the Precedence of following tasks - I knew about this being...

Hi AnzioBake,

As I see it, you can only successfully use DTSExecStat_Success at the end of an ActiveX Script step. I need to set other types of steps off also...

Thanks for your suggestions.

AnzioBake - Sorry, but I don't really understand your suggestion - could you flesh it out with a bit more detail for the example?

Andrew, the use of...