In Analysis Manager, right click your server and ensure you've got query logging turned on.  You can decrease the number to record more queries (default is 1 in 10 queries). ...

Like i said, depending on what you're looking to do, sometimes it's easiest to backup and restore, but if you are looking to use archive and restore, ensuring that you...

ARe you using AS 2000 or Olap Services (ie SQL 7)? 

THese two KB articles (303415, 249698) refer to your problem and offer a work around if your one file...

Well, you were there in Feb'03 when they said 'what new?  Its easier to ask whats not new...' 

I quite like the new DTS,...

I have also found the speed to be a bit disappointing.  I've not spent any time in the relational side as yet, only the BI tools (AS, DTS, RS and...

Geez, I hope it gets better in SQL2K5....  The way to do it is set the report properties to have the number of columns you want (e.g. 3).  You can...

Based on the (potentially flawed) assumption that you've got an olap connection/data in your spreadsheet, the safety option/s can be set in the connection string used for the worksheet (stored...

I'm trying to change mine to SteveOriginallyFromOZButNowInUS.....   Anyone got a spare visa sponsorship for a hardworking aussie?

'Be careful what you wish for, you might get it'....  THis is functioning exactly as you've asked it to, with no all member, it's using the default member for the...

You might want to seriously think about migrating to a seperate DB (ie don't use msdb) so you can back it up and resotre it seperately also.

Have you tried to use a role and set the top level of the dimension to be the level below the all member/all level?

Jamie,

Not the preso I was referring to, and probably all too late, but if you look for Dave Wickert in the list of presenters at http://www.microsoft.com/usa/presentations/search.asp?sKeywords=&sDistrict=South%20Central&sortby=Presenter&SortOrder=ascending you'll find one of...

Have you got process logging on your AS machine?  It may help to compare the start and ends times of the actuall processing on the AS box with whats reported...

Further to Jamies post, Cizer (http://www.cizer.com) will be releasing their second report authoring tool (Report Builder) for Reporting Services on the 2nd of Aug (don't shoot the messenger if...

Larry, I am searching to remember where I saw it, but I thought Dave Wickert (in a preso) gave a possible hack/cludgey (3rd party process viewer??) way to see which users...