Browse Site by Tags

Showing related tags and posts accross the entire site.

Microsoft SQL Server 2008 Feature Pack RC0, June 2008

Today, Microsoft released an updated feature pack for SQL Server 2008 RC0. Among other things, it includes: A web downloadable installer for Report Builder 2.0 which is not included anymore with the SQL Server 2008 setup An updated version of the RS add-in for SharePoint Analysis Services 10.0 OLE DB...

Posted to Prologika (Teo Lachev's Weblog) (Weblog) by tlachev on 06-10-2008
Intelligencia Query

Chris Webb, a fellow MVP and MDX guru, who's blog is a must-read for all SSAS junkies, was kind enough to let me take a look at the Intelligencia Query product he's been working on for a while with Andrew Wiles. Chris announced the product back in April which is now selling as a commercial offering...

Posted to Prologika (Teo Lachev's Weblog) (Weblog) by tlachev on 05-14-2008
SSAS HTTP Connectivity and SharePoint

Scenario You won't enable SSAS HTTP connectivity via a SharePoint site. Issue You followed the instructions in the Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows Server 2003 whitepaper but you get " Failed to start monitoring directory changes" error when...

Posted to Prologika (Teo Lachev's Weblog) (Weblog) by tlachev on 05-12-2008
Applied Microsoft Analysis Services 2005 Goes E-Book

I happy to announce my book "Applied Microsoft Analysis Services 2005" is now available as an Adobe PDF e-book. The first retailer that Google Alerts reported to sell it is Diesel Ebooks . It should soon pop up on all popular ebook retailer sites, such as ebooks.com. The suggested retail price...

Posted to Prologika (Teo Lachev's Weblog) (Weblog) by tlachev on 03-27-2008
Last Non Empty Affairs

Enterprise Edition of Analysis Services 2005 and 2008 supports semi-additive functions, such as LastNonEmpty, LastChild, and so on, to facilitate working with semi-additive measures, such as account balances and inventory snapshots. For example, the screenshot below shows LastNonEmtpy in action. To demonstrate...

Posted to Prologika (Teo Lachev's Weblog) (Weblog) by tlachev on 02-06-2008
Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques Whitepaper Available

The Microsoft CAT team has released a new whitepaper Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques. "Many-to-many dimension relationships in SQL Server 2005 Analysis Services (SSAS) enable you to easily model complex source schemas and provide great analytical...

Posted to Prologika (Teo Lachev's Weblog) (Weblog) by tlachev on 12-21-2007
Performance Improvements for MDX in AS 2008

Here is a useful page from the SQL Server 2008 BOL that summarizes the SSAS performance improvements in Katmai pretty well. It also shows which functions are optimized. For example, the Lag function wasn't optimized in 2005 but now is.

Posted to Prologika (Teo Lachev's Weblog) (Weblog) by tlachev on 11-25-2007
NEB Revenge in Katmai

An advanced SSAS performance-related feature is Non Empty Behavior (NEB) which has been discussed in many places including this Mosha's blog . The issue with NEB in SSSAS 2005 is that you can very easily get it wrong. The server will trust you (this could be an optimistic assumption) and accept a...

Posted to Prologika (Teo Lachev's Weblog) (Weblog) by tlachev on 10-09-2007
Protect UDM with Dimension Data Security Reloaded

SQL Server Magazine published the second part of my Protect UDM with Dimension Data Security article in the October issue of the magazine. In this article, I explain how to use MDX expressions to implement dynamic dimension security. I discuss two practical approaches for meeting advanced requirements...

Posted to Prologika (Teo Lachev's Weblog) (Weblog) by tlachev on 09-21-2007
Scale-Out Querying with Analysis Services Using SAN Snapshots

If your organization can afford SAN, here is another best practices article by Carl Rabeler from the SSAS team. The Scale-Out Querying with Analysis Services Using SAN Snapshots article "describes the use of virtual copy SAN snapshots in a load-balanced scalable querying environment for Microsoft...

Posted to Prologika (Teo Lachev's Weblog) (Weblog) by tlachev on 09-12-2007

Page 1 of 6 (54 items) 1 2 3 4 5 Next > ... Last »