SQL Server 2008中SQL应用系列及BI笔记系列--目录索引
导读:本文介绍如何使用从Analysis Services检索数据
。
本文将包括以下内容:
■1、创建透视表(perspective)并通过透视表访问Cube
■2、创建MDX查询
■3、从Analysis Services的数据创建Excel 2007/2010 数据透视表(PivotTable)
■4、使用Excel 2007透视表执行Action,察看KPIs,钻取明细。
■5、从Analysis Services的数据创建SQL Server Reporting
Services报表
本文末尾提供两个项目源码:AdventureWorks_BI_Begin7和AdventureWorks_BI_End7,顾名思义,开始和完成。另外,包括数据库文件SSAS2008SBS_Data,请读者自行修改数据源ds的连接串。
一、创建透视表
二、创建MDX查询
三、使用Excel 2010访问Analysis
Services
四、创建Reporting
Services报表
源码下载:
begin7
end7
数据库下载
参考资源:
1、SQL Server Analysis Services 官方教程
(http://technet.microsoft.com/zh-cn/library/ms170208.aspx
)
分享到:
相关推荐
Microsoft SQL Server 2008 Analysis Services Step by Step 随书光盘
Teach yourself to use SQL Server 2008 Analysis Services for business intelligence—one step at a time. You'll start by building your understanding of the business intelligence platform enabled by SQL ...
Microsoft SQL Server 2008 Analysis Services Step by Step
《Microsoft SQL Server 2008 Analysis Services Step by Step》随书数据库,由邀月(3w@live.cn)整理上传,本数据库只限学习、研究之用,不得用于商业用途,否则后果自负。
Microsoft-SQL Server 2008 Reporting Services Step by Step(2009).pdf, 学习2008 报表服务的好书
英文版一步一步学习sql 2008 报表服务
Microsoft SQL Server 2008 Reporting Services Step By Step.part4
Microsoft SQL Server 2008 Reporting Services Step By Step.part1
Microsoft SQL Server 2008 Reporting Services Step By Step.part2
Microsoft SQL Server 2012 Analysis Services 高级教程 pdf
Provides information on the fundamentals of Microsoft SQL Server 2005 Analysis Services. Teach yourself the fundamentals of SQL Server Analysis Services—one step at a time. With this practical, ...
SQL Server 2005 Analysis Services Step by Step
Microsoft-SQL Server 2008 Reporting Services Step by Step(2009) 随书光盘 案例数据库文件及补充阅读
Microsoft SQL Server 2008 Analysis Services Unleashed分析服务器很深的技术类书籍
Provides information on the fundamentals of Microsoft SQL Server 2005 Analysis Services. Teach yourself the fundamentals of SQL Server Analysis Services—one step at a time. With this practical, ...
Provides information on the fundamentals of Microsoft SQL Server 2005 Analysis Services. Teach yourself the fundamentals of SQL Server Analysis Services—one step at a time. With this practical, ...
This title serves as an authoritative guide to Microsofts new "SQL Server 2012 Analysis Services" BI product and is written by key members of the Microsoft Analysis Services product development team....
SQL Server 2005 Analysis Services Step by Step CD光盘
OLAP 商业智能 数据仓库 学习案例 SQL Server 2008 Analysis Services Business Intelligence Study sample. 欢迎大家学习!