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 » MDX   (RSS)
Showing page 1 of 10 (95 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 TabularGenerates query in MDX (no DAX by ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 28, 2014
  • The state of Multidimensional and Tabular adoption

    SQL Server Analysis Services is a product that does not have its own product code, being sold as part of SQL Server. I think that also Microsoft does not know (and cannot know) the exact number of users. For this reason, it’s also more difficult to analyze the effective usage of the two different model types: Multidimensional and Tabular. Thus, ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 23, 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
  • Expert Cube Development new edition now available! #ssas #multidimensional

    It is available the new edition of the advanced OLAP book, now called “Expert Cube Development with SSAS Multidimensional Models”. The previous edition was titled “Expert Cube Development with Microsoft SQL Server 2008 Analysis Services” and the biggest issue of the book was… the title! In fact, there haven’t been major changes in Multidimensional ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 4, 2014
  • Natural and Unnatural Hierarchies in #powerpivot and #tabular

    Last week I wrote an article about Natural Hierarchies in Power Pivot and Tabular where I show why it is important creating natural hierarchies for performance reasons. I’d like to spend a few words about the reasons why this is so important, so you might read the article in advance before moving forward. I had to investigate on a performance ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 4, 2014
  • Videos about #DAX on Project Botticelli

    More than one year ago, I and Alberto started recording videos for Project Botticelli, and now we have a set of videos about DAX that you can watch online. There are a few videos free, and others are available in the monthly subscription. If you are interested, use this 20% discount code before the end of the December 2013: SQLBI20HOLS2013 The ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 11, 2013
  • SQLLunch on April 23 in London and Cardiff #sqlpass #dax #sqllunch

    On April 23 I will present DAX in Action in London and Cardiff at SQLLunch event.How is it possible I will be in two places at the same time?This will be a remote presentation delivered in two locations, where you can have lunch while watching the session. What is this session about? This is the session description:Tabular is the new SSAS ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 15, 2013
  • MDX Studio download #mdx #ssas

    Short version: the latest available version of MDX Studio can be downloaded from http://www.sqlbi.com/tools/mdx-studio/ Long version: Last week Stacia Misner twitted that the online version of MDX Studio was no longer available. It was hosted on http://mdx.mosha.com. It was a sad news, and it is also not good that nobody is maintaining the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 24, 2012
  • Using SQL to query Multidimensional and Tabular models #dax #sql #mdx #ssas

    Analysis Services answers to query in MDX, in DAX (by now just for Tabular models) and has a limited capability to answer SQL queries. It is not useful for any development or client tool, but I wanted to write a blog post on it in order to be able to retrieve these information I gathered during study of DAX and MDX queries sent to Tabular ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 12, 2012
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement