Absolutely, if you have a choice definitely go for AS & SQL 2005.  The ProClarity doco on migrating from 2k to 2k5 also recommends doing a complete rebuild.

I don't believe that you can increase the page size in SQL but I'm not sure you'd need to either.  Is your concern around the SQL performance or the AS...

Is the measure that you're trying to drill on a 'true' measure or a calculated member/measure?  You can only drill through on measures that are sourced from the fact table.

Can...

Hi Alan,

re: 10g, no commercial experience using it's AS just personal testing & eval.  My current take-aways:

i) I can't see where you'd add the complex calcs 'to the cube' but...

Have you tried using the Office Excel AddIn for Analysis Services?  The drill through on this definitely works and doesn't require you to do any coding (which if you're using...

I haven't found enough time to test all of this yet but I would definitely recommend AS2005 (rather than 2000) if you're going to make the swap across.  If AS2K5...

Yes, in most cases (ie other than small demo's) you need to change the process buffer size. 

If you haven't already you should definitely take a look at the Performance...

I haven't tested this but have you tried escaping the ampersand for the url?  So a space becomes %20 and "&" becomes %26 . 

This is how standard web...

Is it a windows 2003 server machine?  And if yes, have you enabled (in IIS) the aspx extension? 

Another option to look at if you've got Office 2003 clients roaming about and access to a WSS (free sharepoint on WIn2003), the Business Intelligence Portal from Microsoft.  It has...

That is why you could use a scenario dimension, this allows you to edit the emasure value for a particular scenario. 

If you don't provide a way to differentiate the...

Did you apply the service packs cumulatively or just SP4 after doing a fresh install?  It would appear that some SP3 fixes weren't included in the SP4 release, so there's...

I haven't seen this before but it almost sounds like a version imcompatability issue - if it can't find the entry point (ie the method/function) in the dll it's trying...

If your repository is still in MSAccess you could try doing a repair on that, if there is/was any corruption this should be fixed by doing the repair.

You've checked to...

You have a few options.  You do need to move/copy the Repository to the new machine.  I would install the s/w and then apply all service packs that bring it up...