New page in Report Center

You are creating a new SharePoint site. The new site will use the Report Center template. A new page needs to be created in the Report Center. The new page contains the following web parts:

• Excel Web Access
• Key Performance Indicators
• KPI Details

You would accomplish this task by creating a new dashboard page in the Report Center.

Report Center template

A new site needs to be created. The site needs to have:

• A built-in key performance indicators (KPI) list
• A built-in data connections library
• A built-in reference library

The Report Center template would be used for creating the new site.

New content not showing up in search results

I had users reporting that new content was not showing up in the search results. The search is being performed from the root of the SharePoint 2007 site. After doing some research, I determined I needed to reset the crawled content and start a full crawl. Here are the steps I performed to start a new, full crawl.

1. In Central Administration, click on Application Management.

2. Under the Office SharePoint Server Shared Services, click on Create or configure this farm’s shared services.

3. Click in the SSP that you want to open.

4. Under the Search area, clic on Search settings.

5. Click on the Reset all crawled content in the Crawl Settings section.

6. A new screen will appear called Reset Crawled Content. Click on the Reset Now button.

7. Click OK on the pop-up window “Are you sure you want to reset the search content index?“

Extend user profiles

I needed to extend the user profile to include a propery frm the Active Directory. I created a new user profile property with the following steps:

1. In Central Administration, click on Application Management.

2. Under Office SharePoint Server Shared Services section, click on Create or configure this farm’s shared services

3. Click on the SSP you are wanting to add the user profile to.

4. Under the User Profiles and My Sites section, click on User profiles and properties.

5. Under the User Profile Properties section, click on Add profile property

6. Complete the Add User Profile Property page and click OK when finished.

Migrating from MCMS to MOSS

If you are planning on migrating from Microsoft Content Management Server (MCMS) 2002 to Microsoft Office SharePoint Server (MOSS) 2007. You need to use the CMS Accessment tool to indentify the migration tasks.

The Microsoft CMS Assessment tool is an application that collects data for a site created with MCMS. This tool will determine the level of work required to migrate to MOSS. More information on the CMS Assessment tool can be found here

Application definition file

A new application was created using MS SQL 2005. In the database is data that you want to use with a Business Data List Web pare. You will need to create an application definition file to support this configuration. After the file has been created, you will need to install the file.

To create an application definition file:

1. Click Operations on the Central Administration pagge.

2. Under the Security Configuration section, click on Manage settings for single sign-on.

3. On the Manage Settings for Single Sign-On page, click Manage settings for enterprise application definitions

4. On the Manage Enterprise Application Definitions page, click New Item.

5. On the Create Enterprise Application Definition page, in the Application and Contact Information section, in the Display name box, type the name that is displayed to users.

6. In the Application name box, type the name that Web Parts uses to call the enterprise application definition.

7. Single sign-on components use the application name to specify which enterprise application definition to use.

8. In the Contact e-mail address box, type the e-mail address that users can contact for the enterprise application.

9. In the Account type section, select one of the following:

• Group. Select this option if users will connect to the enterprise application through a group account. If you select this option, you need to configure account information for the application definition.
• Individual. Select this option if each user has an account in the application definition.
• Group using restricted account. Select this option if users will connect to the enterprise application through a group that uses a restricted account. If you select this option, credentials are stored separately for regular credentials and a different API is used to access the credentials. Select this option only when all of the following is true:
  The account is a group account.
  An intermediary application such as Business Data Catalog imposes further security restrictions.
  The data is highly sensitive.

10. In the Authentication type section, select the Windows authentication check box.

• Warning  If Windows authentication is not used, the logon credentials are not encrypted.

11. In the Logon Account Information section, configure each of the Field boxes for soliciting required logon information from users. Selecting Yes for Mask hides the text typed by the user. This helps to keep sensitive information such as passwords secret.

12. Click OK.

Excel services trusted file location

I have an Excel file stored on an external web site. The web site has anonymous authenication enables. When a user tries to access the Excel file, an access denies error shows up. Adding a new Excel Services trusted file location will make sure the Excel file is available with Excel Services.

Steps to configure trusted file locations for Excel Services:

1. Open the Shared Services Administration site and select Trusted file locations under Excel Services Settings.

2. Click Add Trusted File Location to add a new Excel file location that is trustworthy.

Step 1 Location

1. In the Address field, enter the address of the of the trusted location
2. In the Location Type field, select the storage type
3. In the Children trusted under Trusted Children, enter the url
4. In the Description field, provide a description of this trusted location

Step 2 Session Management

1. In the Session Timeout field, specify the maximum time in seconds that an Excel Calculation Services session can remain open
2. In the Short Session Timeout field, specify the maximum time in seconds than an Excel Web Access session can remain open
3. In the Maximum Request Duration field, specify the maximum duration in seconds of a single request in a session.

Step 3 Workbook Properties

1. In the Maximum Workbook Size field, specify the maximum size of a workbook that can be opened by Excel Calculation Services session
2. In the Maximum Chart Size fields, specify the maximum chart size that can be opened by Excel Calculation Services.

For the rest of the steps, click here.

Web part text filter

A list view web part names Customers shows customer names. Another web part needs to be added so the users can manually enter filter values on the Customers web part. The Text Filter web part will allow the users to enter values.

Business Data Catalog application queries SQL 2005

You have createda BDC (Business Data Catalog) app tha will query a SQL 2005 database. Content from the results that is exposed through the BDC is not available in search results. The data needs to be availble to the searched. What need to be done to correct this?

Configure a default access account for the Business Data Catalog application.