Fastest way to get a #msbi VM with #sharepoint 2013 & #PowerView Multidimensional? use online MS sales demo VMs

Do you need a clean Sharepoint 2013 #msbi VM with PowerView multidimensional for demos/testing purposes? Don’t want to –or can’t- build one from scratch? and have you access to Microsoft partner resources?

Online pre-prepared #msbi vms&demos  at http://fs.mssalesdemos.com/

Well, be sure to check the MS partner site http://fs.mssalesdemos.com/ for demo VMs. You’ll find at least two fully loaded VMs for #msbi with SharePoint 2013 and several prepared demo content & resources (powerview, powerpivot, excel).

These VMs work extremely well for demoing or testing purposes, they start in minutes and you connect using remote desktop. Performance is very acceptable. And you can save them for later use! :)

Unfortunately none has CU4 applied to run PowerView over multidimensional cubes, but we can solve that very quickly! Just download & install the CU4/(or the most recent CU5) :)

Download and install SQL 2012 SP1 CU4 for SSAS multidimensional support in SharePoint PowerView

I started up an instance of the “SQL Server 2012 BI Demo – Breakthrough Insight (March 2013)” VM. Already has SQL 2012 SP1.

image

Wait until the VM starts, connect using the rdp link:

image

and just download the hotfix inside the VM (should be very fast, 770MB took only a few minutes in my case).

image

Apply the SQL 2012 SP1 CU4 (I updated all instances just in case, took a bit longer). (ps-be sure to stop the World Wide Web Publishing Service service to avoid a restart and closed all Man. Studio and similar apps,

restart the www service after CU4 finished)

image

image

And you’re done!

Create a “Semantic Model connection for PowerView” data source for your SSAS cubes

Now, just create a new data source in Sharepoint (ex: http://intranet.contoso.com/Shared%20Documents/) and open it to start PowerView . You even got some multidimensional models installed (ex: contoso retail).

image

image

Click the created data source and PowerView should open connected to the Contoso Retail cube:

Check the official guide to know more: “Understanding Power View for Multidimensional Models

image

& Save the demo VM for later use on mssalesdemos

And for the better part :), you can then save the VM for later use (just don’t trust it will be there forever… they sometimes expire and disappear without warning…).

For this use the “Stop and Save” option (prepare to wait between 5-10 minutes while the VM is saved).

image

image

The new VM should then appear in your catalog. You can come back later and start from were you left off:

image

btw- if you want to check other demo resources in the VM:

 

http://intranet.contoso.com/sites/bicenter

http://intranet.contoso.com/PowerPivot%20Gallery/Forms/Gallery.aspx

imageimage

Take care!

Rui

Advertisements