Self-service portlet data sources

This topic describes how to create and maintain self-service portlet data sources.

In this topic:

Create self-service portlet data sources

You can only create self-service portlet data sources from dashboard data sources. Dashboard data sources provide the data and filters for self-service portlet data sources.

To create a self-service portlet data source:

1. Prerequisite: You must have the System: Manage Self-Service Portlet Data Sources access grant.

2. From the menu bar, click Open > Administration > Portlet Definitions > Manage Self-Service Portlet Data Sources.

   The Self-Service Portlet Data Source Management page opens.

   The predefined self-service portlet data sources, Financial Costs and Portfolio Items, are already listed on this page. For details about these data sources, see PPM supplied self-service portlet data sources.

3. Click Create in the upper right corner.

4. In the Create Self-Service Portlet Data Source page, provide information for each of the following sections:

   Section	Description
   Information	Provide the following information for the self-service portlet data source: Enabled. If the self-service portlet data source is available for use. SQL Data Source. Select a dashboard data source that provides data and filters for the self-service portlet data source. Choices are limited to the dashboard data sources available on your PPM instance. Name. Provide a name for the self-service portlet data source. Service Name. Use the default value or provide a unique value for the data source service name. Do not use special character or space in the service name. The service name identifies the self-service portlet data source through its URL path. Do not change the name once the data source is in use. Reference Code. Use the default value or provide a new value for the data source reference code.
   Access	Define who can use the self-service portlet data source. Authorized Users. Specify one or more users. Authorized Security Groups. Specify one or more user groups. Authorized Org. Units. Specify one or more org units.
   Columns	Use this section to configure the columns that are displayed on the self-service portlet Edit Preferences page. For details, see Define columns.
   Filters	Use this section to configure the filter fields that are displayed on the self-service portlet Edit Preferences page. This section is only available when the relevant dashboard data source has filters defined. For details, see Define filters.
   OData Link	This section is available only when the Allow Creation of OData Links for Self-Service Portlet Data Sources feature toggle is turned on. For details, see Use feature toggles to turn on/off features. OData Link Enabled. If allow users to create OData links for the self-service portlet data source. For details, see Work with self-service portlet data source OData links. Authorized Users, Authorized Security Groups, Authorized Org. Units. Use these fields to specify who are allowed to create Odata links for the self-service portlet data source.

5. Click Create.

To delete a self-service portlet data source:

1. Open the data source to delete.

2. Click Remove This Data Source at the bottom of the page, and click Yes in the pop-up dialog box.

Back to top

Define columns

This section describes how to define columns when you create a self-service portlet data source.

The self-service portlet data source uses the same columns defined in the relevant dashboard data source. You can use the Columns section of a self-service portlet data source to:

• Define the column names and hyperlinks that appear on the self-service portlet Edit Preferences page.

• Configure which columns are shown on the self-service portlet Edit Preferences page.

Action	Details
Define column information	The Columns Information subsection lists all the columns that are defined in the relevant dashboard data source. Use the following fields to define the column names and hyperlinks that appear on the self-service portlet Edit Preferences page: Custom Column Label. Specify the name of the column. Hyperlink Column. Select a hyperlink for the column.
Configure displayed columns	In the Column Mode field, select a column mode: Show All. Shows all the columns to all the users. No extra steps are required if you select this option. Show All Except. Specifies which columns to hide, and whom they are hidden from. Hide All Except. Specifies which columns to show, and whom they are shown to. Click Add Column and select a column to hide or to show. In the Users, Security Groups, or Org. Units field, specify one or more users or user groups the column is hidden from or shown to. If no users or user groups are specified, the column is hidden from or shown to all the users. Repeat step 2 through 3 to add all the required columns.

Back to top

Define filters

This section describes how to define filters when you create a self-service portlet data source.

The self-service portlet data source uses the same filter fields defined in the relevant dashboard data source. You can use the Filters section of a self-service portlet data source to:

• Customize filter labels that appear on the self-service portlet Edit Preferences page.

• Configure filter settings, such as the default value for a specified field, and if the field is required.

• Configure which filter fields are shown on the self-service portlet Edit Preferences page.

Action	Details
Customize filter labels	The Custom Filter Labels subsection lists all the filter fields that are defined in the relevant dashboard data source. To customize the label of a filter field, enter a label in the Custom Filter Label field.
Configure filter settings	Click Add Filter Settings and select a filter field to configure. Provide the following information for the filter: Default Value. Specify the default value for the filter field. Autofill from Context. Applicable for the fields whose values are entities, users, or resources, such as the Program_ID and User_ID fields. When selected, the filter field is automatically filled with the current entity or logged in user. Hidden. Select the check box to hide the filter field on the Edit Preferences page. Read Only. Select the check box to make the filter field read only on the Edit Preferences page. Required. Select the check box to make the filter field required on the Edit Preferences page. Users/ Security/ Org. Unit. Use these fields to specify one or more users or groups to which the filter settings apply. If no users or groups are specified, the filter settings apply to all the users. Repeat step 1 and step 2 to configure all the required filters.
Configure displayed filters	Specify which filters are shown on the self-service portlet Edit Preferences page. Select a filter mode. Show All. Shows all the filters to all the users. No extra steps are required if you select this option. Show All Except. Specifies which filters to hide, and whom they are hidden from. Hide All Except. Specifies which filters to show, and whom they are shown to. Click Add Filter and select a filter to hide or to show. In the Users, Security Groups, or Org. Units field, specify one or more users or groups the filter is hidden from or shown to. If no users or groups are specified, the filter is hidden from or shown to all the users. Repeat step 2 through 3 to add all the required filters.

Back to top

See also:

• Manage portlet data sources
• Set up self-service portlets