随笔分类 -  BI

shit reporting service!!!
摘要：The report parameter 'param1' is read-only and cannot be modified. (rsReadOnlyReportParameter) Search SQL Server Reporting Services Forum Search All SQL Server Forums Search All MSDN Forums Ask a questionFriday, April 06, 2007 2:52 AManbanb0Recent Achievements100First Forums Replyanb's . 阅读全文
posted @ 2011-09-26 21:19 大斌锅 阅读(325) 评论(0) 推荐(0)
SSAS SESSION
摘要：In mylast post I listed changes that are expected in SSAS 2008 next CTP 4. But it looks like none of the changes made into July CTP. They probably were postponed last minute. Evennew Microsoftdocumentation(read Chris Web blog)lists some of the featuresas present. For example block computation is lis 阅读全文
posted @ 2011-02-18 13:40 大斌锅 阅读(508) 评论(0) 推荐(0)
Clear Analysis Services (SSAS) database cache
摘要：Example of command to clear cache for database:<ClearCache xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"><Object><DatabaseID>Adventure Works DW</DatabaseID>... 阅读全文
posted @ 2010-11-12 12:00 大斌锅 阅读(316) 评论(1) 推荐(0)
create an e-mail alert when some criteria has been met after processing Analysis Service cube
摘要：Analysis Services does not have "alert" functionality. SSAS cannot send e-mail, so your best bet is to delegate that functionality somewhere else. My suggestion was to use SQL Server. Here are sample ... 阅读全文
posted @ 2010-07-14 11:41 大斌锅 阅读(402) 评论(0) 推荐(0)
SQL Server Analysis Services Port (SQL 2005 / 2008)
摘要：SQL Server Analysis Services Port (SQL 2005 / 2008) karang 5 Sep 2009 4:33 AM Default Port:2383You can change default Port for AS in msmdsrv.ini file of the Instance.Port Used by SQL Server Browser Se... 阅读全文
posted @ 2010-06-22 16:15 大斌锅 阅读(407) 评论(0) 推荐(0)
Implementing Office Web Component Pivot Tables with ASP.NET
摘要：Implementing Office Web Component Pivot Tables with ASP.NETby Eric CharranIntroductionA short time after Office 2000 debuted, many developers began to recognize the power of Office Web components. Dur... 阅读全文
posted @ 2010-03-12 13:10 大斌锅 阅读(2077) 评论(0) 推荐(0)
MDX FAQ
摘要：http://www.ssas-info.com/analysis-services-faq/27-mdx 阅读全文
posted @ 2010-02-04 18:33 大斌锅 阅读(189) 评论(0) 推荐(0)
MDX-How can I get attribute key with MDX
摘要：MDX-How can I get attribute key with MDX Written by Ramunas Balukonis Monday, 11 June 2007 06:38 Q: How can I get attribute key with MDXA: To do so, use Member_Key function:WITHMEMBER Measures.Produc... 阅读全文
posted @ 2010-02-04 18:24 大斌锅 阅读(293) 评论(0) 推荐(0)
Currency Conversion in Analysis Services 2005
摘要：Currency Conversion in Analysis Services 2005 I recently investigated currency conversion in SSAS for a customer. I found that there is not much on the web in the way of examples. Here is an attempt t... 阅读全文
posted @ 2010-01-25 17:27 大斌锅 阅读(488) 评论(0) 推荐(0)
Measure expressions: how performant are they?
摘要：They ship parcels domestically, internationally (and between dimensions). We are only concerned with the operations of their trucks. The trucks either· Collect parcels from depots to deliver to c... 阅读全文
posted @ 2010-01-25 11:40 大斌锅 阅读(286) 评论(0) 推荐(0)
如何保护Analysis Services的安全
摘要：Analysis Services可以用多维数据结构和多维查询语言MDX快速访问数据。Analysis Services提供了根据数据仓库表格设计、创建和管理多维数据集的功能，是微软业务智能战略的基础。 　　测试用户对 Analysis Services 数据库的访问权限　　1. 在对象资源管理器中，展开多维数据集，右键单击 Adventure Works Cube，然后单击浏览。　　2. 在 A... 阅读全文
posted @ 2010-01-19 13:18 大斌锅 阅读(178) 评论(0) 推荐(0)
asdatabase to xmla
摘要：To create an XMLA script from SSAS solution project you have to buld solution (generate .asdatabase file), then run deployment wizard with option specifying that you want to generate XMLA script. Step... 阅读全文
posted @ 2010-01-15 09:29 大斌锅 阅读(291) 评论(0) 推荐(0)
BI CUBE 性能调优
摘要：SSAS 2005http://files.cnblogs.com/yanbinboy/SSAS2005PerfGuide.rar SSAS 2008http://files.cnblogs.com/yanbinboy/SSASPerfGuide2008.rar 阅读全文
posted @ 2010-01-14 11:47 大斌锅 阅读(240) 评论(0) 推荐(0)
SSAS Partition Slicing
摘要：Summary: SSAS uses partitions to contain cube data. Small cubes might use only one, but for non trivial cubes, cube designers will create partitions based on ease of managing data and to split groups ... 阅读全文
posted @ 2010-01-13 17:00 大斌锅 阅读(493) 评论(0) 推荐(0)
SQL Server BI Step by Step SSIS 7 (End) --- 事务，错误输出，事件处理，日志记录
摘要：SQL Server BI Step by Step SSIS 7 (End) --- 事务，错误输出，事件处理，日志记录 和其它程序一样，SSIS包同样需要健壮，稳定的运行，这样的程序才有可靠性和可伸缩性。SSIS提供了如下方面的支持: 1.事务: 可以对一个程序包设置成一个或者多个事务，甚至可以对两个程序包设置成一个事务。为了保证数据的一致性，你还可以DTC事务或者... 阅读全文
posted @ 2009-09-21 09:35 大斌锅 阅读(488) 评论(0) 推荐(1)
MDX 1
摘要：with member [measures].[aaa] as[Measures].[Dollar Sales] - ([Measures].[Dollar Sales], ParallelPeriod([Time].[YQMD].[Year], 1, [Time].[YQMD].currentmember))member [measures].[Previous Dollar Sales] as... 阅读全文
posted @ 2009-05-22 09:37 大斌锅 阅读(253) 评论(0) 推荐(0)
图解SSIS批量导入Excel文件（转）
摘要：将一个目录下(可以包括子目录)结构一样的excel文件批量导入sql2005,可以用ssis来定制任务.下面用大量图片完全说明整个过程.1、建立测试excel文件,假设有a b c d四个字段,保存在f:\excel目录下并复制很多个一样的文件2、打开Microsoft Visual Studio 2005或者随sql2005安装的SQL Server Business Intelligence ... 阅读全文
posted @ 2009-05-21 12:19 大斌锅 阅读(1355) 评论(2) 推荐(1)