Siebel Performance Management Guide > Setting Up and Administering Performance Scorecard > Creating a KPI Request in Siebel Analytics >
Creating an Employee-Specific KPI Request
Complete the steps in the following procedure to create an employee-specific KPI request. To create an employee-specific KPI request
- Navigate to the Administration - Key Performance Indicators screen and select KPI Analytics Request Administration from the link bar.
You can also log in to Analytics Web as a user with the KPI Administrator responsibility, and click the Marketing link.
- Create a new folder for the KPI by completing the following tasks:
- In the List Formats tab list, scroll down to locate the folders listed under Shared Data Load Format.
- Navigate to ERM/KPI.
If a folder exists that you want to use to save the KPI request, then proceed to Step 3. If not, continue.
NOTE: You may want to save Global KPIs in a different folder than Employee Specific KPIs for organizational purposes.
- Click the Manage Catalog button.
- Navigate to the folder location (ERM/KPIs).
- Click the Create New Folder link.
- Name the folder, click Create Folder, and then close the window.
- From the Columns list, choose any dimension column.
- In the Select a List Area list, click the link for the KPI that you want to calculate.
- Choose the employee_ID column from the employee dimension.
NOTE: In some subject areas employee_ID column may not be available. Use the person ID column or other ID column to identify the employee's ID.
- From the subject area navigation, choose the fact column that represents the KPI you want to calculate.
- Apply the necessary filters so that the result of the request is a three-column by multiple-row table.
To see a preview of the results, continue through to Step 13.
- In the first column (any dimension column) click the Edit Formula button, and perform the following steps:
- Select the Custom Heading check box, and complete the following fields:
- Table Heading (Integration Component Name) = ERM KPI Employee Values Admin
- Column Heading KPI_ID = KPI Id
- Column Formula: '@{KPIId}{0}' (Be sure to include the single quotes.)
- Aggregation Rule = Default
- Click OK.
- In the second column (the employee Id column) click the Format button, and perform the following tasks:
- In the Column Properties Column Format tab, select the Custom Headings check box, and complete the following fields:
- Table Heading (Integration Component Name) = ERM KPI Employee Values Admin
- Column Heading (Employee ID Value) = Emp Id
- Click OK.
- In the third column (the KPI column) click the Format button, and perform the following tasks:
- In the Column Properties Column Format tab, select the Custom Headings check box, and complete the following fields:
- Table Heading (Integration Component Name) = ERM KPI Employee Values Admin
- Column Heading: (KPI Value) = Value
- Click the Value Format tab, and set the following values:
- Select the Override Default Data Format check box.
- In the Treat Number As field, choose Number.
- Negative format =Minus: -123
- Digits = 0 decimal places
- Do not select the Use 1,000 separator check box.
- Click OK.
- From the List Formats screen, click the Options tab, and in the Attributes form set the following field value:
Set Purpose = Analytics Data Load
- Click the Header and Footer tab, and in the Header window enter the following:
# ERM KPI Employee Values Admin EAI
# <do not click return>
NOTE: End of file is to the right of the space after the second #.
- Click the Preview tab.
- Set the Destination Folder path to a shared read-write folder.
For example, set the destination folder path to <MarketingFileSystem>c:\sea78\fs\.
- Click Generate Preview.
- Set Preview Size to 4, and then click OK.
- Verify text similar to the following is generated:
# ERM KPI Employee Values Admin EAI
# ERM KPI Employee Values Admin.KPI Id,ERM KPI Employee Values Admin.Emp Id,ERM KPI Employee Values Admin.Value
0,1-11Z2,22.80
0,1-5YQ1,28.50
0,1-H1NP,17.10
0,1-T7P5,17.10
If the result is not 0,<Emp_Id>,<#> then go back and apply filters so that the result is a multi-row and 3-column result.
- Click Save, and save the KPI as <KPI Name> in the KPI folder that you created.
|