• Dashboard
• Report
• Advanced analytics

• BW
• Tableau
• Qliksense
• Talend
• Dataiku
• Others <specify which one>

Data Sources 

Note: list of all applications and various environment

• Accolade
• SAP PF1 (Production environment)
• SAP WP1
• SAP PI1
• BW (versions)  

GroupID_SYS:

15, 62,94,108

GroupID_SYS:
18, 46, 109, 63, 64, 65, 66, 103, 104, 69, 111, 105, 106, 110, 124

Execute the stored procedure iteratively, with the different parameters to obtain the different results sets needed for the scope of the project

Business Concept

Database Object

Link to output specification

Comments

SGM_CUSTOM_VIEW

CRV_Initiative_V3

Tables, Stored Procedures and Data Mapping File

<comment or description of the concepts in the table>

SGM_CORE_Project Details

CRV_ZGetProjectDetails

SGM_PROJECTMETRICS_15

Exec RSP_QV_GetProjectMetricsForGroupID 15

SGM_PROJECTMETRICS_62

Exec RSP_QV_GetProjectMetricsForGroupID 62

SGM_PROJECTMETRICS_94

Exec RSP_QV_GetProjectMetricsForGroupID 94

SGM_PROJECTMETRICS_108

Exec RSP_QV_GetProjectMetricsForGroupID 108

SGM_PROJECTMETRICS_18

Exec RSP_QV_GetProjectMetricsForGroupID 18

SGM_PROJECTMETRICS_46

Exec RSP_QV_GetProjectMetricsForGroupID 46

SGM_PROJECTMETRICS_109

Exec RSP_QV_GetProjectMetricsForGroupID 109

SGM_PROJECTMETRICS_63

Exec RSP_QV_GetProjectMetricsForGroupID 63

SGM_PROJECTMETRICS_64

Exec RSP_QV_GetProjectMetricsForGroupID 64

SGM_PROJECTMETRICS_65

Exec RSP_QV_GetProjectMetricsForGroupID 65

Exec RSP_QV_GetProjectMetricsForGroupID 66

Exec RSP_QV_GetProjectMetricsForGroupID 103

Exec RSP_QV_GetProjectMetricsForGroupID 104

Exec RSP_QV_GetProjectMetricsForGroupID 69

Exec RSP_QV_GetProjectMetricsForGroupID 111

Exec RSP_QV_GetProjectMetricsForGroupID 105

Exec RSP_QV_GetProjectMetricsForGroupID 106

Exec RSP_QV_GetProjectMetricsForGroupID 110

Exec RSP_QV_GetProjectMetricsForGroupID 124

Budget & Costs File:

(Act.+Planned CAPEX) + (Act.+Planned OTC) = Act.+Planned Total

Actual Planned Total for the current year -(Current year Actual Cost/Actual Planned Total for the current year)  

Budget & Cost File:

Number of working days between Requested Start Date (PMO Gate)  and End date

Budget & Cost File:

if the number of working days between Requested Start date (PMO Gate) and today  divided by Operational Time Total KPI (NUMBER 4). If a value is returned, display that value otherwise if it shows an error just display 1

Budget & Cost File:

Actual Cost for the current year divided by the Actual Planned Total for the current year

Budget & Cost File:

Burn Rate divided by Operational Time total

KPI 4 / KPI 5

Budget & Cost File: 

If KPI 5 is greater than 50 %  display 1 - Ahead of Schedule >50%"

If KPI 5 is greater than 30 %  display 1 - Ahead of Schedule 30%"

If KPI 5 is greater than -30 %  display "3 - Linear"

If KPI 5 is greater than -50 %  display "4 - Below Schedule 30-50%"

else display "5 - Below Schedule more than 50%"

Budget and Cost File:

Display a list of projects where the Total Approved amount is BLANK and "Status" is "On-going" or "Went Live"

Budget and Cost File:

Display the list of projects (+ number) with an increase of the budget

Budget and Cost File:

Display a histogram of projects showing how frequently their status has been updated. 

if the project to be considered field  = NO, and the days since last update is blank = 1; the status =6 Never Updated 

if the project to be considered field  = NO, and the days since last update is < 31 ; the status = 1. Less Than 30 days

if the project to be considered field  = NO, and the days since last update is < 61 ; the status = 2. Between 30 and 60 days

if the project to be considered field  = NO, and the days since last update is < 91 ; the status = 3. Between 2 and 3 months

if the project to be considered field  = NO, and the days since last update is < 181 ; the status = 4 Between 3 and 6 months

else display 5. more than 6 months

Budget and Cost File:

Display the number of projects where the financial status of the project has been updated

if the project to be considered field  = yes and the financial up to date field = 1; the status = Updated

if the project to be considered field  = yes and the financial up to date fiekd = 3; the status = Not Updated

if the project to be considered field  = yes and the financial up to date filed = blank; the status = No KFD

Budget and Cost File:

Display a histogram of Project forecasts vs approved budget

Status: below, above, on track

If forecast budget is below ref approved: Below

If forecast budget if above approved ref:  Above

If forecast budget if equal to approved ref: On Track

Budget and Cost File:

Display a histogram of the number of projects that are "On Time", "Slightly Delayed" or "Delayed"

The value of On Time  = 1

The value of Slightly Delayed  = 2

The value of Delayed  = 3

Budget and Cost File:

Display a histogram of the List of projects where end date<month date

Budget and Cost File: 

Display a histogram of the list of projects comparing Approved vs forecast

1. Split Capex / OTC
2. Finance Update Frequency
3. Burn Rate Budget
4. Forecast Accuracy Rate

1. Operational Time Total (in days)
2. Operational time to date vs total (%)
3. Operational Burn Rate
4. Project (Planned, ongoing, went live) with no approved budget but with some actuals
5. Projects not yet started with a start date in the past
6. Carryover Not Planned
7. Status Update Frequency
8. On Budget
9. On Time
10. Project Close to Over Budget