Self-Service BI Demo 2.0 Content Pack

Rating:        Based on 1 rating
Reviewed:  1 review
Downloads: 5649
Released: Feb 26, 2013
Updated: Aug 11, 2013 by iasanders
Dev status: Stable Help Icon

Recommended Download

Application Self-Service BI Demo 2.0 Content Pack
application, 354682K, uploaded Jul 18, 2013 - 3333 downloads

Other Available Downloads

Documentation Self-Service BI Demo 2.0 Contentpack Installation Guidance
documentation, 26K, uploaded Jul 18, 2013 - 1374 downloads
Documentation Self-Service BI Demo 2.0 Content Pack Post Installation Guidance
documentation, 30K, uploaded Jul 18, 2013 - 942 downloads

Release Notes

This installable package is built on a Windows Server 2012 virtual machine. This document assumes that you have already created the VM on Windows Server 2008 R2 or Windows server 2012 Hyper-V host environment and installed the pre-requisites. This document may refer to this machine as “the base VM” or “DEMO2013a.”

Note: In SharePoint 2010, PowerPivot for SharePoint requires classic-mode Windows authentication, yet this has changed in SharePoint 2013. In SharePoint 2013, all Microsoft BI technologies support claims-based authentication, but PowerPivot supports Windows claims-mode authentication only, despite the fact that SharePoint in claims mode also supports forms-based and SAML authentication methods.

The PowerPivot for SharePoint 2013 add-in is only required for accessing workbooks as a data source from outside the farm, configuring scheduled data refresh for a workbook, using the PowerPivot Gallery, providing BISM link file support, and adding the PowerPivot Management Dashboard to SharePoint Central Administration.


• AdventureWorksDW2012
• AutoSalesSourceDW
• ContosoEnergyDW
• ContosoSchoolsDW
• TailspinToys

• AdventureWorksDW2012 - Multidimensional
• AdventureWorksDW2012 - Tabular
• AutoSalesModel - Tabular
• ContosoEnergyModel - Tabular
• ContosoSchoolsModel - Tabular
• CustomerProfitability - Tabular
• TailspinToysModel - Tabular

The databases and Models listed above may be used within additional content packs not yet created.

Pre-Requisites & Installation Instructions
The Self-Service BI Demo Content Pack has the following pre-requisites to be installed in the order listed below:

1. Windows Server 2012 Guest VM with the Active Directory DS Role for the Domain and the Active Directory Content Pack Demo 2.0 Installed.
2. Install SQL 2012 SP1 you can download the evaluation from and use the SQL 2012 SP1 Content Pack Demo 2.0 to install and configure SQL 2012 SP1 with AS PowerPivot, Multidimensional, and Tabular Models. Along with RS in SharePoint Integrated Mode.
3. Install SharePoint 2013, Download the 180 day SharePoint Evaluation . Download AutoSPInstallerInput.xml file from this site, and AutoSPInstaller from Use the configuration file downloaded from this site then Right-Click on AutoSPInstallerLaunch.bat and run as an Administrator
4. Register and Start the Reporting Services SharePoint Service and create the Service Application
5. Configure PowerPivot for SharePoint 2013
6. Install People Pack Demo 2.0 Content Pack

Right-Click on ContentPackInstaller choose run as Administrator > browse to the folder where you extracted, then Click Add a Content Pack, once completed, Click on Self-Service BI Demo from the Menu, and Click Install.

04/05/2013 Resolved an issue where the compressed file was not formatted properly and was causing the installation to fail

04/05/2013 Resolved an issue of using Multiple Downloads, now there is a single download for the Content Pack

04/10/2013 Resolved an issue restoring the AdventureWorksDW2012 Model to the correct AS Instance

04/21/2013 Resolved issue where two IIS WebSites were not being created on ports 81 and 8081

06/09/2013 Resolved issue where intermittent issue with URL

06/16/2013 Added Images to the PowerView Reports, and resolved issue with additional websites added by the script

06/29/2013 Added the PowerView Demo scripts for TailSpin Toys, Contoso Schools, Contoso Oil & Gas and more. Resolved issue with BISM Data Source. Modified c2wtshost.exe.config for allowed callers Contoso\WSS_WP. By default no callers are allowed to use the Windows Identity Foundation Claims To NT Token Service and SharePoint 2013 is not DC aware.

07/17/2013 Added the AdventureWorksDW2012 - Tabular Model, Added the SQL 2012 Reporting Services Application Configuration, and after the Site Collection is restored performs a Full Crawl. Version 15.2.7

Reviews for this release

Would not run with ContentPackInstaller but ran fine with PS. Nice job.
by MarioAnz on Nov 13, 2013 at 8:42 PM