Contents at a Glance Introduction....................................................................................................1 Part 1: Introduction to Analysis Services 1 Introduction to OLAP and Its Role in Business Intelligence.........................7 2 Multidimensional Space...............................................................................17 3 Client/Server Architecture and Multidimensional Databases: An Overview27 Part 2: Creating Multidimensional Models 4 Conceptual Data Model................................................................................37 5 Dimensions in the Conceptual Model.........................................................43 6 Cubes and Multidimensional Analysis.........................................................63 7 Measures and Multidimensional Analysis....................................................75 8 Advanced Modeling......................................................................................91 9 Multidimensional Models and Business Intelligence Development Studio...................................................................................109 Part 3 Using MDX To Analyze Data 10 MDX Concepts............................................................................................139 11 Advanced MDX...........................................................................................161 12 Cube-Based MDX Calculations...................................................................189 13 Dimension-Based MDX Calculations.........................................................221 14 Extending MDX with Stored Procedures....................................................237 15 Key Performance Indicators, Actions, and the DRILLTHROUGH Statement.......................................................................261 16 Writing Data into Analysis Services...........................................................291 Part 4 Creating a Data Warehouse 17 Loading Data from a Relational Database..................................................307 18 DSVs and Object Bindings..........................................................................317 19 Multidimensional Models and Relational Database Schemas...................329Part 5 Bringing Data into Analysis Services 20 The Physical Data Model............................................................................345 21 Dimension and Partition Processing..........................................................377 22 Using SQL Server Integration Services to Load Data.................................407 23 Aggregation Design and Usage-Based Optimization..................................417 24 Proactive Caching and Real-Time Updates................................................435 25 Building Scalable Analysis Services Applications.......................................451 Part 6 Analysis Server Architecture 26 Server Architecture and Command Execution...........................................477 27 Memory Management................................................................................503 28 Thread Management...................................................................................521 29 Architecture of Query Execution—Calculating MDX Expressions............527 30 Architecture of Query Execution—Retrieving Data from Storage.............553 Part 7 Accessing Data in Analysis Services 31 Client/Server Architecture and Data Access...............................................569 32 XML for Analysis........................................................................................579 33 ADOMD.NET...............................................................................................599 34 Analysis Management Objects....................................................................669 Part 8 Security 35 Security Model for Analysis Services..........................................................713 36 Securing Dimension Data...........................................................................731 37 Securing Cell Values....................................................................................751 Part 9 Management 38 Using Trace to Monitor and Audit Analysis Services.................................763 39 Backup and Restore Operations..................................................................787 40 Deployment Strategies................................................................................805 41 Resource Monitoring...................................................................................815 Index...........................................................................................................823
剩余888页未读,继续阅读
- 粉丝: 10
- 资源: 7
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- stc12c5a60s2 例程
- Android通过全局变量传递数据
- c++校园超市商品信息管理系统课程设计说明书(含源代码) (2).pdf
- 建筑供配电系统相关课件.pptx
- 企业管理规章制度及管理模式.doc
- vb打开摄像头.doc
- 云计算-可信计算中认证协议改进方案.pdf
- [详细完整版]单片机编程4.ppt
- c语言常用算法.pdf
- c++经典程序代码大全.pdf
- 单片机数字时钟资料.doc
- 11项目管理前沿1.0.pptx
- 基于ssm的“魅力”繁峙宣传网站的设计与实现论文.doc
- 智慧交通综合解决方案.pptx
- 建筑防潮设计-PowerPointPresentati.pptx
- SPC统计过程控制程序.pptx
评论5