in

Prologika Forums

Business Intelligence to the Masses
All Tags » Analysis Services » SQL Server 2008 (RSS)

Browse Site by Tags

Showing related tags and posts accross 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) (Weblog) by tlachev on 10-23-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) (Weblog) by tlachev on 09-01-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) (Weblog) by tlachev on 08-15-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) (Weblog) by tlachev on 06-10-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) (Weblog) by tlachev on 11-25-2007
Page 1 of 1 (5 items)
Copyright © 2005 Prologika, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems