Web Template: Analysis Report: Vendor Evaluation Group Scores 

Technical Name: 0TPL_SR_VE_C1_Q013_V010_1

Use

This Web template is used in conjunction with connected Web templates to analyze and understand the calculation of group scores and total scores from the contents of the InfoCube. In turn, scores are calculated from selected records for a certain grouping level and the formula used is explained.

You can use this report during implementation of vendor evaluation to familiarize yourself with the scoring system, allowing you to understand the calculation involved in the vendor evaluation queries.

Integration

This Web template is assigned to the role SAP_BW_SRM_VENDOR_EVAL (Vendor Evaluation) in the Sourcing Cockpit folder.

The following targets exist:

·        Analysis Report: Calculation of Total Score (1) - 0TPL_SR_VE_C1_Q014_1

Displays the second step for calculation of the total score.

·        Analysis Report: Calculation of Score Level 3 (1) - 0TPL_SR_VE_C1_Q014_2

Displays the second step for calculation of the score on level 3.

·        Analysis Report: Calculation of Score Level 2 (1) - 0TPL_SR_VE_C1_Q014_3

Displays the second step for calculation of the score on level 2.

·        Analysis Report: Calculation of Score Level 1 (1) - 0TPL_SR_VE_C1_Q014_4

Displays the second step for calculation of the score on level 1.

·        Analysis Report: Calculation of Total Score (2) - 0TPL_SR_VE_C1_Q015_1

Displays the third step for calculation of the total score.

·        Analysis Report: Calculation of Score Level 3 (2) - 0TPL_SR_VE_C1_Q015_2

Displays the third step for calculation of the score on level 3.

·        Analysis Report: Calculation of Score Level 2 (2) - 0TPL_SR_VE_C1_Q015_3

Displays the third step for calculation of the score on level 2.

·        Analysis Report: Calculation of Score Level 1 (2) - 0TPL_SR_VE_C1_Q015_4

Displays the third step for calculation of the score on level 1.

Prerequisites

The role SAP_BW_SRM_VENDOR_EVAL has to be activated. In addition, the targets of the following queries have to be activated:0SR_VE_C1_Q013 0SR_VE_C1_Q014 0SR_VE_C1_Q015.

Features

When you call this Web template, the system displays a variable selection screen that you can use to restrict the records displayed. On the screen, you can select any key fields of a rating, including time frame, product category, product, criterion, event, and so on. Enter values in one or more fields. This provides you with a clear overview of results and helps to keep response time low. If you do not make any restrictions, the system displays the entire contents of the InfoCube.

After you have entered the variables, the individual rating records from the InfoCube are displayed from Customizing, sorted according to weighting key and grouping. The totals lines show the average of all ratings for a criterion and explain the first phase of score calculation. You can use the magnifying glass icon adjacent to a score in the totals line to display the next calculation step for the selected level.

In the next report, the intermediate result is combined with other intermediate results in the next calculation step. The result of this step is in turn displayed as a totals line and it is again possible to use the magnifying glass icon to branch to the third and final calculation step. The totals line displayed here represents the final score for a vendor on the selected level.

A text at the top of the screen explains the formula used and the steps required to calculate the score. Using the relevant pushbuttons, you can print these reports, download them to Excel, or send them via e-mail.