Category Archives: 16521

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.


Understanding Power View for Multidimensional Models


clip_image001 clip_image002 clip_image003 clip_image004 clip_image006 clip_image008


PASS Business Analytics Conference 2013 – Return on Investment

margin-left: 0in;
margin-right: 0in;
margin-top: 0in;
{border-top:solid #4f81bd 1.0pt;
border-bottom:solid #4f81bd 1.0pt;
border-left-style: none;
border-left-color: inherit;
border-left-width: medium;
border-right-style: none;
border-right-color: inherit;
border-right-width: medium;


Need help justifying your attendance at the PASS Business Analytics Conference?

I’m looking to…  

How the PASS Business Analytics Conference delivers:

Learn best practices and how to get the most out of Business Analytics

Join top industry and Microsoft experts for over 60 sessions offering exceptional learning guided by real-world solutions, thought leadership, and prescriptive technical guidance to capture the value of business analytics for your organization.  

Upskill to broaden my knowledge and career opportunities

Five comprehensive tracks will cover: Data Analytics and Visualization; Advanced Analytics and Insights; Information Delivery and Collaboration; Big Data Innovations and Integration; Strategy and Architecture.

Develop a deeper understanding of Business Analytics

Deep dive with a track dedicated to sentiment analysis, predictive analysis techniques using algorithms, data mining, statistic modeling, and advanced visualization.

Build valuable contacts

Join in our special networking and evening events and take advantage of group breakfasts and lunches to engage with a dynamic Business Analytics community and immerse yourself in innovative learning experiences with peers and industry leaders.

Stay ahead of the game

Learn about the latest advances, roadmaps, and strategic vision for the Microsoft Business Analytics platform. Get up-to-date on what’s important now and going forward.

Gain information on key BA platform

The exhibit hall brings together the top Business Analytics tools and services under one roof. Get hands-on demos and information without having to do all the research yourself.

Increase the knowledge and skills of my entire team

Take advantage of our group discount rate: Register as a group of 5 and save.

Be inspired

The PASS BA Conference is all about meeting and talking with people, sharing issues and solutions, and gaining knowledge that will make you a better Business Analytics professional. You’ll find new ideas everywhere for improving your business.



PASS Business Analytics Conference – Quick Facts


Key Dates


April 10

Welcome Reception

April 10 (evening)

Day 1 Keynote: Microsoft

April 11

Appreciation Event

April 11

Day 2 Keynote: Steven Levitt

April 12

General Sessions

April 11-12


  • § 60 + technical sessions presented by Microsoft and Community Speakers
  • § Steven Levitt Keynote – Bestselling co-Author of Freakonomics and Super Freakonomics
  • § 5 session tracks including:
  •    ▫ Data Analytics and Visualization
  •    ▫ Advanced Analytics and Insights
  •    ▫ Information Delivery and Collaboration
  •    ▫ Big Data Innovations and Integration
  •    ▫ Strategy and Architecture

imageWhy Attend?

  • § Top community speakers including big data ZDNet blogger Andrew J. Brust; BI experts Alberto Ferrari, Stacia Misner, Peter Myers, Marco Russo and Chris Webb; data mining and predictive analytics gurus Mark Tabladillo and Cristian Vava; data science expert Mark Whitehorn; and Decision Sciences professor, Mathletics expert, and two-time Jeopardy! champion Wayne Winston.
  • § Hear from the Microsoft experts: Kamal Hathi, Director of the BI Group for Microsoft SQL Server; Ashvini Sharma, Group Program Manager in the Office Data Experiences team; and Tim Mallalieu, Principal Group Program Manager for Microsoft HDInsight.
  • § Connect with us for real-word insights, prescriptive guidance, best practices, and strategic vision
  • § Expand your ability to analyze, manage, and share information to predict business performance
  • § Walk away with the tools and connections for maximum impact within your organization
  • § Dig deeper into Microsoft’s collaborative BA platform – Excel, SharePoint, Azure, Hadoop,
  • Parallel Data Warehouse, and SQL Server.

Connect with us: clip_image001 clip_image002 clip_image003[7]



SQL 2012 Business Intelligence Automation of Demo Builds Part 3 SelfService BI

The reason I created this project on CodePlex is that everyone has been asking in user groups, SharePoint Saturday events etc. When we will have a downloadable VHD like we did with SharePoint 2010 with the Information Worker VHD. Also, One of the issues that used to bug me was having to download 60 750MB files and then merge them together in get one SharePoint 2010 Demo VHD.

After learning how Microsoft was packaging their Demos I thought we could have many more of them available for folks to use and they are fun to share, there had to be a better way. Not including the Installation media Windows Server 2012, SQL Server 2012 , and SharePoint 2013. All of the Content packs we have deployed so far as a group are less than a 750MB download…


The reason I created this project on codeplex is that everyone has been asking in user groups, SharePoint Saturday events etc. When we will have a downloadable VHD…

Project Description
Through the use of Content Packs for SelfService BI, ECM, Search and BigData,  we hope to bring you the ability to use the same demos we have built based with exaples like Contoso Medical, Great White Gears, Contoso Schools, AdventureWorks Camping Supplies, TaolSpinToys,  Contoso Casino, and more. We have extended the Content Pack so that we can now install SQL 2012 SP1 and SharePoint 2013 in almost the same configuration as our environment, that allows us to give you these demos..


Evaluation Copies are OK, we will not be providing any way for them to be re-armed after the 180 day trial is over.

The entire installation is PowerShell with a GUI Interface….

Prerequisites: License Keys and installation media for the following:

  1. Windows Server 2008R2 Sp1 or Windows server 2012
  2. SQL Server 2012 SP1
  3. SharePoint 2013

  • Installed and Configured
  • Windows OS from the list above
  • AD Directory Services Installed and Promoted for the domain

After the SQL 2012 SP1 Installation you will have three instances of Analysis Services (Tabular, Multidimensional, and PowerPivot) this will allow us to share our data with you while reducing the amount of confusion there can be when setting up these services and using them with SharePoint for the first time.



Please let us know if you think we have missed anything we appreciate your feedback and are always looking for folks to beta test our deliverables before we upload them here…

The Content Packs that we have up so far are the following

Active Directory Content Pack Demo 2.0 – Creates an Employees OU, adds the standard 200 or so Contoso employees to the Employee’s OU with passwords, and Last adds the SPFarm, and SPAdmin service accounts to the Domain Admin’s group

SQL 2012 SP1 Content Pack Demo Build 2.0.0 – Installs SQL 2012 SP1 with three instances of Analysis Services (Tabular, Multidimensional, and PowerPivot) and RS integrated SharePoint mode.

Self-Service BI Demo 2.0 Content Pack – Installs the Self-Service BI Demos with the following databases and models:


• AdventureWorksDW2012
• AutoSalesSourceDW
• ContosoEnergyDW
• ContosoSchoolsDW
• TailspinToys

• AutoSalesModel
• ContosoEnergyModel
• ContosoSchoolsModel
• Customer Profitability
• TailspinToysModel

If you get a chance I would love to have some folks testing the deployment and providing feedback as I continue to add additional Content Packs, it seems I take less time testing the PowerShell scripts the more I use PowerShell because I know it right, lol.. Sad, but a true trap of using a technology everyday and taking your skills for granted..

What’s Planned – Coming Soon

  • People Pack with My Site Provisioning & Social networking Demo 2.0 
  • Visio Services 2013 Demo 2.0
  • Great White Gears demo 2.0
  • AdventureWorks Camping Supplies E-Commerce Demo 2.0 



Technorati Tags: ,,

MSDN Forum Jam 2012 Updates Cross Post Original by Chris Givens

Chris Givens put together a contest for fun and a couple of Beers. But there are so many MVPs that are more active in the forums than I am I don’t think I stand a chance..

I have included the results from 01/23/2013, but you will need to visit Chris’s Blog in order to be kept up to date…

MSDN Forum Jam 2012 Updates -Latest Results – 1/23/2013







59 126

Amit V


28 62

Chris Givens


17 60

Ivan Sanders


20 46

Marc D Anderson


30 43



10 17

Doug Hemminger


6 8

Fabian G Williams


7 8

Gavin Barron


3 8

Nicholas Holloway


1 8


60 1 5


35 3 2


25 1 1

In other new I have created 2 new sites on Codeplex

The first SharePoint Demo Builds where I have created Content Packs for Populating Active Directory, Installing and Configuration of SQL 2012 SP1 with AS Tabular, Multidimensional, and PowerPivot modes and of course Integrated mode. Along with Self Service BI with documentation and walkthroughs of the Labs and Demos, ECM primarily Focused on Search and Social features, Big data which is all about data Mining and displaying the results in SharePoint 2013.

The second site SharePoint 2013 Databases Documented I have used tools Apex SQL DOC to list all of the stored procedures, tables, dependencies, functions and much more for every SharePoint 2013 Database.

Anyway to all my felloow MVPs I cant wait to hang out with Everyone in 3 weeks in Redmond. As always it will be a blast… Have fun…



SQL 2012 Business Intelligence Automation of Demo Builds

Happy New Year!!!

Pretty much everyone one I know for the past year in the SharePoint community has been working on keeping their VMs up to date with the latest SQL and SharePoint Releases.

This is especially true if your Demos include Business Intelligence… In addition, unless you have a Shared environment in the cloud its difficult when writing books on Business Intelligence to keep everyone on the same page and see the really cool stuff they are doing…IN addition, at the end of the day its you the reader I think would prefer to be able to build the same environment that we are referencing when writing the books and doing the sessions.

This is my first post on hopefully making this easier as I know there are plenty of folks having problems with  Installing PowerPivot with SharePoint because I answer questions in the forums. Specifically the PowerPivot Installation and Configuration with SharePoint 2013. One of the many things I think is cool about the SQL 2012 SP1 Release is that PowerPivot Doesn’t have to be installed on any of your SharePoint Servers in your farm. Unless you want to schedule refreshes, have the PowerPivot gallery, or work with Power View and Reporting Services in SharePoint mode.

So I have attached below a copy of a SQL Server 2012 Configuration File PowerPivot.Configurations.ini that will Install anywhere in your environment in its own POWERPIVOT Instance.

There are a couple changes that you will need to make for your environment and on depending how hands on you want to be with the installation.. You can choose to use the file as it is now in Simplified UI mode which is much faster and less tedious than waiting for all of the tests and entering the information by hand, I don’t know about you but whenever I have that many choices to click on I am bound to make a mistake.

However, you can also run it in silent mode by entering your Product Key, Uncommenting the PID parameter.

Then Comment out UIMODE and change either parameter QUITE or QUITESIMPLE value to True

The last change you will need to make unless your installing in the AD Domain is to Change the Service Account Username and Password  on Line 93

Then add or remove any additional Administrators on Line 130.

I have included a link to the file on SkyDrive  so you can download today and check it out. 

One last thing the syntax  to start the setup is really easy, if you mount the SQL 2012 SP1 ISO as D: then Run as an Administrator to open a DOS prompt and Change drives to D: Then enter the following.

Setup /CONFIGURATION=D:\PowerPivot.ConfigurationFile.ini

Note: You will still need to run the PowerPivot for SharePoint 2013 Configuration tool to configure the PowerPivot Service Application…

Cheers, and Happy New Year………..



Business Intelligence in Microsoft® SharePoint® 2013

Wow, some one tried tell me but I didn’t listen, well at least not closely enough… I would just like to thank my co-authors but especially Norm for being there when I needed a shoulder to lean on and giving me the opportunity to almost kill myself as I lost the plot, working too many hours consulting for too many clients, building the demos for the book and the SharePoint Conference and of course writing…  Also thanks to Ken and O’Reilly for believing in me when I almost didn’t believe in myself.. The final drafts go out in two weeks and it will take a couple of months to get on your shelf.

clip_image001Dive 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.

Discover how to:

  • •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

By Norman P. Warren, Mariano Teixeira Neto, Stacia Misner, Ivan Sanders

Coming to  a store near you in January of 2013

I have said it before and I will say it again its all about friends…. You guys ROCK!



I’m presenting at the SharePoint Conference 2012 in Las Vegas–November 12-15, 2012

We received the Official announcement on Thursday that Norm Warren and I will be presenting on: 

Practical Deployment Aspects of Business Intelligence

Please join Ivan Sanders and Norm Warren as they walk you through the best practices on the Design, Development and Deployment of Business Intelligence Objects with with SQL Server 2012, SharePoint 2013 on Windows Server 2012 using Visual Studio 2012



Don’t forget to register, this event will sell out




Best Practices and Practical Deployment Aspects of Business Intelligence with SharePoint 2013, SQL Server 2012 on Windows Server 2012

I am very lucky in that I have been accepted to present on Business Intelligence Best Practices at a few upcoming SharePoint Saturdays which I hope all of you will attend.

This session is primarily based on walking you through demos on the Design, Development and Deployment of Business Intelligence Objects following SharePoint Best Practices in all aspects from Design to Deployment methodologies of SharePoint 2013. This session will start with a very quick walk through the foundational aspects of Business intelligence when integrated with SharePoint along Best practices in the Design, Development and deployment of Business Intelligence solutions in SharePoint Server 2013, with SQL Server 2012, on Windows Server 2012 that will include Analysis Services Solutions, with PowerPivot, PowerView and Reporting Services, Excel and Visio Services.

Also, Norm and Ivan will walk through the governance issues surrounding the deployment of SharePoint 2013 in general and the Business Intelligence Aspects in specific. In addition, Norm will quickly explain practical paths for designing tabular models in PowerPivot and the SQL Server Data Tools environment. He will explain decision points such as hybrid approaches with Direct Query, and include best practices for automating data refresh in SharePoint and scheduling processing in Analysis Services.

The session includes a thorough demo of creating an Odata feed from SharePoint lists and SQL Azure to relate a date table for quickly showing aspects of time intelligence. The demo will continue by showing how to create partitions in SQL Server 2012 and schedule data refresh (with an interval of 15 minutes) using XMLA. Lastly, the team will discuss how to choose the right Business Intelligence tools to start using now so you can show immediate results while planning for the future evolution of your SharePoint Business Intelligence Dashboards.. All demos are built on Windows Server 2012, SQL Server 2012, and SharePoint Server 2013.

clip_image001I have been very blessed this year to be working on the Second edition of the Business Intelligence in Microsoft SharePoint 2013 with the illustrious group of Norman P. Warren, Mariano Teixeira Neto, John Campbell, Stacia Misner the author’s of the First edition Business Intelligence in Microsoft SharePoint 2010.

Norm currently works for to help people discover, preserve and share their family history. Norm was previously a writer for PerformancePoint Server 2007 and SharePoint Server 2010 at Microsoft, and has written articles on PerformancePoint Server for the information worker, IT Pro, and SQL Server BI developer audiences. Norm has his Master’s degree in computer information technology and is currently earning his MBA with an emphasis in financial accounting.

Norm has an active member of the community to provide the right content about Microsoft business intelligence such the SharePoint BI poster (Visio ( His past time is with his family, mountain biking, and sharing his passion of BI in SharePoint.

Norm will be joining me for the first two in an upcoming series of SharePoint Saturdays during the next few months. The first of this series is coming up on September 22nd 2012 in Redmond WA. at the Microsoft Conference Center. Where if you are like me and have a passion for all things Microsoft then you know its one of the best cities in the world ad I hope you will join us for this event and the place to register is

The second in the series will be held ion Bend OR. on October 6th 2012 at Central Oregon Community College in Bend, Oregon. If you were unable to join us in Redmond then this is the event we hope you can attend due to the numerous seasoned experts, MVPs and MCMs alike. Please don’t forget to register

The last in the series leading up to the SharePoint Conference in Las Vegas Nevada will be held in Sacramento California on October 13th 2012 at the Woodlake Hotel near the Cal Expo in downtown Sacramento. I was fortunate enough to be the keynote speaker last year and the number of people attending and the excellent venue made this one of the highlights of my year of presenting at many SharePoint Saturdays of which I was privileged. Registration is open

Last I would like to thank the many sponsors that make all of the free SharePoint Saturday events possible:
























If you have been in the SharePoint industry  for any length of time you may be able to tell from the number of sponsors with SharePoint products and services, the SharePoint community is getting better very year and becoming more vibrant every day.

Thank You to ALL our SPONSORS and VOLUNTEERS for making SharePoint Saturdays possible…




Administration Toolkit for RMS, SP2 – IRM Check – Configuration Test

The Administration Toolkit contains additional programs that Microsoft developers created while working on Windows Rights Management Services (RMS). We found them useful in troubleshooting registry overrides, intended and allowed us to make modifications and get information about the environment.

We have taken great care to ensure that the tools operate as they should, but they are not part of Windows RMS and are not supported by Microsoft. For this reason, Microsoft technical support is unable to answer questions about this toolkit.

Note: The administration toolkit is designed for use on servers with US-English regional options.

The following tools are included in the toolkit. To learn more about a tool, open the Readme file for the tool:

AD SCP Register
Use this tool to register or unregister a service connection point in Active Directory.

  • Get RMS SCP
    Use this tool to validate the current service connection point registered in Active Directory
  • IRM Check
    For enterprises that are using RMS with Office System 2003. Use this tool to create an html-based report of the client configuration, Office version, registry keys, and other settings that impact the RMS system.
  • RMS Cert Analyzer
    Use this tool to check the certificate chain on a given rights account certificate, view rights data and certificate information.
  • RMS Config Editor
    Use this tool to easily view and edit data in the RMS configuration database.
  • RMS Event Viewer
    Use this tool to map RMS log entries to events, enabling the logs to be viewed using the Event Viewer.
  • RMS Log Analyzer
    Use this tool to analyze the log file of your RMS server to track server errors, query for specific users, and other logged events.
  • RMS Queue Recovery
    Use this tool to recover logged events from the MSMQ dead letter queue.
  • RMS Service Locator
    Use this tool to provide a report of all the URLs that RMS uses.

Note: For information about implementing, deploying, and administering RMS, see the RMS TechCenter

IRM Check – Configuration Test




As time permits I will continue this series and write about the additional tools… Most if not all of the additional features require .Net 3.5.


Also, the only tool I found that did not work was the RMS Log Analyzer as can be seen from the screenshot below. I haven’t had the chance to debug but it looks like a table wasn’t created when you create the DRMS_Log_Admin Db


Additional Reference

SharePoint Information Rights Management (Health model) Pretty much very EventId associated with SharePoint IRM this link is invaluable