Applies ToDuet Enterprise for Microsoft SharePoint and SAP Server 2.0

The Aggregated Business Calendar Web Part enables you to work with multiple calendars at the same time. The Aggregated Business Calendar Web Part lets you add up to four different calendars of any of the following types: SharePoint calendar, Exchange calendar, SAP calendar, and custom calendar. For example, a site owner can add two SharePoint calendars, one Exchange calendar, and one SAP Business calendar, or four SAP Business calendars. Any combination of these calendar types is supported. To have these calendars aggregated into one place helps you avoid switching between different calendars, and you can easily compare schedules and avoid schedule conflicts.

Your SharePoint farm administer must prepare the Exchange and SAP calendar data sources before you can add Exchange and SAP Business calendars to the Aggregated Business Calendar Web Part. Verify that the SharePoint farm administrator has prepared the required data sources. For more information, see Prepare calendar data sources for the Aggregated Business Calendar Web Part in Duet Enterprise 2.0.

Note:  This document does not describe how to add a Custom calendar to the Aggregated Business Calendar Web Part.

In this article

Activate the Aggregated Business Calendar feature

You must activate the Aggregated Business Calendar feature at the site collection-level before the Aggregated Business Calendar Web Part can be used in a site.

Note:  To activate the Aggregated Business Calendar feature, you must be a site collection administrator.

To activate the Aggregated Business Calendar feature, follow these steps:

  1. Go to the site on which you want to use the Aggregated Business Calendar Web Part.

  2. Click the Settings icon, and then click Site Settings.

  3. On the Site Settings page, in the Site Collection Administration section, click Site collection features.

    Note:  Ensure that you are on the top level Site Settings page when you perform this step. Otherwise, you must click Go to top level site settings.

  4. On the Features page, in the Aggregated Business Calendar row, click Activate.

Add the Aggregated Business Calendar Web Part to a site

This procedure describes how to add an Aggregated Business Calendar Web Part to a page on a web site in the site collection on which you activated the Aggregated Business Calendar feature. You can reuse this list.

You can add only one Aggregated Business Calendar Web Part per page on a SharePoint site.

Before you perform this procedure, ensure that you have activated the Aggregated Business Calendar feature.

Note:  To add an Aggregated Business Calendar Web Part to a page on a SharePoint site, you must have the Contribute or Design permission level on the site. By default, members of the site Owners group have these permission levels.

To add an Aggregated Business Calendar Web Part to a page on a SharePoint site, follow these steps:

  1. Go to a page on a SharePoint site on which you want to add the Aggregated Business Calendar Web Part.

  2. Click PAGE tab and then click Edit.

  3. Position the cursor in the area of the page where you want to add the Web Part.

  4. On the on the Insert tab, in the Parts group on the ribbon, click Web Part.

  5. In the Categories pane, click Duet Enterprise.

  6. In the Parts pane, click Aggregated Business Calendar, and then click Add.You can now see the Aggregated Business Calendar Web Part on the site.

  7. Click the Edit tab in the ribbon and then click Save.

    Note:  An Invalid configuration message appears in the Aggregated Business Calendar Web Part because you have not yet configured a calendar for this Aggregated Business Calendar Web Part. So before you can use the Aggregated Business Calendar Web Part, you must add a calendar to it.

Add calendars to the Aggregated Business Calendar Web Part

To start using the Aggregated Business Calendar Web Part, you must first add at least one calendar—a SharePoint calendar, an Exchange calendar, or an SAP Business calendar—to the Aggregated Business Calendar Web Part.

The Aggregated Business Calendar Web Part loads calendars synchronously. This means that the Web Part loads all items from all calendars (data sources) that you add before the Web Part displays any calendar items. In addition, other Web Parts that you may have added to the same page will not load until all calendars are loaded. This means that users might experience a delay before the page is rendered.

In this section:

Add a SharePoint calendar

Before you add a SharePoint calendar to an Aggregated Business Calendar Web Part, the SharePoint calendar that you want to add must exist in the same site as the Aggregated Business Calendar Web Part. If it does not, the SharePoint calendar will not be available to add to the Aggregated Business Calendar Web Part. If you already have a SharePoint calendar, skip to the Add a SharePoint calendar procedure. Otherwise, go to the Create a SharePoint calendar procedure.

Create a SharePoint calendar

Follow this procedure to create a SharePoint calendar. Ensure that you create the SharePoint calendar in the same site as the Aggregated Business Calendar Web Part.

Note:  To create a SharePoint calendar, you must have the Contribute or Design permission level on the site. By default, members of the site Owners group have these permission levels.

To create a SharePoint calendar, follow these steps:

  1. Click the Settings icon and then click Add an app.

  2. In the Apps you can add section, click Calendar.

  3. In the Adding Calendar dialog box, click Advanced Options.

  4. In the Name box, type a name for the SharePoint calendar. The calendar name is required.The name appears at the top of the calendar page, becomes part of the web address for the calendar page, and appears in navigational elements that help users find and open the calendar.

  5. In the Description box, optionally type a description of the purpose of the calendar.

  6. To share the calendar with other users, click Yes in the Group Calendar Options section.

  7. Click Create.The calendar appears.

Add a SharePoint calendar

After you verify that the SharePoint calendar that you want to add exists in the same site in which the Aggregated Business Calendar Web Part is located, you can add the SharePoint calendar to the Aggregated Business Calendar Web Part.

Note:  Because you can add one or more SharePoint calendars to the Aggregated Business Calendar Web Part, ensure that you add properties, such as color, to the SharePoint calendar that you select to differentiate it from the other calendars that you might have.

Note:  To add a SharePoint calendar to an Aggregated Business Calendar Web Part, you must have the “Edit Items” list permission on the site. By default, members of the site Owners group have this permission.

Note:  All Users who open an aggregated business calendar can view all calendar entries for a SharePoint group calendar if they have permissions to view the source calendar. The user does not need to be the owner of the calendar entry or listed as attendee of the entry.

To add a SharePoint calendar to the Aggregated Business Calendar Web Part, follow these steps:

  1. On the page of a SharePoint site where the Aggregated Business Calendar Web Part is located, click the PAGE tab in the ribbon, and then click Edit.

  2. Select the check box in the Aggregated Business Calendar Web Part.

  3. On the ribbon, click the WEB PART tab, and then click Web Part Properties.

  4. In the Add Business Calendars for overlay section, click the drop-down arrow, select SharePoint calendar, and then click Add.

  5. In the Calendar Type section, do the following:

  6. In the Title box, type the title of the calendar as you want it to appear on the Aggregated Business Calendar Web Part.

  7. In the Description box, optionally type a description of the calendar.

  8. In the Color drop-down list, select the color that you want the SharePoint calendar entries to have on the Aggregated Business Calendar Web Part.

  9. In the Available SharePoint Calendars drop-down list, select the calendar that you want to add. NOTE Only calendars that are in the same site appear in this drop-down list.

  10. In the Available Views drop-down list, select the view that you want to use for the calendar. NOTE Only public views can be selected.

  11. Click Save to add the SharePoint calendar and then click OK.You can now see the SharePoint calendar in the Aggregated Business Calendar Web Part. You can add, view, edit, and delete SharePoint calendar entries on the Aggregated Business Calendar Web Part.

Add an Exchange calendar

Before you can add an Exchange calendar to the Aggregated Business Calendar Web Part, a member of the Farm Administrators group must establish a trust relationship between the SharePoint Server farm and the server running Microsoft Exchange Server. For more information, see Prepare calendar data sources for the Aggregated Business Calendar Web Part in Duet Enterprise 2.0.

Also, an owner of the Exchange calendar must configure the relevant permissions on the Exchange calendar. The following procedures describe how to configure permissions on an Exchange calendar, and then how to add an Exchange calendar to the Aggregated Business Calendar Web Part.

Configure permissions on an Exchange calendar

By default, an Exchange calendar displays only free and busy information to users other than the owner of the calendar. The Exchange calendar owner can configure permissions on the Exchange calendar to allow the calendar to display other details, such as the subject line and location information.

Note:  To configure the permissions on the Exchange calendar, you must be an owner of the Exchange calendar.

To configure the permissions on the Exchange calendar, follow these steps:

  1. Log on to a computer on which Microsoft Outlook 2013 has been installed, and then connect to the calendar on which you want to configure permissions.

  2. Start Outlook 2013.

  3. Click Calendar.

  4. In the left-hand navigation pane, expand My Calendars, and select the check box for the calendar on which you want to set permissions.

  5. Right-click the calendar, and then click Properties.

  6. In the Calendar Properties dialog box, click the Permissions tab.

  7. In the Permission Level box, click the default user type in the list, and then select the permissions that you want.NOTE You can add other permissions, but some permission levels are public and can be seen by other users.

  8. Click OK.

Add an Exchange calendar

After you configure permissions on the Exchange calendar, you can add the Exchange calendar to the Aggregated Business Calendar Web Part.

Note:  Because you can add one or more calendars to the Aggregated Business Calendar Web Part, ensure that you add properties, such as color, to the Exchange calendar that you select to differentiate it from the other calendars that you might have.

Note:  To add an Exchange calendar to an Aggregated Business Calendar Web Part, you must have the “Edit Items” list permission on the site. By default, members of the site Owners group have this permission.

To add an Exchange calendar to the Aggregated Business Calendar Web Part, follow these steps:

  1. On the page of a SharePoint site where your Aggregated Business Calendar Web Part is located, click the PAGE tab in the ribbon, and then click Edit.

  2. Select the check box in the Aggregated Business Calendar Web Part.

  3. On the ribbon, click the WEB PART tab, and then click Web Part Properties.

  4. In the Add Business Calendars for overlay section, click the drop-down arrow, select the Exchange calendar, and then click Add.

  5. In the Calendar Type section, do the following:

  6. In the Title box, type the title of the calendar as you want it to appear on the Aggregated Business Calendar Web Part.

  7. In the Description box, type a description of the calendar.

  8. In the Color list, select the color that you want the Exchange calendar entries to have.

  9. In the Exchange Web Service URL box, type the URL of the Exchange Web service.This is the location of your Exchange server and from where the Aggregated Business Calendar Web part gets the Exchange calendar items.

  10. Click Test link to confirm that the link works.

  11. If want to access your Exchange calendar by adding a link to it in the Aggregated Business Calendar Web Part, type the Outlook Web Access (OWA) URL in the Outlook Web Access URL box.

  12. Click Save, and then click OK.You can now see the Exchange calendar in your Aggregated Business Calendar Web Part. You can only view—not add, edit, or delete—Exchange calendar entries in the Aggregated Business Calendar Web Part.

Add an SAP Business calendar

Before you can add an SAP Business calendar to your Aggregated Business Calendar Web Part, a member of the Farm Administrators group must import and grant permissions to the TimeEntry BDC model. For more information, see Prepare calendar data sources for the Aggregated Business Calendar Web Part in Duet Enterprise 2.0.

Because SharePoint Server cannot access data directly from an SAP Business calendar, you must create an external list in SharePoint Server. The data from the SAP Business calendar can then be imported to this external list. When you add the SAP Business calendar to the Aggregated Business Calendar Web Part, the external list becomes associated with the Aggregated Business Calendar Web Part.

Note:  The TimeEntry BDC model is included with Duet Enterprise 2.0 and is designed to be used with SAP time data. In addition, the Aggregated Business Calendar Web Part can be used with data sources such as leave requests and so on. To use the Aggregated Business Calendar Web Part with other data sources, the farm administrator must import and grant permissions to the BDC model that is designed to be used with SAP time management data and tell you the name of the external content type that is used in the BDC model. Then, you can create an external list just as you would with the TimeEntry BDC model.

Create an external list

To add an SAP Business calendar, you must first create an external list in SharePoint Server. Ensure that you create the external list in the same site in which the Aggregated Business Calendar Web Part is located.

Note:  To create an external list, you must be a member of the site Owners group, a site collection administrator, or a member of the Farm Administrator group. You must also have the "Selectable in clients" permission on the external content type.

To create an external list, follow these steps:

  1. Go to the site where the Aggregated Business Calendar Web Part is located.

  2. Click the Settings icon and then click Add an app.

  3. On the Your apps page, in the Apps you can add section, click External List.

  4. On the Adding External List dialog box, in the Name text box, type a name for the external list as you want it to appear throughout the site.

  5. In the Data source configuration section, click the Select External Content Type icon.

  6. In the External Content Type Picker dialog box, in the External Data Source column, click Time and then click OK.NOTE Time is the external data source, and TimeEntry is the external content type that is included in the Time BDC model. Note that the display name for this BDC model is TimeEntry, by default.

  7. Click Create.

Add an SAP Business calendar

After you create the external list, you can add the SAP Business calendar to the Aggregated Business Calendar Web Part.

Note:  Because you can add one or more SAP Business calendars to the Aggregated Business Calendar Web Part, ensure that you add properties, such as color, to the SAP Business calendar that you select to differentiate it from the other calendars that you might have.

Note:  To add an SAP Business calendar to an Aggregated Business Calendar Web Part, you must have the “Edit Items” list permission on the site. By default, members of the site Owners group have this permission.

To add an SAP Business calendar, follow these steps:

  1. On the page of a SharePoint site where the Aggregated Business Calendar Web Part is located, click the PAGE tab in the ribbon, and then click Edit.

  2. Select the check box in the Aggregated Business Calendar Web Part.

  3. On the ribbon, click the WEB PART tab, and then click Web Part Properties.

  4. In the Add Business Calendars for overlay section, click the drop-down arrow, click Business calendar, and then click Add.

  5. In the Calendar Type section, do the following:

    1. In the Title box, type the title of the calendar as you want it to appear on the Aggregated Business Calendar Web Part site.

    2. In the Description box, optionally type a description of the calendar.

    3. In the Color drop-down list, select the color that you want the SAP Business calendar entries to have.

    4. In the Available Business Calendars drop-down list, select the external list that you created in the Create an external list procedure for this calendar. Note that only external lists that can be used with the Aggregated Business Calendar Web Part are displayed.

    5. In the Available Views drop-down list, select the view that you want to use for this calendar.NOTE Only public calendar views are available. Other types of views such as standard view and Gantt View are not available.

  6. Click Save, and then click OK.You can now see the SAP Business calendar in the Aggregated Business Calendar Web Part. You can add, view, edit, and delete SAP Business calendar entries on the Aggregated Business Calendar Web Part.

Delete a calendar from the Aggregated Business Calendar Web Part

You might want to delete a calendar from the Aggregated Business Calendar Web Part, for example, if you do not need it anymore, or if you already have four calendars and want to replace one with another calendar.

Note:  To delete a calendar from the Aggregated Business Calendar Web Part, you must have the “Edit Items” list permission on the site. By default, members of the site Owners group have this permission.

To delete a calendar from the Aggregated Business Calendar Web Part, follow these steps:

  1. On the site where your Aggregated Business Calendar Web Part is located, click the PAGE tab in the ribbon, and then click Edit.

  2. Select the check box in the Aggregated Business Calendar Web Part.

  3. On the ribbon, click the WEB PART tab, and then click Web Part Properties.

  4. In the Business Calendars section, in the Title column, click the calendar that you want to delete.

  5. Click Delete to delete the calendar and then click OK.

Edit a calendar in the Aggregated Business Calendar Web Part

You might want to edit a calendar that has been added to the Aggregated Business Calendar Web Part.

To edit a calendar that has been added to the Aggregated Business Calendar Web Part, follow these steps.

Note:  You cannot change the calendar type after it has been added to the Aggregated Business Calendar Web Part. For example, you cannot change an Exchange calendar to an SAP Business calendar. If you no longer need a particular calendar in the Web Part, remove it from the Web Part and add the calendar that you want.

  1. On the site where your Aggregated Business Calendar Web Part is located, click the PAGE tab in the ribbon, and then click Edit.

  2. Select the check box in the Aggregated Business Calendar Web Part.

  3. On the ribbon, click the WEB PART tab, and then click Web Part Properties.

  4. In the Business Calendars section, in the Title column, click the calendar that you want to edit.

  5. In the Calendar Type section, do any of the following:

  6. In the Title box, type a new title for the calendar.

  7. In the Description box, add or edit the existing description for the calendar.

  8. Select a different color for this calendar from the Color drop-down list.

  9. Select a different calendar from the list of available calendars.

  10. Select a different view from the Available Views list.

  11. Click Save, and then click OK.

Add and manage calendar entries

These sections describe how to add and manage calendar entries in the Aggregated Business Calendar Web Part. Users can use this Web Part to manage calendar entries in the calendars that have been added to the Web Part, if they satisfy one or more of the following conditions:

  • Have permissions to access the site that contains the Aggregated Business Calendar Web Part.

  • Have permissions to add and manage calendar entries on the calendars that have been added to the Web Part.

The color that administrators gave a calendar when they first added it identifies the different calendars in an Aggregated Business Calendar Web Part. Also, the name that administrators gave each calendar appears next to a check box in the Aggregated Business Calendar Web Part. These check boxes are selected by default. You can access each separate calendar by clicking it.

The Day, Week (default), and Month commands enable you to choose the number of days that are displayed in the Aggregated Business Calendar Web Part. The Day view shows one day at a time, the Week view displays the complete seven day week, and the Month view displays the current calendar month. To move to the next or previous day, week, or month, you can use the Back and Forward navigation buttons.

If you have multiple entries on the same day in the Aggregated Business Calendar Web Part, you can use the Expand All and Collapse All commands to view or hide these entries.

By clicking the small arrow in the top-right corner of the Aggregated Business Calendar Web Part, you can minimize, close, edit, or export the Aggregated Business Calendar Web Part.

Note:  You cannot add, edit, or delete an Exchange calendar entry in the Aggregated Business Calendar Web Part.

The procedures in this section describe how to add, view, edit, delete, and save/refresh calendar entries in the Aggregated Business Calendar Web Part.

Before you perform these procedures, you must have added at least one calendar to your Aggregated Business Calendar Web Part.

In this section:

Add a SharePoint calendar entry

To add a SharePoint calendar entry, follow these steps:

  1. On the site where the Aggregated Business Calendar Web Part is located, click in the Aggregated Business Calendar Web Part.

  2. On the ribbon, on the AGGREGATED BUSINESS CALENDAR tab, click New Event, and then click <calendar> Event where <calendar> is the title of the calendar as it appears in the Aggregated Business Calendar Web Part.

  3. Enter the following information in the New Item dialog box:

  4. In the Title box, type the name of the event.

  5. In the Location box, type where the event takes place.

  6. In the Start Time box, type the date when the event starts.

  7. In the End Time box, type the date when the event ends.

  8. In the Description box, type a description of the event.

  9. In the Category section, select the default value, or specify your own value.

  10. If you want to make this event an all-day activity, select the check box in the All Day Event section.

  11. If you want to make this event a recurring event, select the check box in the Recurrence section.

  12. Click Save.

You might need to click Save/Refresh on the ribbon to see the entry in the Aggregated Business Calendar Web Part.

Add an SAP Business calendar entry

To add an SAP Business calendar entry, follow these steps:

Note:  When you create a calendar entry, some fields might be automatically populated from the context of the selected calendar. For example, Start time, End time, Subject line, or location.

  1. On the site where the Aggregated Business Calendar Web Part is located, click in the Aggregated Business Calendar Web Part.

  2. On the ribbon, on the AGGREGATED BUSINESS CALENDAR tab, click New Event, and then click <calendar> Event where <calendar> is the title of the calendar as it appears in the Aggregated Business Calendar Web Part.

  3. Type information in the relevant boxes.

  4. Click Save.

You might need to click Save/Refresh on the ribbon to see the entry in the Aggregated Business Calendar Web Part.

View a calendar entry

To view a calendar entry, on the site where the Aggregated Business Calendar Web Part is located, do one of the following:

  • Click the calendar entry that you want to view and in the AGGREGATED BUSINESS CALENDAR tab group of the ribbon, click View Event.

  • Click the link in the calendar entry.

Note:  Different options are available in the Aggregated Business Calendar depending on which calendar entry that you are viewing. For example, for a SharePoint calendar entry, you can edit, view, and delete an entry, view version history, manage permissions, and create an alert. For an SAP Business calendar entry, you can delete and edit an entry. However, entries from an Exchange calendar can only be viewed.

Tip:  When you view an entry from an Exchange calendar that has been configured by using an Outlook Web Access connection, the following error might be displayed: “Page context missing. Please open the page from the correct Aggregated Business Calendar Web Part context.” This can occur if the Subject field or Location field of the calendar entry contains the text string “OBA::”. For example, the subject line “SHOBA::shareholders meeting” can cause this error. To resolve the error, use an email application, such as Microsoft Outlook, or use a browser to access the Outlook Web Access URL and remove the text string “OBA::” from the Subject field or Location field of the calendar entry.

Edit a calendar entry

To edit a calendar entry, follow these steps:

  1. On the site where the Aggregated Business Calendar Web Part is located, click the calendar entry that you want to edit.

  2. In the AGGREGATED BUSINESS CALENDAR tab of the ribbon, click Edit Event.

  3. In your entry, make changes, and then click Save.The changes are updated in the Aggregated Business Calendar Web Part.

    Note:  The Title, Start Time, and End Time are required fields. You cannot edit an Exchange calendar entry in the Aggregated Business Calendar Web Part.

Delete a calendar entry

To delete a calendar entry, follow these steps:

  1. On the site where the Aggregated Business Calendar Web Part is located, click the calendar entry that you want to delete.

  2. In the AGGREGATED BUSINESS CALENDAR tab of the ribbon, click Delete Event.

  3. In the dialog box that appears, click OK.

Save/Refresh a calendar

You primarily use the Save/Refresh option to select and deselect the calendars that you want to view in the Aggregated Business Calendar Web Part. Note that this option works in public view only.

To save or refresh a calendar entry, follow these steps:

  1. On the site where the Aggregated Business Calendar Web Part is located, select the calendars that you want to view or deselect the calendars that you do not want to view.

  2. On the ribbon, click the AGGREGATED BUSINESS CALENDAR tab, and then click Save/Refresh.This saves your preferences and also refreshes the Aggregated Business Calendar Web Part to reflect your changes.

Facebook LinkedIn Email

Need more help?

Want more options?

Discover Community

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Ask the Microsoft Community

Microsoft Tech Community

Windows Insiders

Microsoft 365 Insiders