Information, tips, news and announcements about SQL Server Analysis Services and PowerPivot directly from the product team.
On November 29, 2012 we released the “Power View for Multidimensional Models -- Preview.” We are excited to announce SQL Server 2012 Service Pack 1 Cumulative Update 4, released today, provides the ability for customers to create Power View reports against their existing multidimensional models (a.k.a. cubes). SQL Server 2012 Service Pack 1 Cumulative Update 4 contains a few additional enhancements to the “Power View for Multidimensional Models -- Preview” based on customer feedback. This functionality helps customers maximize their existing BI investments by enabling their use with the latest BI end-user tools and adds greater modeling flexibility to the BI Semantic Model. Customers need to upgrade their Analysis Services instance and the Reporting Services add-in for Microsoft SharePoint Server (2010 or 2013) with this Cumulative Update to create Power View reports against their existing cubes.
Microsoft introduced an interactive data exploration, visualization and presentation experience called Power View with SQL Server 2012. Power View reports are presentation-ready at all times because they are always connected to your data. Users can quickly create a variety of visualizations, from tables and matrices to bubble charts and sets of small multiple charts. Power View operates on a BI Semantic Model that resides in Analysis Services databases or PowerPivot workbooks.
With the SQL Server 2012 SP1 CU 4, Power View can consume data from multidimensional models. Now Power View users can connect to both the tabular and multidimensional formats of the BI Semantic Model. This is achieved through native support for Data Analysis Expressions (DAX) in Analysis Services multidimensional models, ensuring optimal performance and functionality. SQL Server 2012 SP1 CU4 contains a few additional enhancements to the “Power View for Multidimensional Models – Preview” released in November 2012. Stay tuned for a deeper dive on the functionality in a future post!
Frequently Asked Questions
1. Do I need to upgrade SSAS & SSRS in SharePoint mode?
Answer:Yes, you need to upgrade your SSAS & SSRS installed in SharePoint mode.
2. Can I upgrade from existing SQL Server 2012 installation?
Answer: Yes, you can upgrade from an existing SQL Server 2012 installation.
3. In which editions is Power View support for multidimensional mode enabled?
Answer: Enterprise and Business Intelligence editions.
4. Can I send DAX queries to multidimensional models?
Answer: Yes, you can send DAX queries to multi-dimensional models.
5. Will Power View in Excel (on-prem or in the cloud) be able to connect to multi-dimensional models (cubes)?
Answer: No, this update is only supported on stand alone SharePoint (2010 and 2013) mode.
6. When will Power View in Excel to connect to Multidimensional models?
Answer:Enabling this scenario is a top priority for the team but we do not have any updates on the roadmap or timeframe to share at this time.
This is great, however, installed the updates and still cannot access MDMs using SharePoint 2013. All instances, including those used for SharePoint 2013 and its features, updated with CU4. PowerView in SP2013 reports: There were errors found while validating the page: The database is not using in memory storage engine when creating BISM connection for use with PowerView. Are we missing something for SP2013?
Fantastic! I've been looking forward to this feature for a while. I no longer need to develop a tabular equivalent of a multidimensional cube in order for PowerView in SharePoint to work!
Great news! This will appease many MSBI customers with existing solutions. It also significantly helps in the MD vs. Tabular debates!
Is Power View in SharePoint 2010 Enterprise Edition supported along with SharePoint 2013?
Environment: SP2013 - SQL2012 SP1
Installation takes approximately 30 minutes.
Confirmed Instances requiring update:
• SSAS Instance(s)
• SSRS installed in SharePoint mode
• Updating SSAS instance alone is insufficient since Power View is part of Reporting Services
1. Databases with multiples cubes will not open,
2. Named Sets do not appear in Field List,
3. MDX calculated measures work error free (including highly complex scoped statements)
4. Hierarchies cannot be dragged to report l- work around is to expand hierarchy and drag each attribute in the hierarchy to the report
5. Cannot select a PERSPECTIVE
SharePoint 2013 data connections
1. Cannot be created through web - work around is to open library in Windows Explorer, copy and paste an existing file, then edit the file.
a. Recommended that we script the BISM data connections for the MDMs as we did for Excel
• Report Builder shows SQL Server Report Builder 11.0.3368.0
• Power View shows SQL Server Reporting Services 11.0.3000.0 when creating a Power View report using a data connection
• Power View shows SQL Server Reporting Services 11.0.3368.0 when editing a Power View report from the Library
"contains a few additional enhancements to the “Power View for Multidimensional Models -- Preview” based on customer feedback".
What enchancements please? can't these anywhere.
I got this error now when I try to open a powerview report!!!
"Sorry, the versions of the Reporting Services SharePoint Add-In and the Reporting Services service application are incompatible or don’t support this functionality. Please check with your server administrator"
but SSRS is installed on the same DEV computer where sharepoint 2010 is and I just deploy the CU4 on it...
what can I do???
Documentation for Power View connectivity to Multidimensional models is now available at msdn.microsoft.com/.../dn198310.aspx. This documentation should help answer most of the comments/questions below. Enclosed below is aggregated response to the comments below.
1. We recommend using RSDS files for connecting to your multidimensional models.
2. If you have more than one cube in your multidimensional database, please specify Cube=<cubename> in your connection string in RSDS file.
3. you can connect to a specific perspective by specifying the perspective name via Cube=<perspectivename>
4. You can select multiple levels in a hierarchy based on your need by selecting the checkbox next to the level.
5. Power View in SharePoint 2010 is supported. Please refer to the diagram in the documentation.
6. The key enhancements since the public CTP are - supporting dynamic format string, language cell property and behavior when default members are set for an attribute.
Please look forward for a blog post on detailed drill down in the coming weeks.
Siva, TK, and all of the Plato team.... FRIGGIN´ WELL DONE!!!!!!!!!!!!!! This is the MSBI we all want to see to beat competition.
This is great. Does Power View support passing of parameters yet with SharePoint web parts?
Love the direction this is going. Would love even more to have a better road map. I've got a SQL 2012 DB, AS (Cubes) & RS stack with SPS 2013 as the front end and it's a good start but needs serious improvements in data vizualisation. Powerview is a plus!
PS - I would really just like to see Dundas made native in SSRS.
Ye very well done!
Also, please add support for things like exporting powerview report to excel etc, renaming matrix / table report columns, cube drillthroughs and usage with performance point (passing parameters etc), last but no the least enabling it in excel so we can query the cube :)
I am a VM with SQL Server 2012 Enterprise Edition and SP 2010
so i thought installing the hotfix will do the job, however when installing the setup, it didn't detect any update required for my instances!
Any idea? am I missing something
I have 10 laks of data in my DataWareHouse....Now I am using Power Pivot in MSExcel 2010 and importing the data in power pivot window through Analysis services..But Somehow..I thought that it is not right to import a huge amount of data into Excel and then do slicing and dicing..What's the advantage of power pivoting?its only for importing data from various sources and do the Intelligent analysis.. What should i do now ? Should I use Power Pivoting Or directly use pivoting by dragging SSAS cubes and dimensions..Power Pivoting is only applicable for Offline analysis...How can I use Power Pivoting By Using cubes and dimensions directly by Analysis Service..
I so exited, but cannot determine which of the CU4 files I should install?
There are a bunch of them...