Charles,

Now OLAP is a different kettle of fish ... but to do some serious OLAP you
really want it linked to a database server ROLAP, MOLAP or HOLAP anyone? SQL
Analysis Sevices looked quite handy on SQL Server 2000 & I remember my days
administering a TM1 server fondly (well that is a bit strong) Apart from
where some nugget consultants tried to bolt on some relational data ... it
all comes down to training.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"Charles Williams" wrote:

Seems to me there is a large class of calculation problems that do not work
well in DBs, just as there is a large class of data manipulation problems
that do not work well in spreadsheets, not to mention OLAP.

I would be surprised if anyone who has worked extensively with both SS and
DB would disagree.

Of course there are a lot of people using DBs when they should be using SS
and a lot of people using SSs when they should be using DBs, and not nearly
enough people using SSs linked to DB engines!

regards
Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com