We're using Cognos so have no idea about Reporting Service, maybe sth related to its architecture. As for data warehouse, I personally suggest you to make some preparation on Surrogate Key, Slowly Changing Dimension, [#3739887@0 -ROLIA.NET 相约加拿大网上社区 之 枫下论坛 & 枫下部落, 枫下论坛主坛 ]
We're using Cognos so have no idea about Reporting Service, maybe sth related to its architecture. As for data warehouse, I personally suggest you to make some preparation on Surrogate Key, Slowly Changing Dimension,
by
renjl0810
(不是一般的笨)
at
2007.6.13 13:12
(#3739887@0)
difference or comparison between star and snowflake schema ...