Expert Cube Development with Microsoft SQL Server 2008 Analysis Services(1)
2013-05-24 15:40 很大很老实 阅读(265) 评论(0) 编辑 收藏 举报本书构建在sql 2008基础上。
本书主要包括以下内容:
第一章,展示如何建立一个数据集市,作为分析服务的数据源。
第二章,介绍如何在bi开发环境里简单的建立维库和cube,就是:dimensions and cubes.
第三章:discusses more complex dimension design problems such as slowly changing dimensions and ragged hierarchies.
slowly changing dimensions:渐变维度;见:http://msdn.microsoft.com/zh-cn/library/ms141715.aspx;
ragged hierarchies:不规则层次结构.见:http://msdn.microsoft.com/zh-cn/library/ms365406.aspx
第四章:主要是学习度量和度量组(Measures and Measure Groups),如何控制度量的聚集,以及纬度和度量组的关联。
第五章:钻取(drillthrough),事实维度(fact dimensions)和多对多关系。
第六章:shows how to add calculations to a cube, and gives some examples of how to implement common calculations in MDX
参见 http://technet.microsoft.com/en-us/magazine/ee677579.aspx
第七章:deals with the various ways we can implement currency conversion in a cube.
第八章:性能优化,包括如何设计聚集和分区,以及如何写高效的mdx。
第九章:不同途径实现安全策略,包括cell的安全,维度安全,以及动态安全。
第十章:looks at some common issues we'll face when a cube is in production,
including how to deploy changes, and how to automate partition management
and processing.
第十一章:discusses how we can monitor query performance, processing
performance and usage once the cube has gone into production.