Q. Is it possible to load ratios at each level of a dimension and avoid cube aggregations? In this case, the components of the ratios are unknown and cannot be decomposed, but the ratios at each level are known.
A. Take a look at Richard Tkachuk’s article at http://sqlserveranalysisservices.com/OLAPPapers/Loading%20Aggregate%20Data%20in%20AS2005v2.htm. The first part of this article explains [...]

Last month, Microsoft posted an excerpt from from the book, Microsoft SQL Server 2005 Reporting Services Step by Step on the MSDN site. In this excerpt, you learn how to use Integration Services to extract data from the Reporting Services database to analyze performance data, such as processing and rendering times for reports. This excerpt expands [...]