《Microsoft SQL Server 2008 Analysis Services Step by Step》学习笔记十七：管理分区及数据库处理（下）

wxsheng

　　SQL Server 2008中SQL应用系列及BI笔记系列--目录索引
　　导读:本文介绍Analysis Services管理分区及数据库处理。
　　本文将包括以下内容：
　　■1、使用ROLAP或MOLAP存储配置维度
　　■2、使用ROLAP、HOLAP、MOLAP存储配置度量组
　　■3、配置刚性属性关系（Confgure rigid attribute relationships）
　　■4、使用“处理更新”处理选项处理维度
　　■5、使用“处理增量”处理选项处理分区
　　■6、配置主动缓存
　　■7、创建、合并、管理度量组分区
　　■8、导入Analysis Services设计到Business Intelligence Development Studio项目
　　
　　本文末尾提供两个项目源码：AdventureWorks_BI_Begin14和AdventureWorks_BI_End14，顾名思义，开始和完成。另外，包括数据库文件SSAS2008SBS_Data，请读者自行修改数据源ds的连接串。
　　
　　6、配置主动缓存
　　切换到Business Intelligence Development Studio (BIDS) ，

http://uiyqfw.bay.livefilestore.com/y1pkayOgiX1osK2q2kIKl7DBdJsDxE-QetOxZwCZAS4O4LFnohbGbE2aLTHTyAyAXk8nBX91SoXWA3363EGFlJ_0JBYdR-gQX99/2011-6-5%2023-59-39.png?psid=1

　　默认为MOLAP,不启用主动缓存。

http://uiyqfw.bay.livefilestore.com/y1pESrngmWTw73Bu6Ws1uT_DkGZWFB5Gp_ovaSpmLtyLZltaplos4lCwDWeiqyQLxA5D1yLzVcURBJNWh1jH6tfH4WKmbE_hLgE/2011-6-6%200-02-55.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1pTTBdHEzUKlphIf1RN20qblvGXpNJIR9JLflQTRy2H9OFiH3RKpk5hMMyZ4fhKGJlcUaxSKpcBuihgkQ2FchGgyNgH-dmNwC6/2011-6-6%200-03-23.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1p5o1QHo5EY0cjJ9Wa5LAFsC3k3a3zcsmdt4U4W_CaV-eO1uzEzqqqQtZMEwxqxnCfaLc0BkSHXOJrE1XaCvIMIIK_w-0Xj_Rs/2011-6-6%200-04-27.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1pB-DY7PZ-zLVduX5QVhymo-elJqdjuxpMQXL_NTzFepxyiswabCLq_XBb4FDsqjxlNuHburp9K0UJeE1JnRoVjBQP7kEf7e8W/2011-6-6%200-05-50.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1pfrcSvxMV7FOY3Dx0GLoa3fMYmgu-q5llTQ_RUQgVA5ulkIVVl1RN1_4-KKx9Sa28I0l4cSBmwxSq4oIkmm7oQY3kYOGU037u/2011-6-6%200-07-49.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1pIMtBstIZqPRYKGWUQR5Zs0Vkj9nmF1JKdwOFThKaKOog_MEvmWCYqrYQt3dgLRYExatf8wiL3uIw1_KsE8iZddXjbmUOpzOt/2011-6-6%200-09-14.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1ph3oPaxcBmrE-T3UFt-lUsLiJbTSsCPzgAplBgMLD9yCkzbdE2nRm6ELvtJLrWx1T-ABwShM4pwr9kb29HpxkElZEFnMxzuEh/2011-6-6%200-11-08.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1ph3oPaxcBmrG6QtajUbrecDqCLWQbNO6wzuXvBz8VPzxUC5n4RS_thSUupq4_iGwAL-9EOe960tGNuSAbNCcwIIQWqeoSlG5m/2011-6-6%200-12-26.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1px8uknbszsYDQoOSiPiSCOcqjyJ3nKhudxS1L_KzQ2ocj8qkdJvDH8FOKeDXchwS9aDQZiEUm6X7jH747Kr6rNGnOzWmQHKu_/2011-6-6%200-13-59.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1piEvKnA05i0lgLTBhMClPXfmrY3IUpjj0SKQASVEw3l0QN1c3ukvA2nWGl-ID4LReEqWEWlZy33yQpvl5ND1los-VV0gX7Zpf/2011-6-6%200-14-36.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1piEvKnA05i0k5zUtTwY_D15DrVS-67xNq53cN82W0dFkHjdxiVlLuBdxSPaBUlW4v0HjILdqUbyS3hOi2hqBQnDyBLmFzkj5j/2011-6-6%200-16-33.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1pjusipOYgFP09GzgivV5xxEgYkCd3egyGozfWg35-a3IEy9siqitnR6Jb8ab30MqI-mcDurcgXlmX4I4cHCIUPATB6gOnUE5M/2011-6-6%200-17-10.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1pjusipOYgFP1ar8CFAAaClqk_-RRlW-8OeVelBfToxt879MnheZ5lGG0ZfbnBH_KGENFUvgeO1M166ZA6ec8Egsdzyy3Esv8m/2011-6-6%200-18-36.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1pcfqnFu9NAJkEr7ddsKXmv9Oxcm3FizRYi13HS5d4HY2n1d6hiIBu1-2ukq2tG4n7DOedP1OW6v4zj1LRwTBq2L_Bqmq-I0YY/2011-6-6%200-23-48.png?psid=1

　　部署项目，切换到SSMS，在MOLAP右键Browser，Reconnection

http://uiyqfw.bay.livefilestore.com/y1pdEuaAO1EEBPPArmj3723NmQ-g02Nw3UOFDc6HsQkHdhbQHWWDqqfekWELMrCayb95XOM4jreVj0xCyYec4CeFnxVE8pVHbex/2011-6-6%200-33-49.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1p66L4QHSvlee4PUlV8I7jNr-4nVvnKagxVommEJ0K2HS26o2N0fWjR6jZcPz80Mekf3CEwltHxJF_AMEZaRFrOJxN6ZN4h70a/2011-6-6%200-37-05.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1pM8Vq02swnGkCz_HZxFG4UgwBNWkKLdVvZev6TJWzO11_29d40uNGLmhW2jJvmGq1ce_sw8qYO8j1Ff8hm8N4dwehq1IRreTC/2011-6-6%201-16-13.png?psid=1

　　7、创建、合并、管理度量组分区
　　创建分区：

http://uiyqfw.bay.livefilestore.com/y1pM8Vq02swnGm5PjwQytMuzQxSYPbE9Qp7RoNL3s4zU_5hmTa-4sV9k33ksuC6Uvli-xAQe588m8n3uepfJGYbPjR3isLh_dqV/2011-6-6%201-31-52.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1p-W36e2QISCvGGOVSGssOWUW9zigY-HL_jqWEfKqpJWnJyVapyxfwoZLTs8_588f196OMhpbyVURYPBGZBjHJg4-q8cq4S0Ri/2011-6-6%201-33-10.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1plpINZGupR4efYsy2p22iK4dY8V6u7fxqfpbMlLGRhan4QGIAEtW-fgKtIEDvZapW-F24EZH1J6OfhvLC2Ygkk3lLTZ3lYrZv/2011-6-6%201-35-07.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1plpINZGupR4c0sgO9PdgSyYq4tm-ZVAu7AjlfaXxyHb9wpExYh_yQf-U6LPLxZLLBn7g5-negh0Ef3NvzJudIKld8ADS844ac/2011-6-6%201-36-37.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1pvPQ1q6Mub70r0_j4IXPMNZaFsyNa-0eni8eKAHkehJT-utnaV8jxadUU8ifaxM_D0nA1WXy8pAvEiKv5wnazjnofZRErIcua/2011-6-6%201-38-14.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1pvPQ1q6Mub73_WC_bn7RK94oiSM4EsQwlGtJ0YtpU3Q6cxMY3UHB5mI31lGU5jwDHdIHqa8-uffqMj6_CLYR7BcWn4VyWCwNd/2011-6-6%201-39-24.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1pgbszUvswyiQhDqOxB2vlDR1WZ8U6rZQd4ZQh2lOJiz7sa261sskFcFP3fKsA_1RBBvdZpCF-9Ph8NV1N_g7WrJJ_1oo9SHyJ/2011-6-6%201-40-50.png?psid=1

　　同理，再建一分区

http://uiyqfw.bay.livefilestore.com/y1pgbszUvswyiSBlpA56UlHasktignzFFz4KsjWXkYJ5cV0VJa0o8Wm-npXz7k3b3Vbf4FE7zZAgIoP_9YoBZJ0drbq90K4AjKU/2011-6-6%201-43-52.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1pgbszUvswyiRPVB6ufULP5ZzYOJWaTYH5FP2YEHb8h-gaTU8mZsKZbGdSiEbB2rW0viqSAq-kNuX25Q6SR6Jeb6zI8unLCX4P/2011-6-6%201-45-23.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1plfhAnINq5kvUgV2mFolUVHHInqf6x1N8EAXPEUFLdI_pCblLIodKkjDRcRgIkfrfI18OORv62dKF0Sk-nL30arDbXggK0Fuf/2011-6-6%201-46-20.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1ppbIB1OiHyY9HFeRMmcQT_eK4wkrqjXpWJ2lhJ2QgM7pi-QriF6ptHujnmjT4iTThD_SouIRo7t_k5AeBHaKp4ybV0XyPQhSg/2011-6-6%201-49-21.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1ppbIB1OiHyY-BdaYggTV8zm2X8axwlF6_TiwfL6-RGFUrJjdQCBvDlBCq7oVUgKQyw1zYilAWikW-k2aqaG09SxfhGohr5WpT/2011-6-6%201-50-41.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1pd7_YNaNHncq_6uhDJuIF09NAjUoAnf1hbDI2hERfLh1VfkLvddUcN08iRbFgjqibZELJhsjFxd6CDOIFKVZHJ2RkpfbslvX-/2011-6-6%201-52-32.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1pd7_YNaNHnco7ipvNLYSu6FmjCo-KeqKRUk3yaTwNKUu2kutRy-z1B1c8bNPSfmkmrGKcimV051gZOP3GU1AK6CzTnxkgNaBG/2011-6-6%201-53-39.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1p2X-LWbsPq3ybyFJyg1323iXT6UpqesJ_cjqpaQ1zXYOl2YD9jO8CJ3t9i4gdcH0mJ_uNvHAUIeA_0QpWBbUq-9wKb6-Q6mJJ/2011-6-6%202-23-55.png?psid=1

　　处理其他两个分区

http://uiyqfw.bay.livefilestore.com/y1pY1d08bEQ9tn-6H66eingFV0icVqWnLvDqzsilKhAm5fE96wgD6RvvjDh7LYIC0Arjfg3HhO9jiOb7z6YA6lisZODN4LBRjEW/2011-6-6%202-50-00.png?psid=1

　　部署项目。
　　合并分区：

　　切换到SSMS

http://uiyqfw.bay.livefilestore.com/y1pZmWtMzNbu2kzLV-W8VY5U81eAMMfGba26smh0xBGHVyaLm1C6qh4-a382sQ1PS_jO4PL8wB8I1E12t-daT61cf5aGS3WKj8Y/2011-6-6%202-54-08.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1pZmWtMzNbu2lUxPdINH1ghg-zQp384uUura0CbDP63v2iiYrU_bmTF22ri4vyQ4KgWV1RAnKukvcSegUG_jXF7C8G5g2zZUnT/2011-6-6%202-55-23.png?psid=1

　　修改数据源

http://uiyqfw.bay.livefilestore.com/y1pbc5E6y1qBOnP2V3tUy4K27OYrtKIvYEZV2eOCIQZUfc6w8KfX-e971bszh5QhVot4ZFFlgeIHxybLrxtbLQv4PlDPzTMobY0/2011-6-6%202-59-42.png?psid=1

　　
　　8、导入Analysis Services设计到Business Intelligence Development Studio项目
　　切换到Business Intelligence Development Studio (BIDS) ，

http://uiyqfw.bay.livefilestore.com/y1p4IxkidwMSWNIHNwOsU2hMiVZtltOIbx-4PAY-MLmtSSNmNJUITFxFAUopuG7THIs6Yk_7TNVIWBW6pmGUlsnE8ZwhR56trBO/2011-6-6%203-04-22.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1pPfbrT9t5190G0azBLPxplKPH4ZikZrBop1VgrpgJz5BIl7eXPrn4Sk_rsi6LVIT4IHq73oByHn2q3GLggC3Dop555868O3SX/2011-6-6%203-06-16.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1p5ByNkkwbFoxqRE7SxslNSBcM3hKYsQnGQJryDTsNjHixeSCPzR0BNCLyOLlIVr86UFqH3uzqmDBPJt3CgtcH9ES8oAydwlQQ/2011-6-6%203-06-49.png?psid=1

http://uiyqfw.bay.livefilestore.com/y1pHljFhjvjyHTvKi9c2KzvHkgaTNy1PTDbzeDiylCh7b76PkzoseOyNGsUreP4ylAbBDBZDPdFbXpMsaiJgqQ1wdbibv5u5HrJ/2011-6-6%203-08-59.png?psid=1

　　
　　源码下载：
　　begin14
　　end14
　　数据库下载
　　参考资源：
　　1、SQL Server Analysis Services 官方教程
　　（http://technet.microsoft.com/zh-cn/library/ms170208.aspx）
　　
邀月注：本文版权由邀月和CSDN共同所有，转载请注明出处。
助人等于自助! 3w@live.cn