SQL Server 2008中SQL应用系列--目录索引
导读:本文介绍如何使用回写(Writeback)修改Analysis Services数据
。
本文将包括以下内容:
■
1、创建URL动作(Create a URL action)
■2、创建钻取动作(Create a drillthrough action)
■3、创建报表动作(Create a reporting action)
■4、启用维度回写[回写意味着读写都有缓存,邀月注],添加或修改一个维度成员(Enable dimension writeback and
add or modify dimension members)
■5、启用Cube回写,添加或修改一个度量值(Enable cube writeback and add or modify
measure values)
本文末尾提供两个项目源码:AdventureWorks_BI_Begin6和AdventureWorks_BI_End6,顾名思义,开始和完成。另外,包括数据库文件SSAS2008SBS_Data,请读者自行修改数据源ds的连接串。
四、启用维度回写
OK!部署项目。注意在Dimension Designer 界面,点击"Browser”,并"Reconnection”。
五、启用Cube回写
当你对一个度量组启用回写的时候,包含回写值的分区被创建
OK!部署项目。
源码下载:
begin6
end6
数据库下载
参考资源:
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.part1
Microsoft SQL Server 2008 Reporting Services Step By Step.part4
Microsoft SQL Server 2008 Reporting Services Step By Step.part2
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, ...
Microsoft SQL Server 2012 Analysis Services 高级教程 pdf
Microsoft-SQL Server 2008 Reporting Services Step by Step(2009) 随书光盘 案例数据库文件及补充阅读
SQL Server 2005 Analysis Services Step by Step
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, ...
Microsoft SQL Server 2008 Analysis Services Unleashed分析服务器很深的技术类书籍
SQL Server 2005 Analysis Services Step by Step CD光盘
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....
Expert Cube Development With Microsoft Sql Server 2008 Analysis Services