BI(Analysis Service)
文章平均质量分 60
wantfly2006
这个作者很懒,什么都没留下…
展开
-
Configure Analysis Service HTTP connections (Double-Hop)
One of the key features in Microsoft? SQL Server? 2000 Analysis Services is the capability to access data from the Web. The PivotTable? Service (PTS) OLE DB provider uses a special Active Server Pages原创 2006-03-17 21:43:00 · 2273 阅读 · 0 评论 -
Analysis Service 2000 BUGs List
---Analysis Service SP1The hotfixes for Analysis Service Sp1 is included in the following articles290212 INF: List of Bugs Fixed in SQL Server 2000 Service Pack 1 (1 of 2)http://support.microsoft.com/原创 2006-03-08 01:33:00 · 867 阅读 · 0 评论 -
How to view SQL Server Transaction Log
On SQL Server perspective, reading transaction log is not supported and the related code is not released to public. However, it is possible on the code level as some SQL Server feature need it. For ex原创 2006-05-10 00:16:00 · 2411 阅读 · 0 评论 -
Query Performance regarding DISTINCT COUNT Measure
Generally, we need to take are when we created DISTINCE COUNT(DC) measure in our cube as this kind of measure will cause performance issue. As to performance issue in Anlaysis Service (2000 & 2005),原创 2006-05-08 23:45:00 · 1147 阅读 · 0 评论 -
How to check the MSOLAP Provider used in connection string
In the Microsoft Analysis Service, when we try to connect to analysis service, we generally will use connection string as below:Provider=MSOLAP.3;Cache Authentication=False;Integrated Security=SSPI;原创 2006-05-10 00:35:00 · 5773 阅读 · 0 评论 -
Troubleshooting Out Of Memory error in Anlaysis Server
This article discusses how to categorize the cause of and troubleshoot the following error in application event log of Analysis Server. For example:Event Type: ErrorEvent Source: MSSQLServer原创 2006-05-17 01:21:00 · 4122 阅读 · 0 评论