I've been using MSSQL for several years, but have not needed Analysis Services... until now, so I'm pretty new to OLAP.
We ship our product with a MSDE database and MS indicates that OLAP will not run on MSDE. The Product Overview
states: "[MSDE] Does not include any analysis capabilities (such as OLAP, DTS, data mining, and data warehousing features)."
It looks like all the cube structures are stored in an Access database (msmdrep.mdb), and the cube data is stored in .map and .data files under the Analysis Services /Data/ Directory..... so what part of SQL Server is it using? Can we ship a MSDE Database with OLAP capability?
If I don't get a reply here, I'll just start running some tests and see what works and what doesn't, but it would be nice to know if I'm heading down the wrong road before I invest a lot of time chasing a ghost.