SharePoint 2013 Power View Multidimensional Models SQL 2012 SP1 CU4

Hi All,

This is a post is a compilation of posts from Microsoft The reason I am created the compilation along with providing the link for everyone is the SQL Product Group has been doing an amazing job of pushing the envelope and providing us more & more features in the BI Space for use use with SharePoint 2013 Scorecards and Dashboards.

With this release, multidimensional models support analysis and visualization by using Power View in SharePoint mode. No special configuration of your multidimensional models is necessary. There are however some differences in how multidimensional model objects are displayed in Power View compared to other client tools such as Microsoft Excel and Microsoft Performance Point. This release does not support analysis and visualization of multidimensional models by using Power View in Excel 2013.

SQL Server 2012 Service Pack 1 Cumulative Update 4, released May 31st, 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” that was previously released November 29 2012 and 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.

As everyone knows 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.

Reference:

Understanding Power View for Multidimensional Models

-Ivan

clip_image001 clip_image002 clip_image003 clip_image004 clip_image006 clip_image008


clip_image009

Microsoft MVP and MCC Awards

Wow, Thank you to all of the folks at Microsoft on the team that support us and especially the SharePoint PG & Melissa without whom I would not have made it this far, to all the folks at O’Reilly who made co-authoring Business Intelligence in SharePoint 2013 possible, to all of my friends and fellow MVPs past and present who take their Saturdays off to volunteer and attend the SharePoint Saturday Events around the world, to INETA and all of the Microsoft SharePoint User Groups on the West Coast but especially those in California :), to all of the ISVs like telerik, metalogix, CloudShare, Jetbrains, DevExpress, K2, Axceler, CorasWorks, Surfray & AvePoint and many more who all of us and the events, and to all of my friend and associates that are both supporting and looking for answers in the Microsoft Software Developers Forums

image

The Microsoft Community Contributor badge is given to those who make notable contributions to Microsoft online communities such as TechNet, MSDN and Microsoft Community.

The value of these resources is greatly enhanced by participants who voluntarily contribute their time and energy to improve the online community experience for others.

Each day around the world, Microsoft Community Contributor recipients contribute to Microsoft online technical communities in a range of ways, including providing helpful answers, translating online resources into local languages and serving as moderators.

image

 

Thank you !!!

 

-Ivan

Microsoft is retiring the TechNet Subscription service


Well I guess reposting from email now twice, though most people interested in this information probably already know –Ivan

Microsoft is retiring the TechNet Subscription service.

 

As IT trends and business dynamics have evolved, so has Microsoft’s set of offerings for IT professionals who are looking to learn, evaluate and deploy Microsoft technologies and services. In recent years, we have seen a usage shift from paid to free evaluation experiences and resources. As a result, Microsoft has decided to retire the TechNet Subscriptions service and will discontinue sales on August 31, 2013.

 

Additional Information:
More background on Microsoft’s decision to retire the TechNet Subscription service and the implications for current subscribers is available on the TechNet Subscriptions Retirement FAQ page.

Subscribers with active accounts may continue to access program benefits until their current subscription period concludes.

We are committed to helping customers through this transition phase and will remain focused on providing IT professionals with free access to a broad set of TechNet assets that support the needs of IT professionals around the world.

Improved Free Offerings for IT Professionals Include:

  • TechNet Evaluation Center: Free evaluation software with no feature limits, available for 30-180 days. Includes rich evaluation resources and TechNet Virtual Labs, which enable you to evaluate software without the need to install bits locally.
  • Microsoft Virtual Academy: Free online learning site, with over 200 expert-led technical training courses across more than 15 Microsoft technologies with more added weekly.
  • TechNet Forums: Free online forums where IT professionals can ask technical questions and receive rapid responses from members of the community.

Please note, MSDN Subscriptions provide a paid set of offerings that are also available for those who require access to evaluation software beyond what the above free offerings provide.

Thank you for your understanding as we increase focus on growing and investing in our free offerings to better meet the needs of the IT professional community.

Do not reply to this e-mail. This message was sent to you using an automated system. This e-mail alias is not monitored for replies.

- TechNet Subscription Team

Microsoft respects your privacy. Review our online Privacy Statement.

Microsoft Corporation
One Microsoft Way
Redmond, WA, USA 98052

Microsoft Press Business Intelligence in SharePoint 2013

I just received my copies of Business Intelligence in SharePoint 2013. I will be signing the books and giving them away at the next SharePoint Saturday 2013 in Redmond where I am speaking.

Being an Author and writing a book is very time consuming and can be difficult since you are working with software that is going to change many time’s prior to release and you are typically the first to be writing opn the new features being released.

However, I was lucky enough to work with a few authors (listed below) who are all some of the best folks I have had the pleasure of working with, and I learned a lot about how much my writing needed to improve.

Norm Warren, Mariano Teixeira, Stacia Misner, and Scott Helmers

Our book was listed last week on the Microsoft Press Blog Site

image

Dive into the business intelligence features in SharePoint 2013—and use the right combination of tools to deliver compelling solutions. Take control of business intelligence (BI) with the tools offered by SharePoint 2013 and Microsoft SQL Server® 2012. Led by a group of BI and SharePoint experts, you’ll get step-by-step instructions for understanding how to use these technologies best in specific BI scenarios—whether you’re a SharePoint administrator, SQL Server developer, or business analyst.

Manage the entire BI lifecycle, from determining key performance indicators to building dashboards Use web-based Microsoft Excel® services and publish workbooks on a SharePoint Server. Mash up data from multiple sources and create Data Analysis Expressions (DAX) using PowerPivot
Create data-driven diagrams that provide interactive processes and context with Microsoft Visio® Services

Use dashboards, scorecards, reports, and key performance indicators to monitor and analyze your business
Use SharePoint to view BI reports side by side, no matter which tools were used to produced them

I would also like to thank all of the wonderful people at O’Reilly and Microsoft Press for being there when we needed you….

 

Thank you all !!!

 

-Ivan