Prologika Forums
Making sense of data

Browse Site by Tags

Showing related tags and posts across the entire site.
  • 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 as much possible. Rephrased to Adventure Works...
    Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Thu, Oct 23 2008
    Filed under: Analysis Services, SQL Server 2008
  • 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 change the captions of certain calculated members...
    Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Mon, Sep 1 2008
    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 the SUM function to display empty. Steps to repro...
    Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Fri, Aug 15 2008
    Filed under: Analysis Services, SQL Server 2008
  • 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) by Teo Lachev on Tue, Jun 10 2008
    Filed under: Reporting Services, Analysis Services, Business Intelligence, SQL Server 2008
  • 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) by Teo Lachev on Sun, Nov 25 2007
    Filed under: Analysis Services, SQL Server 2008
Page 1 of 1 (20 items)