Heres a stored procedure I wrote sometime ago to generate get, add or update and delete stored procedures so you get the performance benefit of sps. As the naming convention...

Thanks for the confirmation, I'll have to get back to the tool provider to get a work around..

My spanish isnt great but I think you mean that you cant connect to your cubes via the analysis services management tool - just run service pack 3 or 4...

In addition in AS2k (and probably 2005) you can add the same table twice, just alias it as another table which will enable you to accomplish the above without views.

Assuming the query is fine have you tried adding indexes (may use index wiz to analyse query), rebuilding indexes nightly, autoupdate stats etc. If youve done all the above look at...

could it cause an issue with space allocated in temp db/memory etc. when running queries etc, vaguely remember this being a preformance issue in 6.5?? Presumably if you allocate x bytes for...

To change the collation you can either detach the databases, change the server collation, rebuild the master database etc., reattach each user database and run the script below (wrote it...

change the mdx query to a string & you have to build up the mdx by inserting your dimension names.

e.g. "select measure on axis(0), [dim].[" & param1.value & "] or axis 1...

theres a sharepoint addin for OWC. Also take a lookup at the upcoming business scorecard manager as it does this very elegantly.

Ok this was escalated up and was caused by an invalid entry for index size which exceeded the 8060 byte limit - possibly a row overwriting next page in file??...

I've managed to get a backup to look at and we can reproduce the issue on sql server 7. The same table is ok on sql server 2k. So its...

the titles being truncate the full error is

[Microsoft][ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler: Process 9 generated fatal exception c000008e EXCEPTION_FLT_DIVIDE_BY_ZERO. SQL Server is terminating

also its worked fine on sql 7 sites for some time & there hasnt been a patch for years. As its happened on two independent sites I can only think...