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 (92 total posts)
  • 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
  • Analyze #DAX query plan with Profiler

    Jeffrey Wang started the 2012 (or finished the 2011, depending on your time zone) by publishing the first article dedicated to DAX Query plan. While I look forward to reading next articles, it is interesting the explanation of what is the relationship between MDX and DAX in Analysis Services 2012. An MDX query sent to a Tabular model is not ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 1, 2012
  • 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
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement