Blog Posts
- Lists vs InfoPath vs Excel vs Access – Jun 2011
- Configure PerformancePoint and Excel Services – Oct 2010
- PerformancePoint: A brief history – Oct 2010
- Introducing Microsoft PowerPivot – Oct 2009
- Excel for visualising data – May 2008
- Excel Web Access 101 – May 2008
Lists and Libraries
- How to create External Lists and include databases using SharePoint Designer 2010 – Bamboo Nation, May 2011
- Formulas and functions for use in calculated columns – Microsoft Office Support
- How to hide the workspace column from Event content type – Kim Frehe, Oct 2011
Business Connectivity Services
- How to create and configure the BCS – Marco Cadario, Jan 2011
- Business Connectivity Service Administration Overview – TechNet, May 2010
- Business Connectivity Service Security operations – TechNet, Oct 2010
- How to connect to an Oracle database – MSDN
- Discussion on connected to Oracle databases – Techarena Forum
- Create an External Content Type for a SQL table – MSDN, May 2010
- External List Limitations – SharePointAnalyst, Jul 2010
Access Web Services
Links
- Build an Access database to share on the web – Office help (useful overview)
- How to create web databases with Access 2010 and Access Services (simple getting started) – MSDN, Feb 2010
- SharePoint 2010 and Access Services’ Place – Robert L Bogue, Jan 2010
- Thoughts on Access Services in SharePoint 2010 – WorkerThread blog, Jan 2010
- Access 2010 Web Databases: Creating Relationships (learn to love Lookups) – Roger’s Access Library, May 2010
- The 10 commandments of Access (you’ll have to ignore some for web dbs) – Access MVPs
- SQL Data types (listed for Access, MySQL and SQL Server) -
- Limits and capabilities of Access web databases – Access programmers forum (great discussion on what can be done and cautioning against wanting them to be something they’re not).
Features
- Understanding the Issues Template (DB set-up details incl. macros) – MSDN, Jan 2011
- Access 2010: How to write expressions for web queries, forms and reports – Access blog, Jan 2010
- Creating web databases with Access 2010 and Access Services – MSDN (notes on features available)
- Query examples (Access 2007) – Office support
- Access Developer Forum on MSDN
Quick Tips
- If creating from scratch, use the Access Web Database template
- Learn to like ‘Lookup & Relationships’ field types. Can’t do table joins
- Use ‘Like’ operator to do Contains filters
- Don’t forget to set default web form (File – Options – Current Db) before publishing to SharePoint
- If creating calculated fields in queries, must be on subform (even if hidden) for search filters that use them to work
- Method for doing a text search filter on lists:
- Create a field that combines all values to search across, e.g. allNames: [Firstname] & ” ” & [Lastname] & [Preferred]
- Include it in the form containing records (e.g. datasheet form) but hidden
- Create main form with text box ‘txtFilter’, add records as subform. Name the subform ‘subForm’
- Macro for txtFilter:
- SetTempVar (tmpFilter, txtFilter])
- SetFilter
Where Condition: = [allNames] Like “*” & [TempVars]![tmpFilter] & “*”
Control Name: subForm
PerformancePoint Service
As from SharePoint Server 2010, PerformancePoint is part of the Enterprise Edition and is now known as PerformancePoint Services. It is no longer available as a separate product. Former names are Business Scorecard Manager 2005 and PerformancePoint Server 2007.
See the Data Services page for data connections and supporting services.
Snippets
To display a different master page for a dashboard (e.g. to eliminate navigation – see how under Themes and Branding), define the master page within the dashboard in Dashboard Designer and then deploy to SharePoint. Each dashboard can be branded with its own master page.
Blog Posts
- Configure PerformancePoint and Excel Services – Oct 2010
- PerformancePoint: A brief history – Oct 2010
Useful links
- New features in PerformancePoint Services 2010 – MSDN blog, Nov 2009
- Deploying PerformancePoint – MSDN blog, Nov 2009
- Data source authentication – MS PPS team blog, May 2010
- Analytic charts and grids – MS PPS team blog, Mar 2010
- Upgrading Performance Point Server 2007 to PPS 2010 – MS PPS team blog, Feb 2010
- Getting started with SharePoint site usage stats – ShareMuch, Dec 2010
Blogs
- PerformancePoint Services team blog – MSDN blog
- Jason Morales’ MS BI Update – MSDN blog
- Insufficient Data (Andrew Fryer) – TechNet blog
- SQL Server BI Blog – Paul Turley, MVP
- BI-Lingual – Nick Barclay
- BI Blog – Dan English
- Dynamics Corporate Performance Management – MSDN blog