Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Is SQL Enterprise 2008 R2 required for Performance Point 2010?


Is SQL Enterprise 2008 R2 required for Performance Point 2010?

Author
Message
brucekoivu
brucekoivu
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 14
My company would like to try Performance Point 2010. We already have a large SharePoint 2010 farm.

The SharePoint Administrator said he thought SQL "Enterprise" 2008 R2 maybe a requirement for Performance Point (or SSAS). Can anyone confirm or deny whether
SQL Enterprise is required - we just want to demo a few reports to Sales Team.


SQL Enterprise is very expensive $30K. We would like to use either SQL Standard or SQL BI 2008 R2 rather than SQL Enterprise 2008 R2.

The administrator told me to research.
Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16441 Visits: 13202
Performance Point is a SharePoint feature, not a SQL Server one (also not from SSRS), so I believe Entrerprise is not needed. (can't find documentation though that backs this up).

You might want to check the edition of SharePoint though, you might need Enterprise there.

ps: there's no SQL 2008 BI editon. The BI edition was introduced with SQL Server 2012.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
brucekoivu
brucekoivu
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 14
Okay, Thank you for the reply. We did confirm that a Performance Point Install requires SQL 2008 Standard, but there is a catch ...

You may need POWERPIVOT which is an SQL 2008 Enterprise feature. But SQL Enterprise is not required to install and evaluate Performance Point 2010 feature. There are a few other enterprise features that are useful for data cube performance too: pre-fetching and cube write back.

So, the answer to the question is Yes and No, depending on how many cubes and users you have in production.
Kurt W. Zimmerman
Kurt W. Zimmerman
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1062 Visits: 1396
I came across this white paper published by Microsoft:

http://technet.microsoft.com/en-us/library/cc990273(v=office.14).aspx

It looks like in order to get the full features of PerformancePoint you may be looking at the SS 2K8R2 Enterprise,

Kurt

Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY

http://www.linkedin.com/in/kurtwzimmerman
Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16441 Visits: 13202
brucekoivu (10/17/2013)

You may need POWERPIVOT which is an SQL 2008 Enterprise feature.


I'm very curious what PowerPivot has to do with PerformancePoint.
You only "need" it if you're going to build a dashboard on top of PowerPivot data, but you can demo functionality with regular SSAS.

brucekoivu (10/17/2013)

There are a few other enterprise features that are useful for data cube performance too: pre-fetching and cube write back.


Cube write-back is hardly a performance feature. It allows you to update your cube from Excel.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
brucekoivu
brucekoivu
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 14
Second Question. w00t

My understanding is SQL Standard Edition 2008 is just not recommended for Performance Point 2010, due to lack of features and lack of performance.

Is there an SQL BI edition that will work with Performance Point 2010? Price Range? Is it 2008 version or the 2012 version? Can SQL BI edition 2012 be used to host SQL Analysis Services under SharePoint 2010 and Performance Point 2010? Any Catch-22's?

p.s. Koen - Thanks for the info.
Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16441 Visits: 13202
Typically you would use Analysis Services as a back-end for PerformancePoint.
Unless there are any Enterprise features of SSAS that you need, I would think standard edition would suffice.

BI edition is only available from version 2012. You can use SSAS 2012 together with SharePoint 2010.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Greg Edwards-268690
Greg Edwards-268690
SSC Eights!
SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)

Group: General Forum Members
Points: 817 Visits: 8254
brucekoivu (10/20/2013)
Second Question. w00t

My understanding is SQL Standard Edition 2008 is just not recommended for Performance Point 2010, due to lack of features and lack of performance.

Is there an SQL BI edition that will work with Performance Point 2010? Price Range? Is it 2008 version or the 2012 version? Can SQL BI edition 2012 be used to host SQL Analysis Services under SharePoint 2010 and Performance Point 2010? Any Catch-22's?

p.s. Koen - Thanks for the info.





My opinion of the BI Edition features was not real high. It was missing cube partitioning, so we still needed to keep Enterprise.

PerformancePoint was the first round of some integration of the Dashboards and ProClarity tools Microsoft acquired. Although you could build dashboards in SharePoint Std, the Dashboard Builder made this much easier.
Power Pivot has gone through a few changes, and can be used as an Excel Add In too. Starting in SharePoint 2010, you can publish workbooks using this, although the functionality is a bit reduced vs. local workbook. It is somewhat similar to pivot tables in Excel.
This allows large volumes of data to be presented in Excel (100 million rows for example).
Power Pivot is also a Server (tabular SSAS). Be aware that although things are real fast, basically everything is in memory.
In Sharepoint 2013, you get more functionality. For example, publishing a PowerPivot workbook, you can leverage the model in a Visual Studio Project for further enhancements (security comes to mind, as it is not available in plain PowerPivot). So if someone prototyped in Excel with PowerPivot, you can push this to SharePoint, and create a tabular cube from it.
There is yet 1 more version, Power BI. And Geo Flow allows some map visualizations to be easily created.

Sorry if this might seem a bit confusing - some of these technologies have been rapidly evolving the last few years.
brucekoivu
brucekoivu
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 14
Greg - I appreciate your input, even if it wanders a bit. So it appears you are using SharePoint 2013. Is there anyone who is using Performance Point with SharePoint 2010? And what database edition are you using for the Analytic Server? All I know so far is SQL Standard 2008 is not recommended for Performance Point. Did you put SSAS on the same database server as SharePoint Database, or a different server? And, how was performance and response time? Again Thanks. :-)
Greg Edwards-268690
Greg Edwards-268690
SSC Eights!
SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)

Group: General Forum Members
Points: 817 Visits: 8254
brucekoivu (10/21/2013)
Greg - I appreciate your input, even if it wanders a bit. So it appears you are using SharePoint 2013. Is there anyone who is using Performance Point with SharePoint 2010? And what database edition are you using for the Analytic Server? All I know so far is SQL Standard 2008 is not recommended for Performance Point. Did you put SSAS on the same database server as SharePoint Database, or a different server? And, how was performance and response time? Again Thanks. :-)


Part of the rambling was to try and give you a overview.
This would be more important in understanding where things are headed when you upgrade.
Licensing is also a big part.

We had SQL Enterprise, not because it was required, but for the specific features.
Data Driven Subscriptions and being able to partition our SSAS cube were very important.
PowerPivot (tabular SSAS) I think might require Enterprise, but this is completely separate from the your demo description. Be sure to check this for SQL 2012, as it may be different than SQL 2010.

I would stand a cube up on Std, and then see if you get good performance you expect.
Much can depend on both the volume of data, and what is available in the cube.
Note that partitioning by Date is real common in SSAS, for both query performance and loading data / processing the cube. Note that you can have a Dimension by Year, but not be partitioned on the back end by year.

PowerPivot as an Excel Add In, can be used without SharePoint on Excel 2010 or up.
Which actually might be a good platform to prototype with first.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search