1
Vote

Add Support for Multi-Dimensional servers

description

When connecting to an Analysis Services server we should check that the server mode. If it is a multi-dimensional server running 2012 SP1 CU4 or later it will respond to requests for tabular metadata so Dax Studio should support connecting to it.

comments

gbrueckl wrote Dec 10 at 8:48 AM

Not necessarily as you may also want to run DAX against classical multidimensional models

dgosbell wrote Dec 10 at 11:01 AM

Yes, I might re-word this feature. At the moment Dax Studio does not support running against a Multi-dim server. The reason is that for a multi-dim server we need to add a CUBE= parameter to the connection string in order to run the DISCOVER_CSDL_METADATA command to populate the tabular metadata. I've started working on adding support for detecting and handling multi-dim servers seamlessly. So the user experience will not change, but behind the scenes for a multi-dim model the cube/perspective dropdown will actually trigger a re-connection.

dgosbell wrote Dec 10 at 11:05 AM

Actually I've decided to re-word this issue to make it about supporting multi-dim :)

bda75 wrote Dec 10 at 11:18 AM

?? Unsupported, but seems to work nevertheless. I have successfully used DAX studio v 2.0.0.15 today to do just that. I provided the address of our SSAS multi-dim server (SLQ server 12). The Database dropdown field was then populated with the list of available cubes. I selected one and could also select the perspective with the drop down button above the field list. I then wrote a simple query and loaded it to a linked table in Excel. I found these two blog post useful:
DAXMD and DefaultMembers
Querying Attributes and Measures in DAX Multidimensional

dgosbell wrote Dec 10 at 8:38 PM

@bda75 - When you say SQL 12 do you mean SQL 2012 (v11) or SQL 2014 (v12)? The SQL 2012 Multi-dim instances I've tested against (SP1 & SP2) populate the database and cube dropdowns, but then throws errors trying to populate the tables and columns when trying to connect to Adventure Works. So if you are connecting to SQL 2014 maybe MS have improved the DAX support there.

I do know how to fix the SQL 2012 issues, it just was not high on my priority list for the v2 launch :)

bda75 wrote Dec 11 at 8:29 AM

I meant SQL Server 2012 Service Pack 2 (11.0.5058.0). The only error that I got was the "composite key" one described in the blogs post linked in my previous message, which I could solve by following the recommendations. So there might be less to fix than you anticipate ! Anyway, thanks for the great job so far.

dgosbell wrote Dec 11 at 12:18 PM

@bda75 - At the moment Dax Studio can only connect to multi-dim database that have one physical cube. Full multi-dim support is still going to require the additional code I've alluded to above.