Browse by Tags

• Articles
• Business Intelligence
• General
• Kilimanjaro
• Reporting Services
• SharePoint
• SQL Server 2008
• Writing

• Dimensionalizing Pivoted Measures

  Issue You have a table with pivoted measures, such as: Use the following statement to create and populate the table: CREATE TABLE pvt ( VendorID int , DateID int , MaturityAmount1 int , MaturityAmount2 int , MaturityAmount3 int , RepricingAmount1 int... Posted Dec 15 2008, 07:43 PM by tlachev with | with no comments Filed under: Reporting Services, Analysis Services, Business Intelligence

• Referencing Parameters in SSRS Calculated Members

  Issue : You author an SSRS report that connects to a cube. You want to create a calculated member that uses a report parameter. For example, the Selector calculated member in the following query returns 1 if a given employee has exceeded 1 million in... Posted Nov 09 2008, 07:09 PM by tlachev with | with no comments Filed under: Reporting Services, Analysis Services

• SSAS WHERE vs. Subselect Puzzle

  I've been involved recently in a quest to optimize an SSAS 2008 long-running query that would return the 12-month history of a KPI. Since the KPI was displayed on a dashboard page alongside other KPIs and charts, it was important to optimize the query... Posted Oct 23 2008, 08:53 AM by tlachev with | with no comments Filed under: Analysis Services, SQL Server 2008

• Memory-based Dimensional Model (MDM) on the Horizon

  As the news arrived today (see Mosha Pasumansky blog , Chris Webb blog , and Marco Russo blog ) , the BI Conference revealed what has been brewing for a while in the Microsoft BI nest. Project Gemini, which one may call Memory-based Dimensional Model... Posted Oct 06 2008, 09:27 PM by tlachev with | with 1 comment(s) Filed under: Analysis Services, Kilimanjaro

• Sorting Dates in a PivotTable Report

  Issue: You use Excel as an OLAP browser connected to an SSAS cube. You've defined the name of the Month attribute in the Date hierarchy in the format MMM-YYYY. While months are sorted in an ascending order in Excel, descending sorting doesn't... Posted Sep 10 2008, 09:06 PM by tlachev with | with no comments Filed under: Analysis Services

• Personalized Cubes

  Scenario: You need to personalize the captions of calculated members or/and KPIs of an SSAS cube. For example, a solution vendor may need to deploy a cube to multiple clients. Instead of maintaining separate cube definitions, the vendor may prefer to... Posted Sep 01 2008, 09:33 PM by tlachev with | with no comments Filed under: Analysis Services, SQL Server 2008

• Nasty SSAS 2008 Bug

  There is a nasty known bug with SSAS 2008, where if a query that requests two measures with Sum and LastNonEmpty aggregate functions side by side and the query uses NON EMPTY (which all OLAP clients use by default), the server forces the measure with... Posted Aug 15 2008, 08:11 AM by tlachev with | with 1 comment(s) Filed under: Analysis Services, SQL Server 2008

• Static Credentials

  A new week comes with new issues... I ran into an interesting issue today with Windows integrated security and SharePoint. I was troubleshooting an issue on a behalf of a Windows user that connects to an SSAS server. To repro the issue, I used the SharePoint... Posted Aug 11 2008, 10:08 AM by tlachev with | with no comments Filed under: Analysis Services, SharePoint

• Yet Another Post About Analysis Services HTTP Connectivity

  With risk to iterate the obvious, here is a lesson learned from the trenches: Scenario : You want to let external users browse an Analysis Services cube over the Internet. Setup : You have followed the steps in the Configuring HTTP Access to SQL Server... Posted Aug 01 2008, 10:30 PM by tlachev with | with 2 comment(s) Filed under: Reporting Services, Analysis Services

• 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... Posted Jun 10 2008, 07:51 AM by tlachev with | with no comments Filed under: Reporting Services, Analysis Services, Business Intelligence, SQL Server 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... Posted May 14 2008, 10:37 PM by tlachev with | with 9 comment(s) Filed under: Reporting Services, Analysis Services, Business Intelligence

• 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... Posted May 12 2008, 07:58 AM by tlachev with | with 1 comment(s) Filed under: Analysis Services

• 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... Posted Mar 27 2008, 08:16 AM by tlachev with | with no comments Filed under: Writing, Analysis Services, Business Intelligence

• 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... Posted Feb 06 2008, 06:51 PM by tlachev with | with no comments Filed under: Analysis Services

• 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... Posted Dec 21 2007, 07:54 PM by tlachev with | with no comments Filed under: Analysis Services