MOSS

Load Testing Excel Services Report – Deriving Query String Parameters sr and wb

 LoadTest

Visual Studio Team System (VSTS) Test Edition is a valuable tool to load test web applications. This post is about using VSTS Test Edition to load test SharePoint Excel Services report. In particular, I explain the solution to handle session time-out issues encountered with Excel Services web test that could invalidate the load test. Continue Reading

Using Page Viewer Web Part to Display Reporting Services Reports in SharePoint

report

Page Viewer is an out-of-box SharePoint web part that functions as a placeholder for web pages, folders and files that reside usually outside the SharePoint environment. One such use of Page Viewer is to display a Reporting Service report which is not integrated with SharePoint. This means with a little bit on tinkering Page Viewer can be effectively converted into a Report Viewer.  Continue Reading

Avoid Commas in FBA Roles and Members

When implementing Form Based Authentication (FBA) for SharePoint sites, ensure that your role members and role names do not have commas in them. A comma in any role member attribute or in role name, throws “Error: Access Denied” exception. Continue Reading

Getting rid of error message “You do not have permissions to open this file on Excel Services. Make sure that the file is in an Excel Services trusted location and that you have access to the file” in Microsoft Office SharePoint Server (MOSS)

Have you encountered this error message when opening an Excel Service Report in Microsoft Office SharePoint Server (MOSS)?
“You do not have permissions to open this file on Excel Services. Make sure that the file is in an Excel Services trusted location and that you have access to the file.”
 Continue Reading

Re-sizing Web Zone in SharePoint Dashboards

A SharePoint Dashboard is a web page made up of web parts. Web Parts exist within containers called Web Zone. In SharePoint, while the properties of the web part are exposed to the Dashboard Designer, the web zone is virtually untouchable. Often Dashboard Designers find it annoying to discover that their web part is either too big (leaving ugly scroll bars) or too small (leaving empty space) for the web zone and they are not able to modify the dimensions of the web zone. Continue Reading

Comparison of KPI Types in SharePoint Server 2007

SharePoint Server 2007 offers five different methods to create Key Performance Indicators (KPIs) 

  1. Using data from published Microsoft Excel 2007 spreadsheet.
  2. Using KPIs defined in SQL Analysis Service Cube.
  3. Using dashboard created in PerformancePoint 2007.
  4. Using data from SharePoint list.
  5. Using manual data entry.

This post compares the relative merits of methods 1-3 and suggests scenarios where a particular method is suitable over others. Continue Reading …