If you have the option (eg no drill through), you could always pre aggregate the data in SQL. This would reduce the load time and aggregation time.

The problem ony exposes itself in our front end - Proclarity (maybe I should have mentioned that to start) everywhere else things seem fine, however, I didnt check the browse...

Thanks for that.

I've noticed google isn't very good at returning specific microsoft searches. I always try and goto http://msdn.microsoft.com/default.aspx and search from there. You get much better results.

I hope things...

Hi,

We usually only get a 117 when there is a large non empty cross join MDX statement thrown at us, however, there have been other MDX combinations that have had...

Have a look here - http://www.sql-server-performance.com/service_packs.asp

You could trying a partitioning strategy, ie. Partition the tables by month and create partitions on the cube that look at the tables, this would also increase cube responce time....

How about drop indexes, truncate table, insert into, create indexes.

Doing this should be just as quick and won't affect your drill through.

Question, do you reprocess the cube daily? Reason I...

Joe,

In my opinion you apprear to be handling this in reverse. You usually only identify which tables you want from the ERP system based on the project requirements, rather...

Thanks for the link, the performance section has a good counter for 1 HT processor = 2 normal processors, and confirms Steve's advice.

Looing at Steves last post do you think...

Have you sheduled this job to run while your in the office? It appears that the connection has been lost when the job ran. This could be for a number...

I've taken CAGreensfelder's advice and had a look at the MS templates. There's a Access wine database that with a little work will do what I want, so I think...

Your right, we have spiraled of the subject a little but, in a good direction.

Everybody, don't think I haven’t noticed each and every persons very choice wording and underlying...

Blue Nun anyone.

Does sushila need a guy? a chick who can down several pints and knows how to fine tune a SQL server has got to be in high demand.

I drink, get drunk, fall unconcious, wake up, recover, forget whether I liked the wine the previous night or not, cannot impress chicks with knowledge of good wines, have slightly...