none
How to create Power View report based on UDM?

    Question

  • Currently, we can create Power View report based on tabular mode, now I want to create report based on UDM and operational database, it seem this is not supported, is this by design, if so I think it is not reasonable, will it be achieved in the futurn? thanks.

    Alisay

    Saturday, December 17, 2011 11:26 AM

Answers

  • There are no official announcements up to now.

    For sure, Multidimensional will be not supported at RTM. Microsoft didn't announced when it will available. We all hope very soon.

    However, please consider that Power View is not a component you can use embedded in your web application. It is a service in SharePoint so you need SharePoint 2010 Enterprise + SQL Server 2012 BI or Enterprise in order to activate it. It seems expensive just for a single chart...


    Marco Russo http://www.powerpivotworkshop.com http://sqlblog.com/blogs/marco_russo
    Friday, January 13, 2012 5:32 PM
  • Microsoft announced that after RTM and before the next release of SQL Server they will ship an upgrade of Analysis Services 2012 that will make possible to query a Multidimensional model (formerly known as UDM) in DAX. After this upgrade, Power View (which queries a model by using DAX) will be able to query also existing Multidimensional models.

     


    Marco Russo http://www.powerpivotworkshop.com http://sqlblog.com/blogs/marco_russo
    Sunday, December 18, 2011 4:27 AM
  • Hi Alisay,

    Currently, if you want to leverage UDM, you have to upgrade the older mode to BISM using SQL Server Data Tools, it seems that it does not support Operational database as datasource, you have to create the tabular mode or Multidimensional model.

    To current supported two modes: tabular mode or Multidimensional model, You will have two languages, MDX and DAX, to define business logic and to query the model. And you will have two engines, MOLAP and Vertipaq. The great big news is that in BISM it will be possible to combine these components as you need: DAX query over a multidimensional model, MDX Script over a Tabular, and any client able to access to any model. But its first release in Denali will not offer the full flexibility that has been promised.  

    Thanks,
    Challen Fu


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Marked as answer by alisay Wednesday, December 21, 2011 2:49 PM
    Monday, December 19, 2011 8:37 AM

All replies

  • Microsoft announced that after RTM and before the next release of SQL Server they will ship an upgrade of Analysis Services 2012 that will make possible to query a Multidimensional model (formerly known as UDM) in DAX. After this upgrade, Power View (which queries a model by using DAX) will be able to query also existing Multidimensional models.

     


    Marco Russo http://www.powerpivotworkshop.com http://sqlblog.com/blogs/marco_russo
    Sunday, December 18, 2011 4:27 AM
  • Hi Alisay,

    Currently, if you want to leverage UDM, you have to upgrade the older mode to BISM using SQL Server Data Tools, it seems that it does not support Operational database as datasource, you have to create the tabular mode or Multidimensional model.

    To current supported two modes: tabular mode or Multidimensional model, You will have two languages, MDX and DAX, to define business logic and to query the model. And you will have two engines, MOLAP and Vertipaq. The great big news is that in BISM it will be possible to combine these components as you need: DAX query over a multidimensional model, MDX Script over a Tabular, and any client able to access to any model. But its first release in Denali will not offer the full flexibility that has been promised.  

    Thanks,
    Challen Fu


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Marked as answer by alisay Wednesday, December 21, 2011 2:49 PM
    Monday, December 19, 2011 8:37 AM
  • So which is it?  Marco indicates that Multidimensional model support for Power View will not be part of the initial SQL Server 2012 release, while Challen seems to imply it will be part of the release (just not part of "its first release in Denali")?  We are building a solution to sell to our clients, and are contemplating using Google's motion chart, which offers similar moving bubble chart functionality as Power View.  We are only contemplating this because all our cubes are Multidimensional models.  Marco- if you know of an official announcement, can you include a link?
    • Edited by Baloodevil Friday, January 13, 2012 5:29 PM
    Friday, January 13, 2012 5:28 PM
  • There are no official announcements up to now.

    For sure, Multidimensional will be not supported at RTM. Microsoft didn't announced when it will available. We all hope very soon.

    However, please consider that Power View is not a component you can use embedded in your web application. It is a service in SharePoint so you need SharePoint 2010 Enterprise + SQL Server 2012 BI or Enterprise in order to activate it. It seems expensive just for a single chart...


    Marco Russo http://www.powerpivotworkshop.com http://sqlblog.com/blogs/marco_russo
    Friday, January 13, 2012 5:32 PM
  • Yes, that would be expensive chart.  We are building a solution for our clients that includes several hundred reports and a dozen cubes.  When Multidimensional cubes support DAX, I am hopeful Microsoft will allow this functionality without requiring SharePoint.  The SharePoint feature that is required for PowerView is PowerPivot cubes.  So when PowerView can be run on Multidimensional cubes I don't think SharePoint would be a dependency any longer... just to run a new client tool... one that is browser (specifically Silverlight) based.

    Monday, July 16, 2012 6:56 PM