Skip to end of metadata
Go to start of metadata

1. Objective

The goal of this WIKI is to describe the usage of the Focused Build data provider available in Focused Insights for SAP Solution Manager.

2. Overview

The Build data provider (DP_BUILD) is designated to users using both Focused Insights and Focused Build for SAP Solution Manager Applications.

It provides a real-time insight on the most used documents of focused build based on a set of standard indicators for Velocity, Reliability, Efficiency and Quality.


Combined with the Test data providers it provides IT managers with the main indicators for project and DevOps management as shown below :


Metrics

KPI

Description

Source

Change Frequency

Velocity

Number of changes transported to productions.

Change Mgt

Change Volume

Velocity

Number of objects transported to productions.

Change Mgt

Tests Execution

Velocity

Number of tests (manual and automatic) executed.

Test Suite

Deployment Speed

Velocity

Number of Work Items released.

Focused Build

Tests Automation Rate

Quality

Number of regression, security and performance automated tests.

Test Suite

Code Quality Issues

Quality

Code and security checks issues detected in production.

Custom Code Mgt

Test Coverage

Quality

Percentage of successful manual and automatic tests execution

Test Suite

Security & Compliancy Issues

Quality

Security and conformity issues detected in production.

Configuration Validation

Innovation Rate

Efficiency

Number of Business Requirements released.

Focused Build

Deployment Frequency

Efficiency

Number of Work Packages released.

Focused Build

Lead Time global

Efficiency

Time from design to deployment in production.

Focused Build

Lead Time Test to Production

Efficiency

Time from test to deployment in production.

Focused Build

Mean Time To Recover (MTTR)

Efficiency

Time recover from an issue.

ITSM

User Incident Volume

Reliability

Number of customer outages.

ITSM

Alerts Volume

Reliability

Number of high and very high applications or systems issues.

System Monitoring

Application Performance

Reliability

Response time for main transaction / jobs / interfaces.

System Monitoring

Availability

Reliability

Up time for applications servers, hosts, databases, service, transactions, interfaces.

System Monitoring

Data Consistency Issues

Reliability

Number of inconsistency, integrity issues for business data.

Data Consistency Mgt


2.1 Documents

Three types of documents are supported by the DP_BUILD:

  • Work Item
  • Work Package
  • Requirement

2.2 Measurements 

Four measurements are supported by the DP_BUILD:

  • Number
  • Snapshot
  • Lead Time
  • Progress

2.3 Renderers

The Build data provider supports the following list of renderers:

  • Line Chart
  • Pie Chart
  • Donut Chart
  • Line-Column Chart
  • Dual Line Chart
  • Dual Line-Column
  • Dual Bar-Column
  • Stack Bar Chart
  • Stack Column Chart
  • Stack Column Chart2 Label
  • Waterfall Chart
  • Column Chart
  • Bar Chart
  • Table History Renderer
  • Trend Table Renderer
  • Dynamic Table 

2.4 Data Provider Option

Group

Filter

Selection

Description

Values

Parameters

Document

Single

List of the available documents.

The possible values are Work packages, Work items and IT requirements.

Status

Multiple

List of the available status.

The possible values are created, scoping, scope finalized, scope extension, rejected postponed, to be developed...

Target Status

 

Single

List of the available target status.

The possible values are created, scoping, scope finalized, scope extension, rejected postponed, to be developed...

Classification

Single

List of available classifications.

The possible values are WRICEF, Fit, GAP, and Non-functional.

Project

Single

List of the available projects.

 

Sub project

Single

List of the available sub projects.

 

Wave

Single

List of the available waves.

 

Sprint

Single

List of the available sprints.

 

 

Metric

Metric

Single

Available metrics.

The possible values are Number, Lead time, Snapshot and Progress.

Open

Multiple

Open statuses for the progress metric

 

Closed

Multiple

Closed statuses, used only with the progress metric

 

Category

Level1

Single

Filter for categories

 

Level2

Single

Filter for categories

 

Level3

Single

Filter for categories

 

Level4

Single

Filter for categories

 

PS: In this data provider, every document is related to a specific wave and if the user selects a period that is not included in the start date and end date of the wave he will not get any available data displayed. 

3.  Metrics

3.1 Number

This metric aims to show the number of documents (related to a specific document type: Work Item, Work Package or requirement) changing to the selected status (created, in development, completed…) for the given resolution (day, week, …).


Group

Filter

Mandatory

Relevant

Not Relevant

Parameters

Document

X

 

 

Status

 

X

 

Target Status

 

 

X

Classification

 

X

 

Project

X

 

 

Sub project

 

X

 

Wave

 

X

 

Sprint

 

X

 

Metric

Metric

X (Number)

 

 

Open

 

 

X

Closed

 

 

X

Category

Level1

 

X

 

Level2

 

X

 

Level3

 

X

 

Level4

 

X

 

 

3.1.1 Scenario Examples of Queries

ExampleNumber of Work Packages Created per Week during this Month.

To have such graph we use:

  •        Line chart as renderer type 
  •        This month (period) / Week (resolution) as time range 
  •        Work package as document type
  •       Created as status
  •       Number as metric

In this case we will use the metric number : 

/STDF/DP_BUILD: COLOR=#1f77b4|legend=Number of Created Work Package|OCC_JUMP_IN=|SLA=|TREND=| G2Y=|Y2R=|COLOR_RATING=|DISPLAY_ATTRIBUTES=|FILTER_VALUE=|visible=true|OBJECT=S1IT|STATUS=E0001| TARGET=|CLASSIFICATION=|PROJECTS=|SUBPROJECTS=|WAVE=|SPRINT=|METRIC=NUMBER|OPEN=|CLOSED=| LEVEL_1=|LEVEL_2=|LEVEL_3=|LEVEL_4=|display_value=false

Another exampleNumber of Work Packages having the status Created and To Be Developed per Month during the last 2 Months.

To have such graph we use:

  •          Dynamic Table as renderer type 
  •          Last 2 Months (period) / Month (resolution) as time range 
  •          Work package as document type
  •          Created and To Be Developed as status
  •          Number as metric

  

In this case we will use the metric number

/STDF/DP_BUILD:COLOR=#1f77b4|legend=Number|OCC_JUMP_IN=|SLA=|TREND=|G2Y=|Y2R=|COLOR_RATING=|

DISPLAY_ATTRIBUTES=MASTER_GUID,ITR_NAME,DESCRIPTION,ITR_STATUS,ITR_STATUS_TXT,ITR_TYPE,ITR_CATEGORY,WAVE_GUID,WP_SCHEDULE,DUE_DATE,ARCHITECT,PLANNED_EFFORT,

COMPLETION,BUILD_TEAM,FUNC_SPEC_DUE_DATE,TOTAL_WORK_ITEMS,AGE,PRIORITY,PROJECT_GUID,PROJECT_NAME,FUNC_SPEC_STAT|visible=true|OBJECT=S1IT|

STATUS=E0001,E0022|TARGET=|CLASSIFICATION=|PROJECTS=0E6D000C94821ED8A6DE030511ED5D0F|SUBPROJECTS=

|WAVE=|SPRINT=|METRIC=NUMBER|OPEN=|CLOSED=|LEVEL_1=|LEVEL_2=|LEVEL_3=|LEVEL_4=|display_value=false


3.2 Lead Time

This metric aims to show the number of days for a document to reach a target status from a source status for the given resolution (day, week, …).


Group

Filter

Mandatory

Relevant

Not Relevant

Parameters

Document

X

 

 

Status

X

 

 

Target Status

X

 

 

Classification

 

X

 

Project

X

 

 

Sub project

 

X

 

Wave

 

X

 

Sprint

 

X

 

Metric

Metric

X (Lead Time)

 

 

Open

 

 

X

Closed

 

 

X

Category

Level1

 

X

 

Level2

 

X

 

Level3

 

X

 

Level4

 

X

 

3.2.1 Scenario Examples of Queries

Example: Wait Time to start development on Work Packages.

To have such graph we use:

  • SLR table renderer as renderer type 
  • Last 2 months (period) / month (resolution) as the time range 
  • Work package as document type
  • Created as status
  • To be Developed as target status
  • Lead Time as metric

 

In this case we will use the metric lead time

/STDF/DP_BUILD:COLOR=#1f77b4|legend=Lead Time of Work Packages to go from the status Created to the status to be

Developed|OCC_JUMP_IN=|SLA=|TREND=|G2Y=|Y2R=|COLOR_RATING=|DISPLAY_ATTRIBUTES=|FILTER_VALUE= |visible=true|

OBJECT=S1IT|STATUS=E0001|TARGET=E0022|CLASSIFICATION=|PROJECTS=5CF3FCDCEC001EE8B4EF4963162A7D42|

SUBPROJECTS=|WAVE=|SPRINT=|METRIC=LEAD_TIME|OPEN=|CLOSED=|LEVEL_1=|LEVEL_2=|LEVEL_3=|LEVEL_4=

3.3 Snapshot

This metric aims to show the number of documents having the selected status (created, to be developed, in development, …).

This metric is a cumulative one and it supports only the day resolution.

Group

Filter

Mandatory

Relevant

Not Relevant

Parameters

Document

X

 

 

Status

X

 

 

Target Status

 

 

X

Classification

 

X

 

Project

X

 

 

Sub project

 

X

 

Wave

 

X

 

Sprint

 

X

 

Metric

Metric

X (Snapshot)

 

 

Open

 

 

X

Closed

 

 

X

Category

Level1

 

X

 

Level2

 

X

 

Level3

 

X

 

Level4

 

X

 

3.3.1 Scenario Examples of Queries

ExampleNumber of Work Packages with Status To Be Developed.

To have such graph we use:

  •          Column chart as renderer type 
  •          Last 6 months (period) / day (resolution) as the time range 
  •          Work package as document type
  •          To Be Developed as status
  •          Snapshot as metric



In this case we will use the metric snapshot 

/STDF/DP_BUILD:COLOR=#ff7f0e|legend=Number of Work Packages with Status To Be Devloped

|OCC_JUMP_IN=|SLA=|TREND=|G2Y=|Y2R=|COLOR_RATING=|DISPLAY_ATTRIBUTES=|visible=true|OBJECT=S1IT

|STATUS=E0022|TARGET=|CLASSIFICATION=|PROJECTS=0E6D000C94821ED8A6DE030511ED5D0F|SUBPROJECTS=|WAVE= |SPRINT

|METRIC=SNAPSHOT|OPEN=|CLOSED=|LEVEL_1=|LEVEL_2=|LEVEL_3=|LEVEL_4=|display_value=false


3.3 Progress

This indicator analyses the status of a document of a project for a specific wave.It returns a set of measurements (Backlog, Extension, Completion, Rescheduled, Others, Remaining) to track the progress of wave completion between the start date of the wave and the end date of the wave or the current date if the wave is not finished.

The Waterfall Chart Renderer is the only renderer supporting this metric.


Group

Filter

Mandatory

Relevant

Not Relevant

Parameters

Document

X

 

 

Status

 

 

X

Target Status

 

 

X

Classification

 

 

X

Project

X

 

 

Sub project

 

 

X

Wave

 

 

X

Sprint

 

 

X

Metric

Metric

X (Progress)

 

 

Open

 

X

 

Closed

 

X

 

Category

Level1

 

 

X

Level2

 

 

X

Level3

 

X

 

Level4

 

X

 


3.4.1 Scenario Examples of Queries

ExampleProgress of the Created Work Packages during this month

To have such graph we use:

  •        Waterfall chart as renderer type 
  •         This month (period) / Week (resolution) as the time range 
  •        Work package as document type
  •        created as status
  •         In development as target status
  •        Progress as a metric


In this case we will use the metric progress

/STDF/DP_BUILD: COLOR=#1f77b4|legend=Progress of Work Packages| OCC_JUMP_IN=|SLA=|TREND=|G2Y=|Y2R=|

COLOR_RATING=|DISPLAY_ATTRIBUTES=|FILTER_VALUE=|visible=true|OBJECT=S1IT|STATUS=E0001|TARGET=E0017|

CLASSIFICATION=|PROJECTS=5CF3FCDCEC001EE89BFAB11534D0995B|SUBPROJECTS=5CF3FCDCEC001EE89BFABAD1F7FE795F

|WAVE=5CF3FCDCEC001EE89BFABAD1F803195F|SPRINT=

|METRIC=PROGRESS|OPEN=|CLOSED=|LEVEL_1=|LEVEL_2=| LEVEL_3=|LEVEL_4=|display_value=false




  • No labels