《Microsoft SQL Server 2008 Analysis Services Step by Step》学习笔记三：Cube

g87616758

　　SQL Server 2008中SQL应用系列及BI笔记系列--目录索引
　　导读:在上文本创建维度（Dimensions）的基础上，继续介绍创建Cube的基本过程。
　　本文末尾提供两个项目源码：AdventureWorks_BI_Begin2和AdventureWorks_BI_End2,顾名思义，开始和完成。另外，包括数据库文件SAS2008SBS_Data，请读者自行修改数据源ds的连接串。
　　本文将包括以下内容：
　　■1、使用Cube向导创建一个Cube
　　■2、使用Cube Designer修改一个Cube
　　■3、将不同维度和粒度结合在一个单一的数据Cube
　　■4、重命名和格式化度量组和度量
　　■5、对已经存在的Cube增加度量组、度量、和计算成员
　　■6、使用Cube设计器浏览Cube
　　项目结构如下：
http://py7bfa.bay.livefilestore.com/y1p6dJbUsuT7AVQH7pydbgrXLYYP9iUJA0hRMKkHHp9kCWCVhI8mYd_ZXO6pHulw3F5X1Sh9g0-KT055_pic9YR6Lx5_yVPEno5/2011-4-23%2021-23-54.png?psid=1
　　1：使用Cube向导创建一个Cube
　　新建cube过程如下：
http://py7bfa.bay.livefilestore.com/y1pK__l0thd1R3i-0mKlKKiSiv4dQXO-URw2vS3NxVkltW2eXwEu1hA0GUB9zNRFqdSG0QawgZeeBv-kozmAbUCMXcZkau3iKg1/2011-4-24%208-36-01.png?psid=1
http://py7bfa.bay.livefilestore.com/y1pK__l0thd1R1uaFzNg9PxXveO9dOIJecxCTouZyFrb0thyQzQQGE7Ia10CQxdtRQWSA0rq-1JXNbx_yPz0xQ823NSGBdSPaex/2011-4-24%208-57-51.png?psid=1
http://py7bfa.bay.livefilestore.com/y1pldbOkX34mT7fq_puCevy04oGQoy5Y27mDtegrPrOSfe1UYzmSfT3dMrsMGCuTEExbosWNwjNiDtXWR6dgd_xRB-Im2ZZXA7H/2011-4-24%209-19-58.png?psid=1
http://py7bfa.bay.livefilestore.com/y1pzrqFTeyKODoMAOt6Mivx0rVfFNXN-JNXGXJOh9eUnzQDSZ3bt5xaU0fhjpjHYzUVCqXEl-KEcIOf17Wmei3AgnS6NS4Iaaf_/2011-4-24%209-27-21.png?psid=1
http://py7bfa.bay.livefilestore.com/y1pldbOkX34mT5gFzxSK0KvzlV80zU4-3S8N6nbY74JxeynnCRGwKA24esrL9rueODYUpk4I1noARzSuaw2SREWksZJl5PAukga/2011-4-24%209-14-05.png?psid=1
http://py7bfa.bay.livefilestore.com/y1pgjicMVr-CKIJmsE1aiYVvo1Xekh6QF1v6sKW6aURhR-F1WnjOaMilK8zRZB3_uBAOmlH8EUylQDjApL0B5zJDQRIJPnQgRMC/2011-4-24%209-29-11.png?psid=1
http://py7bfa.bay.livefilestore.com/y1pVaBdeSmhfcQqU0esb8ezCSgOF-yKO9Mqtb6NTHWyFGLL56lRJDE3Xdq4HhK-xTb_at39wJOwfXLfKPsZjLDaLV5beKtPDHqR/2011-4-24%209-35-06.png?psid=1
　　生成后，部署时如果已存在，会提示：
http://py7bfa.bay.livefilestore.com/y1pgjicMVr-CKIVUFMpV_sZ4jK-aNArmaqWc78yOjsROLbGijKIMh5p4Fh5CBzBD_W-oSyeDBMkLrWlS45Xmp6gxXEcDPO9ZFJ9/2011-4-24%2010-04-26.png?psid=1
http://py7bfa.bay.livefilestore.com/y1p6tfZrNzfNzGdYuIFkxCpPD0apbF7DSlZbY0og6MnSnbrbUR5fksF4c77plaOEx5rG5MJxUrrwbhZJBgu4DRuAFteHdtRq66t/2011-4-24%2010-06-32.png?psid=1

　　2：使用Cube Designer修改一个Cube
　　设计browser界面：
http://py7bfa.bay.livefilestore.com/y1pMks9AVGcUPXJ1wFQX2IP2ZE9dnVt_wrCSM9bd2mda8kuXipIi7hPuvRSqoAQl0xSFRJvUUYq0Up3c7EyCeAYAgK7RWDtlkdU/2011-4-24%2010-43-47.png?psid=1
http://py7bfa.bay.livefilestore.com/y1pMj-Uvlj7agTvZUKJuBLUY-IXYfYePydDOUqvM3u1mulp27Dq9IEj3TI0jZciSty24ECCfDtWWkQUJsyoYtmmYSoKbxN1sWyW/2011-4-24%2011-05-46.png?psid=1
http://py7bfa.bay.livefilestore.com/y1pb8EOK4LmXms64c2ZWP6MRVhUoxak_lerFHURUTRJzx8vys4BkYOqZhjJ_iK-K_3sXjib1qypDw7VTpnopX89n6GS2SThgJW5/2011-4-24%2010-51-30.png?psid=1
http://py7bfa.bay.livefilestore.com/y1peBkgBYmHMx91pnC1zWJt0MAVb3SjYU3729FFhvdsJEBfh9b0Z8X64r_lwIgKH_1GfZ3kvR2n01iJ56giMJLsES2ZJPU8Zzud/2011-4-24%2011-06-47.png?psid=1
http://py7bfa.bay.livefilestore.com/y1pix7cZl-JamJY0JCUGnoq9mJempaH4M6-ZIucdCQ-900myHJU3RYLpJWcusHh1vG9I0n4TShwjcMekx3Eas6dL9w6hMRwRYVm/2011-4-24%2011-10-19.png?psid=1
http://py7bfa.bay.livefilestore.com/y1pix7cZl-JamI_R-VU4uolZ-t63c4phusmoRFF95gaWDA-Qv7ISD8YU5MYli7IB7DPTQJ4anz-QSm3Z6qW7GESTFHH7C0UQxD1/2011-4-24%2011-03-28.png?psid=1
http://py7bfa.bay.livefilestore.com/y1p8UMX_cl1VkreJldBJXxpWrW2skB4vSxK6Z3MDF5NBnPUzByAr7ioktwS4fUYyNF9idwiGcZsZr8KJRHRJYn6uOeY2VNBW9UN/2011-4-24%2011-14-32.png?psid=1
　　修改Browser界面时需要先清空结果集。
http://py7bfa.bay.livefilestore.com/y1psjdP0u9x3bVGSbL7PSNoGhEuBrR8mCsrC9HC752_9jpvDu6J76mTqkTxv-L9JhmgM0sJzhAqBgafS_P4InZYLJIhITsAqOs4/2011-4-24%2011-42-38.png?psid=1
http://py7bfa.bay.livefilestore.com/y1pU61jZfcMICFYsAf_uUXFpYBgEwTuO8irxX_CtlgXMZdr3dJbrMlBVuCcg05o5SGaSU_43dQHMzfXd0kxg2mTjIl8OC3DI8sm/2011-4-24%2011-32-48.png?psid=1
　　3：将不同维度和粒度结合在一个单一的数据Cube
http://py7bfa.bay.livefilestore.com/y1p8WoH30HE1pzgyVibzBUQuy9-QlPlMY9B01VdNBPpGmCJnDsBkvB2J_GKgh8dONH67ttxfXQmZkPiBrNCZN1WWDGg6tSfdZBq/2011-4-24%2011-55-14.png?psid=1
http://py7bfa.bay.livefilestore.com/y1pYPGJXaEeIURpWiljlYjglnAp1ofCKXPxz_8SCDhn5rmPs6iwzCYZ90Q55bSXMsPd_Mq0TDrokRtyNybmdxshQMJynxyxUlph/2011-4-24%2011-48-45.png?psid=1
http://py7bfa.bay.livefilestore.com/y1pDrA4uOL34oC_U1iI4iCW7Z1w97FHr36HzEkaVQbYfq_ls2Yi61gHKAuOV2UUUAfymoN5dHFIlJk4QqP4WBiPOw3eitTIUAdo/2011-4-24%2012-44-36.png?psid=1
　　4：重命名和格式化度量组和度量
http://py7bfa.bay.livefilestore.com/y1pIUUjkISXKLorD05GY5eIRXoat-98SmFcHQ-b1vrd7jm3MUP0JUx62Y1ZKIniHp58hdIcUgsMlirnF_9Zfl0ZZRL5aCIsis0R/2011-4-24%2012-14-56.png?psid=1
http://py7bfa.bay.livefilestore.com/y1prHSDIJbMvRgionVpQhlizc663a9_1J12qsRAsCLZL_XnKArB2Ceqk6Rs2cYf36D8xLS2YkBPOOVkL3fZ58f8H_qf5y1eMIJz/2011-4-24%2012-22-21.png?psid=1
http://py7bfa.bay.livefilestore.com/y1p6O10oJbm5A4M4jnyw_VIs3m1qWJXXuGmEi0_Q8O7DrsqSIz9EJeQrTiWz5zLNCpGLe9Fxf2yGQ80c5EE3TF3swQgQegoFylk/2011-4-24%2012-49-04.png?psid=1
　　5：对已经存在的Cube增加度量组、度量、和计算成员
　　http://public.bay.livefilestore.com/y1pCrFcfneiMIw1lA6TMXUbudtjvv6JqWJ_6JTisJFLkTs37T5fVJ0PGJXpeRsqBfhCQM55iftGDt2i1T2bNEwteg/2011-4-24%2012-51-54.png?psid=1

http://py7bfa.bay.livefilestore.com/y1pziqsq7htiaZ7MGrmVoFRMSK3AKNu30Gqp-aOBTYeWvVhP_-4s9VtRk-Twyc57sk5vXtUmRTpwKsSDd3b65iQAuHSp9l-sHGI/2011-4-24%2012-53-12.png?psid=1
http://py7bfa.bay.livefilestore.com/y1pZWz13SkkyvvqHllD49FAW9d50xujMIvkBbNZL_sMhZ6CPLLPVUPXlYVM1vYc4Y_yi3eIEQJIh0UhDf2f84lBQZtUJTwbA8cA/2011-4-24%2012-55-38.png?psid=1
http://py7bfa.bay.livefilestore.com/y1plW7NkQKsQfkhmNDPjkvlsI-MQ757ub36loeDErvmmqzz3WWX3PX2e555JA1NKLCkmmyrgph78HJEL-vJ5yXvHOLlukw_0tal/2011-4-24%2012-56-32.png?psid=1
http://public.bay.livefilestore.com/y1p5G3JpnhOIEDGJPeZzkFPvB0-zH6eoFCBCU4cqrlXxakt6SgWk4TDeo9upwjkz0y-Kv98hXYXFeTk3xflWEvy1w/2011-4-24%2012-57-06.png?psid=1
http://py7bfa.bay.livefilestore.com/y1pIYDS4tESTYDF2CiiwTxo3t9zGRnfMqpBDazyU0QMPq7DyJKti_WSU1dcKQQXug-hgfw8ot-KgdV4X3oGdTzuV7sGt7M8W8yf/2011-4-24%2012-58-24.png?psid=1
http://public.bay.livefilestore.com/y1pmJGzN2mmz61hdD4sXgvWTdz9JKVwLV2LokF1WVg2w2kq4H-JdjfH9cHY6kJkMLJ4pPVh0lsRFN7e_GyToHsZgQ/2011-4-24%2012-59-21.png?psid=1
http://public.bay.livefilestore.com/y1pte3N3oFDmzrCAjk3ungS-wpBOrBXsQzhyx33v9EiJ_BxNN0SVb-PW0m2R63CJ3AG45GmijXEVh5yYUVNhTpq7Q/2011-4-24%2013-00-18.png?psid=1
http://public.bay.livefilestore.com/y1pZ3JQWMD_wm0CM3nvJbEHN1tfjte9UBNdPiA5JJRrHZ9agwehSJZlPxQIRkxSH2G0Jr-xLzozBj9TT-1Zj0Yt6w/2011-4-24%2013-05-33.png?psid=1
http://public.bay.livefilestore.com/y1pvS_F51BxDVTjyN-BCAF-vO-dYpubTGE_ta7qh5ITG9B5uAu9EzH5C6vy8G5KwHnzQpmhFPb6gUkG4CMDGIH1LA/2011-4-24%2013-12-53.png?psid=1
6：使用Cube设计器浏览Cube　　比较简单，略去。
　　小结：本文介绍了Cube的创建过程。下文将一起继续学习创建高级的度量计算。
　　。
　　附： SQL Server Analysis Services 官方教程（http://technet.microsoft.com/zh-cn/library/ms170208.aspx）
　　源码下载：
　　begin2
　　end2
　　数据库下载