Friday, March 29, 2013

Adding Filters into PerformancePoint KPI Scorecard

Assuming we have the below scorecard and filter.

1. Scorecard named "Subjects Scorecard" with a list if KPIs called "English" and "Computer Science".

photo1

2. Filter called "Choose Subjects"

photo2

Lets see how we can connect the filter to the scorecard.

1. As you may have already know, we need to create a dashboard page first.

2. Then add the filter and scorecard into the dashboard page

photo3

3. Next step is to create connection between them Click on the triangle arrow of the filter part and choose Create Connection.

photo4

4. You will be presented with the Connection window as below. On the Items tab, choose the scorecard name for Send values to

photo5

5. Then click on the Values tab. Choose the dropdown values as shown below. Click OK.

photo6

6. Save and Publish the dashboard.

7. Access the dashboard. The dashboard with filter will look like below.

photo7                                          photo8

SharePoint as Enterprise Content Management (ECM)

1. http://technet.microsoft.com/en-us/sharepoint/hh126808.aspx

2. http://blogs.msdn.com/b/ecm/

3. http://www.cmswire.com/cms/information-management/sharepoint-2010-enterprise-content-management-for-the-masses-015770.php

4. http://blogs.technet.com/b/tothesharepoint/archive/2011/08/01/new-sharepoint-training-courses-enterprise-content-management-and-web-content-management.aspx

5. http://gilbane.com/whitepapers/Knowledge_Lake/knowledge_lake_white_paper_final.pdf

6. http://www.aiim.org/community/blogs/expert/Is-SharePoint-2010-Really-Ready-for-ECM

7. http://blog.hollygroup.com/2011/06/expectations-for-sharepoint-ecm-be.html

8. http://redmondmag.com/articles/2012/04/01/sharepoint-takes-a-bigger-piece-of-the-ecm-pie.aspx

9. http://www.colligo.com/blog/sharepoint/7-things-you-need-to-know-about-ecm-in-sharepoint%E2%80%93part-1/

StepsToCreateKPI

Just realized that I can upload a pdf document directly. Much easier that writing a post here with many pictures.

Click on this link --> StepsToCreateKPI  to read the article in pdf format.

SharePoint Governance Notes

Links
1. http://www.sharepointgovernance.org/default.aspx
2. http://technet.microsoft.com/en-us/sharepoint/ff800826.aspx
3. http://technet.microsoft.com/en-us/library/cc263356.aspx
4. http://www.axceler.com/solutions/sharepoint-solutions/sharepoint-governance/index
5. http://www.cmswire.com/cms/information-management/sharepoint-governance-needed-now-more-than-ever-017199.php
6. http://www.cmswire.com/cms/information-management/thriving-in-a-state-of-sharepoint-governance-015127.php
7. http://dlairman.wordpress.com/2011/06/08/sharepoint-governance-why/
8. http://communities.quest.com/community/sharepointforall/experts-blogs/blog/2012/08/21/what-do-sharepoint-2013-sharepoint-governance-have-in-common-read-a-tech-brief-to-find-out
9. http://www.rharbridge.com/?p=752

Videos

http://technet.microsoft.com/en-us/video/tdbe12-sharepoint-governance-part1-scalability-governance.aspx

http://technet.microsoft.com/en-us/video/tdbe12-sharepoint-governance-part2-automating.aspx

Wednesday, March 27, 2013

Key Limitations of Using PerformancePoint Services

This is true for both SharePoint 2010 and SharePoint 2013 when we are creating analytical charts, :-
i. We are limited to the type of charts that can be created in PPS


ii. We are not able to perform further customization or “touch ups” such as changing colors and adding descriptions to the axis. Everything is automatically generated and cannot be modified.


iii. Analytical charts can only be created if we use MS SQL Server Analysis Services as the data source.


iv. Details are not displayed on the chart. You have to hover over the sections. However you will not be able to see complete details at on glance.


PieChart

Monday, March 11, 2013

Dashboard Designer 2013 Issue - Authentication Error

I got this error when trying to create a PerformancePoint item in SharePoint 2013.

" The remote server returned an error: (401) Unauthorized."

DD_Error1Capture

and this post (workaround) saved my day :-).

http://social.msdn.microsoft.com/Forums/sk-SK/sharepointgeneralprevious/thread/90cb879e-1323-4e70-a2fc-1c45d6b0a756