For those who missed it, the launch date of SharePoint was announced. The launch will be done by President of the Microsoft Business Division Stephen Elop as he introduces Office and SharePoint 2010 on May 12, 2010 at 11 a.m. EST.
You can join him live at: http://sharepoint.microsoft.com/businessproductivity/proof/pages/2010-launch-events.aspx#fbid=JadoeNy2pBe
I just can’t wait to get PowerPivot to production !
This screencast will show you how we create a dashboard on a SSAS cube in PerformancePoint 2010 using a filter with time intelligent functions:
A few important points:
Pretty though demo to do 10 minutes, please don’t hesitate to ask me questions here.
Big thanks to these blog posts:
http://consultingblogs.emc.com/davidfrancis/archive/2007/12/02/PerformancePoint-Time-Intelligence-_2D00_-BI-for-the-masses-Part-1.aspx
http://blogs.msdn.com/performancepoint/archive/2009/12/14/configuring-data-source-time-settings-for-time-intelligence.aspx
http://blogs.msdn.com/performancepoint/archive/2010/01/21/time-intelligence-formula-quick-reference.aspx
And Dan English to point out to me i have to use the Hierarchy to add multiple Time Member Associations at the Ms forum:
http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/5f7f3e9b-1648-48c7-8cdf-8e3fb211b0ae?prof=required&ppud=4
This blog post will describe how you I enabled PerformancePoint 2010 on my SharePoint 2010 with PowerPivot integraton where I used the VidasM installaton guide. This is by no way the best way to do this but it enables you to play with PerformancePoint. I used (and took some quotes) the PerformancePoint team excellent blog post Deploying PerformancePoint 2010 Soup to Nuts as a base (this is the official way to do it).
We start by creating a site collection:
Set a name, location and choose Business intelligence center as template:
Site should be created ok:
Now we are going to turn on the PerformancePoint services:
Go to central admin , system settings, manage services on serve. You need to start the PerformancePoint Services and the Secure Store Service:
Once the Business Intelligence Center has been created, the administrator must create a PerformancePoint service application. This creates the service application proxy that facilitates web service calls between the WFE and the app server, along the Windows Communication Framework.
Go to Application Management, Service Applications , Manage service applications, click new, select performancepoint service application:
Last step is configuring the service app, give it a name and add check the “Add this service application’s proxy to the farm’s default proxy list” and create a new app pool.
Read the entire PerformancePoint team blog post for the details on the why.
When you finished this last step you can start playing with PerformancePoint and publish the dashboards:
In my previous PowerPivot post i created a SSRS report based on a published PowerPivot app with DAX measures. In this post we are going to create a PerformancePoint 2010 dashboard based on the published PowerPivot App and publish it to SharePoint. First you need to enable PerformancePoint in SharePoint 2010, to do this the PerformancePoint team has created an excellent blog post: Deploying PerformancePoint 2010 Soup to Nuts
Ok we start at the PerformancePoint site:
And click start using PerformancePoint Services:
Click the Run dashboard designer button to start the o so familiar dashboard designer (same as 2007). we start by adding a Datasource which points to our PowerPivot xlsx:
I selected the “Per user identity” because i haven’t got my installation really ok (the unattended service account is not installed). Next we can create a scorecard, right mouse on PerformancePoint content, new, Scorecard
Select analysis services and click OK, select the datasource we just created:
We need to create the KPI ourselves, so we select the measures created in PowerPivot, I want to see the the totals sales last month measured against the avg last year, we select the band method “increasing is better”, because more ordeer are better 
We select the year we want our KPI shown against
The next steps we keep the default values, click finish to create and load the dashboard:
Now we want to show the sales kpi by Promotioncategory, you can drag the dimension you want into the scorecard. Don’t forget to click update to show the new result.
I rather like other indicators than the default, so go to the KPI, click scoring and patterns and doubleclick the indicator to select a new indicator, I like the indicator below:
save the indicator, go to the scorecard and update again:
Next i wanted to get a graph to show the orderquantity by year, create a new report and select graph. Put the measure in series and calendaryear on the bottom axis.
Last we create the dashboard to show the data, i created a 2 column dashboard with a top bar. I dragged the scorecard to the right column and the chart report in the left column. You can add a date selection in the top bar when want, or even the new time intelligent filter. I did not add one this time.
Next we save and deploy the dashboard to SharePoint:
It will automaticly open the dashboard in SharePoint, looks great in my opinion:
As last item I wanted to show you one neat thing: the new silverlight decomposition tree. Right click on a bar in the chart and click decomposition. I clicked on the 2007 bar.
When you click the value you can expand the value to a dimension and so on:
Using PerformancePoint on a PowerPivot App is another great way to show the data to you customers, the creation of dashboards are doable for the analysts.
After installing PowerPivot on SharePoint 2010 thanks to the excelent guid of VidasM i decided to try and install report services 2008 R2.
To start I downloaded the SQL Server® 2008 R2 November CTP Reporting Services Add-in for Microsoft SharePoint® Technologies 2010 and followed the instructions there:
Step 1: Install a SharePoint technology instance. (Already did this when installing PowerPivot with SharePoint)
Step 2: Install SQL Server 2008 R2 November CTP Reporting Services and specify that the report server use SharePoint Integrated mode.
Step 3: Configure Reporting Services.
Step 4: Download the Reporting Services Add-in by clicking the rsSharePoint.msi link later on this page. To start the installation immediately, click Run.
After installing Reporting services and the add-in your reporting server is ready to be integrated with SharePoint, in SharePoint 2010 we have some new admin screens.
To integrate go to central admin, general application settings:
When you successfully installed the add-in a reporting services icon will be there. Click Reporting Services Integration:
Add the report server web service url (To get the URL, open the Reporting Services Configuration tool, connect to the report server, and click Web Service URL. Click the URL to verify it works. Copy the URL and paste it into Report Server Web Service URL.), select your authentication mode (windows authentication is prefered). Add a username and password of your admin account. Click ok to configure and start the integration.
After the installation you can set the reporting services default.
What is changed in SP2010 is that there isn’t a report library available. You have to add content types to a default library. So go to a site collection, site actions, View all site content.
Create a Asset library:
Now we have to make sure we can add reports to the library. To do this we have to add content types:
Open the library, click on library tools, library settings, Under Content Types, click Add from existing site content types. In the Select Content Types section, in Select site content types from, click the arrow to select Reporting Services. In the Available Site Content Types list, click Report Builder, Report Data Source and Report and then click Add to move the selected content type to the Content types to add list.
Now we are ready to upload reports and execute them from within our webparts:
More reading about this on BOL:
How to: Configure Report Server Integration in SharePoint Central Administration
I have created a SharePoint 2010 image with PowerPivot integration with the help of Vidas installation guide, after creating it locally I found out a VM with 2 GB of memory was too small. So I decided to try my luck at our server admins. They were so kind to create a machine for me on their farm So having transfered my image to the ESX servers logging in to Remote desktop i was able to acces SharePoint like before. But ofcourse i wanted to share my SharePoint with PowerPivot installation with my colleagues and sales.
When i called SharePoint on its IP adress i got a log in screen. After logging in on the local domain SharePoint and the PowerPivot gallery showed Ok, but selecting the PowerPivot sheet gave a file not found error:
At first i suspected some kind of security problem, but after checking the log files i found the following error:
12/01/2009 13:19:38.29 w3wp.exe (0x010C) 0x13E4 SharePoint Foundation Configuration 8059 Warning Alternate access mappings have not been configured. Users or services are accessing the site http://sp2010beta with the URL http://172.31.20.10. This may cause incorrect links to be stored or returned to users. If this is expected, add the URL http://172.31.20.10 as an AAM response URL. For more information, see: http://go.microsoft.com/fwlink/?LinkId=114854″/> f998f54f-ab53-4f0d-afac-859a9c4e67b4
After consulting with colleague Marc Valk i added the hostname and IP adress to the host file of the server. In my case:
172.31.20.10 sp2010beta
127.0.0.1 sp2010beta
and gave a ipconfig /flushdns.
I added 172.31.20.10 sp2010beta to my local host file, restarted my IE and called the site by its hostname http://sp2010beta worked like a charm !
Now that SharePoint 2010 is on the horizon, there have been a lot of questions about what the differences are between PerformancePoint Server 2007 and PerformancePoint Services 2010. While most of the feature upgrades surround architectural changes, several changes have been made to enhance the user experience. The MS Performance Point services team has created a great blog post with some of the upgrades that you will see in 2010.
Looks very good, can’t wait to play around with PerformancePoint Services 2010!
The current Performance Point 2007 is pretty nice and has some nice out the box functions, but many request of customer can’t be easily solved by PerformancePoint 2007. But the new wave of PerformancePoint Services functions, that will be released in SharePoint 2010, offer a bright future for the product. One of these functions is Time Intelligence for Microsoft PerformancePoint Services:
Flexible Formulas: Specify almost any time period desired with a rich syntax and flexible formula language. Powerful “To Date” functions enable users to observe performance thus far. With these, creating seasonal adjusted metrics such as year over year (YoY) year to date sales have never been easier.
And link together your dashboard with potent Time Intelligence filters to dynamically change, explore, and analyze your data with respect to time.
Another great function is: Calculated Metrics
With calculated metrics you can create much more advanced metrics to use in your dashboards.
This release we have introduced a new feature called “Calculated Metrics.” Calculated Metrics are powerful for several reasons:
- Can use multiple data sources in the same formula.
- Can use different data source types in the same formula.
- Is expressed in simple Excel-like formulas.
- Supports logic flow.
What i really like is the cross datasource functionality and the ease the analysts can create their own dashboards.
The guys from the PerformancePoint services blog promise us even more function in the future! So keep posted
