SQLLunch on April 23 in London and Cardiff #sqlpass #dax #sqllunch

sqlbi — Mon, 15 Apr 2013 08:52:00 GMT

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 modeling experience and DAX is the new language to use to create BI solution with Tabular. How does it compare with MDX and Multidimensional? In this session, which is mostly based on demos, we will build a complex BI solution from scratch, starting from simple analysis and moving through complex scenarios, showing how you will leverage the tremendous speed of DAX to create complex solution on simple data models, focusing on the differences in building the same solution in MDX or DAX.

These free events are organized by the UK SQL Server User Group. If you are interested, you can register using the following links.
London : http://sqlserverfaq.com/events/534/SQLLunch-All-stuff-no-fluff-Marco-Russo.aspx
Cardiff : http://sqlserverfaq.com/events/535/SQLLunch-All-stuff-no-fluff-Marco-Russo.aspx

Using SQL to query Multidimensional and Tabular models #dax #sql #mdx #ssas

sqlbi — Thu, 12 Jan 2012 13:12:00 GMT

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 models.

If you create an OLE DB connection using the MSOLAP driver you can send queries to BISM models according to the following schema:

Multidimensional (aka UDM/OLAP)

Tabular

The SQL support exists mainly for creating local cubes from a Multidimensional model and it is also used by BISM Tabular model editor. The feature is not documented and not supported outside the syntax that is required for supporting local cubes (for example, it is used when you create an Offline cube in Excel).

You can see some examples of SQL syntax used to query an OLAP cube in two blog post of 2005/2006: one from Mat Stephen and the other from Chris Webb. You can use the same syntax also to query a BISM Tabular model. In such a case, you can also add the SQLQueryMode=DataKeys in the connection strings in order to improve performance, because there is a more direct translation into a Vertipaq request balanced by further restrictions in SQL syntax.

I haven’t found a good reason to use such a SQL syntax and the fact that it is not documented and not completely supported means that it is not something that should be used anyway. However, I think it is good to know what is the SQL support existent in Analysis Services (someone might remember some presentation of UDM in early days of SQL 2005 beta) and I’d like to get your feedback about reasons for which this feature should be supported (but before answering, please remember this is a very particular SQL dialect, with syntax like NATURAL JOIN and no support for many standard ANSI constructs).

Search results matching tags 'MDX' and 'Tabular'

SQLLunch on April 23 in London and Cardiff #sqlpass #dax #sqllunch

Using SQL to query Multidimensional and Tabular models #dax #sql #mdx #ssas