The Author Online Book Forums are Moving

The Author Online Book Forums will soon redirect to Manning's liveBook and liveVideo. All book forum content will migrate to liveBook's discussion forum and all video forum content will migrate to liveVideo. Log in to liveBook or liveVideo with your Manning credentials to join the discussion!

Thank you for your engagement in the AoF over the years! We look forward to offering you a more enhanced forum experience.

RACAND (1) [Avatar] Offline
We are just starting to use Reporting Services and are working with 2008. We are migrating away from Cognos 7.4. Cognos has the concept of a catalog which allows end-users to pull data elements from folders to build reports. The catalog builds the sql behind the scenes based on join paths that are specified. We use one very big catalog with about 200 tables and a few thousand columns. The tables are almost all dimensionally modelled. We had a recommendation from a consultant we are working with to put all our data in Analysis Services cubes and build one really big cube with all the data we combine for reporting which can be just about everything and involves alot of many to many relationships. This doesn't make sense to me. We definitely plan to build alot of Analysis Services cubes where possible but it doesn't seem like it will solve all our issues with creating reports. Will report models work and if so should we build a few big models and possibly use perspectives or should we build several smaller models. I would appreciate any feedback. Thanks.