Topic: MDX
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. Read more
PASS BA Conference 2013 keynote coverage tomorrow #passbac #sqlpass
The PASS Business Analytics Conference starts today in Chicago. In the next two days, there will be two keynotes . The most famous Steven Levitt, author of Freakonomics, will be on stage on Friday, and tomorrow (Thursday) we will see Kamal Hathi and Amir Read more
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 Read more
TechEd North America 2012 – Day 1 #msTechEd
Yesterday I and Alberto delivered the PreCon day about BISM Tabular in Analysis Services 2012. We received very good feedback and now I am looking forward to meet people that read our blogs and our books! Ping me on Twitter at @marcorus if you want to Read more
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 Read more
Use parameters in your #DAX queries
The DAX query syntax allows you to insert a parameter by using the @ symbol. EVALUATE CALCULATETABLE ( ‘Product Subcategory’ , ‘Product Category’ [Product Category Name] = @Category ) Depending on the client and on the driver you are using to execute Read more
Execute DAX queries through OLE DB and ADOMD.NET
If you want to execute a DAX query from your code to a Tabular model, you might think that an OLE DB connection should be the right way to get your data. It works, but if you your code is… Read more
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 Read more
Vote desired sessions at #SQLBits 10
Just a breaking news: you can vote the sessions you’d like to attend at the next SQLbits in London! I already did my job and I have to say that it’s very hard to use your 10 sesssions – there are too many sessions that I’d like to watch! Read more
Publish Your Data on Windows Azure MarketPlace
If you missed this, it is finally possible to publish your data on Windows Azure Marketplace . The name DataMarket is no longer present here also because the marketplace also include applications and not only data, but the news introduced by the last Read more