THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SSAS » mdx   (RSS)
Showing page 1 of 2 (12 total posts)
  • Power Query now connects to Analysis Services #ssas #mdx #dax

    The last update of Power Query finally supports Analysis Services Multidimensional and Tabular. I waited this version for a very long time, but now it's finally here! Chris Webb already wrote an interesting blog post with several useful link and informations.  You can connect to both Multidimensional and ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 26, 2014
  • Power Query support for Analysis Services (MDX)

    Today at TechEd Europe 2014 Miguel Llopis made the first public show of Power Query support for Analysis Services. This is still not available, but it should be released soon (hopefully it will be our Christmas gift!). Here is a list of features shown: It should be able to query both Multidimensional and Tabular Generates query in MDX (no ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 28, 2014
  • MDX Studio refresh

    If you work with MDX, using MDX Studio is a must, but it has not been updated for years. But community is great and Ihor Bobak has been able to apply two fixes: performance counters work with named instance and there is a single version regardless of the client libraries, so you have only one executable working with all available versions of ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 11, 2014
  • Learn more about MDX every day

    I started learning MDX in 1999 and after so many years of using it and teaching it to other people, I still discover something new every day. Not only because I use it in strange ways (well, this doesn’t happen every day, at least!) but because there are other interesting information to read. Jeffrey Wang just published another interesting blog ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 16, 2011
  • The Many-to-Many Revolution 2.0 #ssas #mdx #dax #m2m

    In September 2006 I had announced in this blog the release of the first version of The Many-to-Many Revolution, a whitepaper that describes how to leverage the many-to-many dimension relationships feature that had being available since Analysis Services 2005. The paper contains many generic patterns that can be applied in many common data ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 9, 2011
  • #MDX Cookbook : a new must read for #SSAS developers

    There are not so many books about MDX and it’s strange considering that it is a very sophisticated languages that requires years for learning (I’m not kidding). I started learning MDX in 1999 and after so many years, I still have to learn something. I’ve been part of the technical reviewers of the new book from Tomislav Piasevoli, MDX with ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 25, 2011
  • Vote a bug and a missing feature in #powerpivot #denali #ctp3 on #connect

    If you have 30 seconds available, please vote the following items on Connect: https://connect.microsoft.com/SQLServer/feedback/details/679618/import-attribute-key-from-ssas-in-powerpivot When you import data coming from an Analysis Services cube in PowerPivot, you cannot import the attribute key value. Only the attribute name is included in the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 19, 2011
  • The Microsoft BI Roadmap: BISM, UDM and Beyond

    Microsoft recently announced a new roadmap for its BI architecture. The next version of SQL Server, codenamed “Denali”, is going to introduce a new semantic model named BISM (Business Intelligence Semantic Model). Analysis Services will host it and it will be queryable through MDX and DAX. DAX has been introduced in PowerPivot as an expression ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 15, 2010
  • PASS Workshop “Creating a BI solution from A to Z” - Interview

    If you’re still unsure if the workshop I’ll deliver at PASS Summit the next November - “Creating a BI solution from A to Z” - is a good choice for you or not, you can get some more details reading the brief interview here: PASS Summit Post-Con Preview - Davide Mauri Where you’ll find answers to the following questions: Is there an audience ...
    Posted to Davide Mauri (Weblog) by manowar on September 16, 2010
  • Reporting Services, MDX and the (unwanted) cascading parameters

    Reporting Services can be used in conjunction with Analysis Services, creating powerful reporting solution that can satisfy almost  any customer needs for “standard” reporting. For “standard” I mean solutions that has not be created using Excel and a Cube to give the user complete freedom (and responsibility) over data. In one of our current ...
    Posted to Davide Mauri (Weblog) by manowar on August 10, 2010
1 2 Next >
Privacy Statement