You could try the Excel Add In/Acellerator for OLAP (search MSDN using those terms).  It will elt your users use the OLAP data in Excel in quite free form ways.

Hi Ben,

have you tried adding 'Time Intelligence' to your model?  SSAS can build time from either data you supply or build and populate atime dim itself (i've not tested this...

The answer to both is yes.

Analysis Services is a separate windows service, which in AS2000 runs as MSSQLServerOLAPService. You'll see this running as msmdsrv.exe in your task manager if you're looking...

It's a little dated now (still refers to the 'Yukon' codename) but this preso shows some high level features around the UDM and scalability plus better management and tools. 

If you're happy to have the underlying ObjectID not change (e.g DB is currently called StevesDB so the ID is also StevesDB), you can you SQL Server Management Studio to...

re: dimensions playing roles -> Analysis Services 2005 supports Role Playing Dimensions, where you can do what you described in your initial post but without the limitation that Mike described.

You could try setting up a second virtual dir.  The guys at ssw. have some instructions on how to have a public copy of your reports as well as an...

They should also install the developer edition of SSRS, this will then mean they can open *.rdl files in their VS, otherwise it doesn't recognize the file format as being...

What we do (in our SSRS 2000) install is keep the datsources in a separate folder to all of the reports.  SSRS2005 does this by default (ie it has a...

Maybe I'm not getting the point but couldn't you:

 - add a new column to what you've already got in your source, called 'Delivered' which has a 1 if delivered date...

Hi Patrick,

I read this from a blog in my blog role and thought you may find it of interest (can't say useful because it doesn't really *help*).  http://www.mrachek.com/PermaLink,guid,7cb06281-9394-438b-b2aa-8996106ee481.aspx

Cheers,

A common approach used to solve this (many-to-many) is to use a bridging table with a weighting factor (that you use to ensure that the totals are correct when rolling...

If you're running Analysis Services 2000 then the logging/tracing functionality is reasonably limited.  You can check the Query Log (defaults to logging only every 10th query) *but* this log doesn't...

Yes, it can hold the connection info in the workbook.  You can get to it programmatically (ie VBA/macro) , you could also try opening the workbook and holding ALT-SHIFT-F11 (takes...

Assuming you've alreasy checked that the AS service is running, have you got the SQL Browser service running?  I find that I can't make a server connection without this.  I...