Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Installing SQL Server 2012 SP1 CTP4 Experience

Posted by denglishbi on September 22, 2012

A standalone version of the SQL Server 2012 SP1 was released this week.  It is not the final release, just a community technology preview (CTP4), but a release that we can test out none the less.  The exciting part of this release to me are the enhancements that have been added to Power View.  Here you will see the steps I went through to upgrade my evaluation virtual machine I have setup that is based on the Appendix B that comes with our book – Visualizing Data with Microsoft Power View.

First you will need to download the SQL Server 2012 SP1 CTP and you can do that from here – SQL Server 2012 SP1 CTP (there is even a full SQL 2012 slipstream version you can download as well that includes the service pack).  You also might want to download some of the additional features that are provided with the feature pack and you can get that from here – Microsoft® SQL Server® 2012 SP1 Community Technology Preview Feature Pack.

Once you have the service pack downloaded you can run this on your machine and follow through the screenshots below.
 

image

image

image

image

image

I had one item that I needed to shutdown so that I could avoid a restart after I installed the service pack and that was related to IIS services (these are running because of SharePoint 2010).

image

So I had to stop the IIS Admin Service and the World Wide Wed Publishing Service.

image

I did a refresh check and I was good to go.

image

Running RTM Evaluation Edition – 11.0.2100.60

image

Updating the default instance of SQL 2012

image

Updating 2nd instance of SQL 2012 (POWERPIVOT)

image

Instance MSSQLSERVER overall summary:
  Final result:                  Passed
  Exit code (Decimal):           0
  Start time:                    2012-09-22 08:15:42
  End time:                      2012-09-22 08:33:33
  Requested action:              Patch

Instance POWERPIVOT overall summary:
  Final result:                  Passed
  Exit code (Decimal):           0
  Start time:                    2012-09-22 08:33:57
  End time:                      2012-09-22 08:35:24
  Requested action:              Patch

Patch Level: 11.1.2845.0

image

Verify I can connect to my instances of the database engine and Analysis Services along with reviewing the build numbers.

Microsoft SQL Server 2012 – 11.0.2845.0 (X64)
    Sep  1 2012 02:36:04
    Copyright (c) Microsoft Corporation
    Enterprise Evaluation Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

Now to go start into SharePoint and check out Power View!

image

New Ribbon layouts, icons, and features (images, hyperlinks, field list control)

image

More style, text, and background options

image

New visualizations – Pie and Map charts along with font sizes

image

Pie Charts, but no data labels or sorting options.

image

Bing geo-encoded maps

image

Pre-defined drill up/down capabilities

image

Support to restore Excel 2013 PowerPivot files in Tabular SSAS

image

SQL Saturday #149 is coming up next:)

image

SharePoint 2010 will not support the Power View that is in Excel 2013 files.

image

I noticed that my PowerPivot was not working yet, so need to run the PowerPivot Configuration Tool.

image

image

New version detected, time to upgrade.

image

Run the upgrade process.

image

After this is done we go back in and test out PowerPivot again

image

Now it works just fine.  The one thing I noticed is that it doesn’t appear to be working with the Excel 2013 PowerPivot files though.

image

Maybe these will not work in SharePoint 2010, not quite sure yet, will need to look into this more.

For more information on the new features available in the updated version of Power View check out some of these references:

Here are some more links for information on the SP1 updates:

This service pack also includes performance improvements with slicers and filters with PowerPivot and Tabular SSAS as well as I demoed here in this post and video – Excel PowerPivot SQL 2012 vs. Excel 2013 Performance Demo.

Now we just need to wait for the final release and hopefully that will be coming out in a couple of months now, should be very soon. Enjoy!

23 Responses to “Installing SQL Server 2012 SP1 CTP4 Experience”

  1. Rachael Anderson said

    That’s great news! I assume that means that when this rolls out we can use it in Sharepoint 2010 with Powerview so that we can use templates as you mentioned on another blog. It sounds like this would be available before Sharepoint 2013. It also sounds like we don’t have to be using Excel 2013, is that correct? We are currently piloting SQLServer 2012 BI features in Sharepoint 2010 but would like the added features. If we had to wait for Sharepoint 2013 and Excel 2013 we probably wouldn’t be able to start on that until the end of next year. I hoping the CTP3 or CTP4 will enable us to use templates, etc with PowerView some time in the first half of the year. Does that sound realistic?

    • denglishbi said

      All of the new Power View features that have been showcased in Excel 2013 are coming to SharePoint 2010 Power View. Excel 2013 will not be required to be able to use pie charts, maps, drill down/up, etc. It does not appear that SharePoint 2010 will provide a while lot of support for Excel 2013 files. You will be able to import Excel 2013 files into SQL 2012 as I mention in the post, but you will not be able to view the Power View or interact with the PowerPivot reports.

      • Rachael Anderson said

        But if we aren’t using Excel 2013, it sounds like we should be able to use the Sharepoint version of Powerview with the CTP and be able to do the following which you had indicated on a different post: Changing Background Colors, styles, and adding an Image (such as a logo) is available with the CTP3 of SP1. Is that correct?

      • denglishbi said

        Yes, correct. Once you have the SP1 installed and the SharePoint farm updated you will be able to use all of these new features. Excel 2013 will not be required. You can test it out now with the CTP4 of the SP1 and you can see the new features options in my post here as well.

      • Rachael Anderson said

        One other question, does CTP4 support going against Multi-dimensional cubes directly with Powerview?

      • denglishbi said

        I have not heard of an official release date for that support yet. I know it is being worked on and not sure how close they are to being able to release it yet or what will be supported going against a multidiemnsional model.

      • Rachael Anderson said

        Thanks.

  2. Serge said

    When I installed SP1 CTP4 job with processing in-memory model became slowly in 2 times. Do You have this issue ?

  3. Mric said

    Great experience, Thank you.
    There are new aggregations in powerview ? (like cumulative value for exemple ?)
    Thanks in advance for you response.

  4. Baghul said

    Thank you for sharing the article on installation. Also found a good sample video here:

    http://sqlserver2012tutorial.com/faqs/

  5. mikedobing said

    Hi

    Great article. Quick question, to access the new powerview features in sharepoint 2010 do we just need to upgrade our sharepoint SQL server instance (hosting reporting services) to sp1 or do we need to any upgrades within sharepoint also?

    Thanks

    Mike

  6. mike dobing said

    Hi,

    We’ve installed SQL Server 2012 SP1 on all our instances (SharePoint 2010 SP1), however the new powerview features (kpi, heirarchies etc) are no showing when we open the powerview app when pointing to the tabular model. Is there anything else we need to do to activate these features? The powerview version is still showing as 11.0.2…, yet the SQL Server the reporting services app exists on is definitely 11.0.3.

    Any advice would be greatly appreciated.

    Thanks

    Mike

    • denglishbi said

      If you are seeing the new items in the ribbon in Power View you have successfully upgraded the SharePoint environment. Now you need to update your existing model. There is a new compatibility property that you need to set. You will need to install SP1 on your development workstation and set the property and redeploy or you could simply script out your model and alter the property value and do an alter on your existing model. For more information check out this post here – http://denglishbi.wordpress.com/2012/10/04/tabular-models-compatibility-level-and-power-view/.

      • mike dobing said

        Hi,

        Thanks for replying – no, we can’t see the new items in the ribbon, it’s just the old ribbon so we don’t see “picture” for instance. I have upgraded the tabular model to the latest version and went deploy to SSAS it has 11.03 as the version. It’s just powerview that doesn’t seem to have been upgraded itself.

      • denglishbi said

        In Central Admin go into the SSRS service application and go into the properties or manage it (can’t think of the setting off top of my head). Where you would see the application pool settings, and your deployment settings. Don’t change anything, simply scroll to the bottom and click OK or Accept (which ever button it is) and see if that will upgrade and push out the change to complete the SP1 update for the SSRS service.

      • mike dobing said

        Hi,

        I was excited then as I thought it was progressing, unfortunately there is no change. Powerview is still showing the same ribbon, the version as 11.021 or something. I’ve also restarted the SSRS service on sharepoint but to avail. There’s no separate upgrade I have to do in sharepoint is there? We installed the service pack (sp1) on the sql instance, that’s all that’s required to upgrade powerview isn’t it?

        So frustrating! :-(

      • denglishbi said

        Check the build number of your SSRS service, not sure if you have already done this or not. Go to the following URL http:///_vti_bin/ReportServer and see what is displayed. That should indicate if you have properly upgraded. If that displays properly, 11.0.3000.0, the next thing I can think of would be to install the SharePoint Report Services SQL 2012 SP1 Integrated components on your WFEs. You can download that from the SQL Server 2012 SP1 Feature Pack.

        Dan English Microsoft SQL Server MVP
        Business Intelligence Manager
        350 W. Burnsville Parkway, Suite 550, Burnsville, MN 55337 | http://www.teamscs.com
        Phone: 952.890.0606 | Fax: 952.890.2392 | mailto:denglish@teamscs.com

        Stop disaster before it starts! Learn why you should switch from a disaster recovery model to IT infrastructure resiliency planning in our refreshed newsletter, SCS Quarterly Connection http://bit.ly/TPGL9S.

      • mike dobing said

        Thanks Dan – I’ve checked and the version is still showing as 11.0.21, so it would seem that the upgrade didn’t apply correctly. We are going to unsintall SP1 and reapply. This is the only WFE (as it’s dev environment) so there’s nowhere else to install it.

        Very odd why it didn’t upgrade though, I’ll let you know how we get on as I’m sure there’ll be others like this.

        Thanks for your time, much appreciated.

        Mike

      • mike dobing said

        Hi Dan, FYI – it’s working now – it was as you said, it was me being thick! We applied SP1 to the sharepoint WFE and all works well now. I only though we applied to the SQL instance, my bad!

        Thanks again!

        Mike

      • denglishbi said

        Glad to hear, enjoy:)

        Dan English Microsoft SQL Server MVP
        Business Intelligence Manager
        350 W. Burnsville Parkway, Suite 550, Burnsville, MN 55337 | http://www.teamscs.com
        Phone: 952.890.0606 | Fax: 952.890.2392 | mailto:denglish@teamscs.com

        Stop disaster before it starts! Learn why you should switch from a disaster recovery model to IT infrastructure resiliency planning in our refreshed newsletter, SCS Quarterly Connection http://bit.ly/TPGL9S.

  7. Rachael Anderson said

    Is there any news about when this will be released (approximate time frame)?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 1,758 other followers

%d bloggers like this: