How can we improve Microsoft Azure Analysis Services?

Support for multidimensional models

Support for multidimensional models on Microsoft Azure Analysis Services

334 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Wes BrownWes Brown shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    8 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • BillTBillT commented  ·   ·  Flag as inappropriate

        We at Saasabi have an OLAP engine running as a PaaS platform on Azure. It is a parallel in memory OLAP supporting write-back, and the majority of the core functionality of SSAS. It supports MDX, XMLA, OLEDB, Odata and other. It can be deployed in multi tenancy environments or single tenancy. Sophisticated security model, supports multi authentication regimes. It has been in production for over 3 years. Has easy to extend ETL capabilities supporting combinations of API's as well as direct DB calls, extensible framework to integrate into cloud based workflows, ML, Cortana etc.
        All benchmarks against SSAS on complex calcs and functions have shown multiple X performance advantages and more than double that again in terms of price performance.
        We are a strong and committed MS partner and are committed to Azure. The Saasabi platform has been designed for complex planning application requirements. We have a client doing whole of government financial analytics consolidating data over 52 GL's. We have another partner extracting data from thousands of cloud accounting ledgers. If you need an OLAP engine on Azure, that is high performant, dramatically reducing your license costs (compared to VM based solutions) get in touch with Saasabi.

      • stuartstuart commented  ·   ·  Flag as inappropriate

        Agree with Michael & John, multidim is needed to support planning functionality.

      • B BB B commented  ·   ·  Flag as inappropriate

        Guys, waiting for update / news on Multidimensional. Can Tabular & Multidimensional not developed in parallel instead of in tandem. Multidimensional users are being alienated from Azure AS.

      • John HagelinJohn Hagelin commented  ·   ·  Flag as inappropriate

        I agree with Michael, Tabular doesn't offer any support to planning functionality, which is why Multidimensional AS would be a great step for the Azure stack in my opinion.

      • Michael BjelvenmarkMichael Bjelvenmark commented  ·   ·  Flag as inappropriate

        Of cource it's needed. To build an Corporate Performance Managament BI solution that's based on Financial Data Warehouse in Azure is support for multidimensional models needed. For example to get Planning functionality.

      • AFPAFP commented  ·   ·  Flag as inappropriate

        1) ROLAP against Azure DW - we want and need a fast data warehouse for large data sets, and we want our analysis tools to be in near real time, as the data warehouse loads, thus ROLAP against a data warehouse. Azure DW scales, and that is really important to the future of a DW
        2) Multi-dimensional is better than tabular, has more features, is a better development tool
        3) ROLAP reduces/eliminates the need to support large data sets in SSAS
        4) ROLAP eliminates the need for dual data entry into both DW and SSAS

      Feedback and Knowledge Base