Support for multidimensional models
Support for multidimensional models on Microsoft Azure Analysis Services
Currently focusing on remaining features to get us to GA with tabular. Will confirm timelines/availability for MD as soon as available.
IaaS option(Azure Virtual Machine) is available to opt for an MDX cube at Azure CLoud.
it is as simple as on-premises SSAS MDX cube.
Donna Kelly commented
Ron Pitts commented "MDX language was a great component but its only time until the need for MDX will disappear".
The power of time calculations in MDX is enormous, and far exceeds that of DAX. We have created calculation scripts on top of the basic constellations that provide great intelligence in the warehouse. DAX is not going to do that any time soon.
I would add that we've used account intelligence in our work for major UK banks, and that's been a critical factor in system delivery.
Donna Kelly commented
The real issue with Tabular is that I cannot model an Enterprise warehouse with 100 facts and 1000 dimensions in it. It is a giant E-R model with all those problems. Multidimensional manages Dims and Facts and with Perspectives provides a focused approach to modelling. We've built huge data warehouse systems for the National Health Service (NHS) in the UK and they represent tens of millions of pounds of investment. Redwing cannot afford to dismiss this to revert to tables and joins, Redwing Healthcare Analytics depend on multidimensional and this is the one thing holding us back from moving to Azure.
Yuriy (Gizhitsa) Geller commented
Any progress on this?
Hold your horses, they're gonna respond soon everyone. When they posted in 2016, by "soon" they meant 5-10 years.
I suppose everyone has conceded to installing this via infrastructure-as-a-service?
It seems unfortunate that SSAS MD is being neglected, and not included in PaaS offerings. There are lots of features in here that are still missing in tabular (after almost a decade).
MD is an amazing product in Microsoft BI stack. If it is available in Azure Analysis Services, it will make SSAS MD migration a lot easier.
Any update here?
Ashish Arora commented
It would be amazing to see the multidimensional model support in Azure Analysis service. Also, would be good to have a migration assistant to port from Onpremise to Azure seamlessly.
Any thoughts if this is coming at all? I have a client waiting for this.
As long as Azure SSAS Tabular is not suitable for Europe, we need another option (in larger projects). Combined with the strategy of Azure AD as security admin, there must be a better option. Any suggestions?
Mehmet Bakkaloglu commented
Any update on this?
How is the status. Customers are asking about MDX support in Azure PaaS!
Ron Pitts commented
MDX language was a great component but its only time until the need for MDX will disappear, now that calculated groups exist in SQL 2019 this is another nail on the head for MDX.
I basically haven't touched MDX for some time, its mainly DAX now, understand certain complex measures arent possible in DAX but I havent really hit those in my roles.
This is mainly a pipe dream but Microsoft need to update the Pivot table in Excel to send across DAX instead of MDX against tabular models !
Come on Microsoft gives us some updates ! You can even make more profit. Instead of one Azure Analysis Instance customers need to buy two. One in tabular mode and one in dimensional mode.
What are you waiting ?
On another note, mine is the 700th vote! This idea reminds me of the uservoice idea for allowing "visual studio" developer tools to run as x64 processes (devenv.exe and related ones like xdesproc, PreviewProcessingService, etc).
That uservoice idea, like this one, had the highest number of votes in the community but it still got killed. As-of now we still no not have any x64 developer tools despite the fact that these are the kinds of processes which would benefit greatly from large amounts of addressable memory.
I agree with others that it is taking way too long to get communication on this. It took five years to build SSAS 2005, and apparently its going to involve an extremely long communication lapse (another five years?) before Microsoft tells us that it doesn't have any future plans for SSAS MD.
It's interesting to me that the Power BI product team wants to "ship constantly" and they want to have an "amazing connection to the community" where they can react quickly and deliver new features in response to community feedback. But it's clear that certain efforts (like this one) are larger and more ambitious, and cannot be delivered in small increments. But if Microsoft WON'T DO THEM (despite lots of community votes), then at some point they have to STOP saying that they are responsive to community feedback.
I think that it is more accurate to say that Microsoft is very responsive to the easier requests and put blinders on to avoid dealing with the harder requests.
In any case, it doesn't seem like it is too much to ask for better communication about the future direction of SSAS MD. I suspect that Microsoft won't move "MD" to Azure because you don't want the playing field to be level (giving MD another shot at competing with "tabular" modeling). This ensures that most customers migrate to "tabular", even in cases where the technology isn't a very good fit.
Agreed, update really would be helpful, especially considering mass solution migrations
to tabular space (wide market indicators, activity/discussions on TechNet/MSDN community),
although I don't mind having some extra paid workload in case if they decide
to bring MD back to life (thus migrating Tab back to MD), the only problem from global
perspective it's a lot of activity without much of efficiency - so quite bad practice.
P.S. It still says "Under Review", if by any miracle it goes into "Planned" status - then it might take another year or two till "Started", then at least 6 months++ till "Preview" and then another 6M+ for "GA/Release". Just sad and pathetic :\ RIP MD.
Dan Wakefield commented
Still required please - An update would be really helpful, difficult to plan next steps without knowing where this is heading.
:) by the time this feature is released, I am almost certain that most of the client's world have rebuilt their solution using Tabular. Analysis services blog has been moved from a standalone to Power BI blog as a sub-section. I suspect most of the people who were working or associated with Analysis Services Multidimensional are spending almost all of their time on Tabular version. With these suspicions in my mind I have a feeling that this feature will not be released any time soon.