General information
General description
The Footprints QV Dashboard is used to provide indicators to analyse statistics on the User Requests (UR) created in Footprints1 and therefore the target audience is only the IS function users.
Today the dashboard is mainly designed around the "SAP Applications, Helpdesk and Non-SAP Applications" Footprints spaces but could be improved to satisfy other spaces needs.
The data comes exclusively from Footprints.
Fields definition
Below is a list of some of the fields used in the report as filters or as analysis axis. If not in the list, the field comes directly from Footprints as is.
Level
- Usage : This field is used to help quickly select a perimeter of UR's based the team, or "level" of the request. There are 4 values
- Helpdesk : All UR's in the Helpdesk Project
- Support : All UR's for "level 2" support.
- CC Dev : All UR's for "level 3" support, or that required a developpment.
- Security : All UR's in the Security Project
- Definition : The value is hard-coded for a combinaison of Footprints Workspace + UR Type + Subtype.
The mapping for this can be checked in the "Mappings" sheet in the dashboard.
Region
This is the region of the user : AP, LA, NA or EU 
Note that :
- For SMIO : in Footprints the zone for SMIO are prefixed by "SMIO". This is removed in Qlikview.
- Only the AP, LA, NA, EU values are displayed in the left side filter. Other values exist for some footprints projects.
Tool
Usage : This field is used to regroup UR's based on the requierements of some users (It's basically the equivalent of the "Sort field" in SAP). Today it is defined for the few users that requested it.
- Definition : A UR can only be in 1 Group. The value is hard-coded for a combinaison of Project + UR Type + Subtype
The mapping for this can be checked in the "Mappings" sheet in the dashboard.
SLA Days
- Usage : This field is used calculate SLA indicators.
- Definition : The value is hard-coded for a combinaison of Project + UR Type + Subtype.
The mapping for this can be checked in the "Mappings" sheet in the dashboard.
Status Types
- Usage : The objective of this field is to summarize the Footprints status and regroup it in very few values to allow easier selection/filtering. Only 4 values :
- Completed
- Rejected
- Open
- Transferred (to another project)
- Definition : The value is hard-coded for each footprints status.
The mapping for this can be checked in the "Mappings" sheet in the dashboard.
Waiting Type
- Usage : This field is used to summarize the footprints status based on who the UR is waiting for the next step. Objective is to simplify the reading compared to the multiple and complex footprints status.
- Definition : The value is hard-coded for each Footprints status.
The mapping for this can be checked in the "Mappings" sheet in the dashboard.
BIM Outsourced
- Usage : This field is used to split the analysis between UR that are outsourced to Tivit and URs completed in-house. Only works for the BIM / Non-SAP Application projects. Values are YES or NO.
- Definition : Comes directly from a Footprints system field.
Subtask
- Usage : Allows to include or exclude Sub-URs from the analysis.
- Definition : Value is calculated based on a Footprints technical field (REF_TO_MR contains P)
Important notice for Helpdesk
For Helpdesk UR, when the UR's has been transfered, the status is automatically set to "Transfered-HDA"
The reason we do this is because when a UR is transfered from the helpdesk to another project, the HDA UR will copy the status of the UR in the transfered project.
While this is interresting in Footprints (it allows the user to see the overall status of his request in the Helpdesk), for HDA KPI's it is important to be able to segragate between UR's completed by the HDA and UR's transfered by the HDA (in this case the work of the helpdesk is done).
Sheets documentation
Current view
The objective is this page is to provide an overview of the current situation : it only shows OPEN User requests
Currently Open UR by Status
Shows the number of URs which currently have a status of the "Open" type (Status Type = Open).
Aging by Type
- Open = Number of open UR.
- AvgD = Average number of days since UR was submitted (Today - Submittion date)
- Aging Buckets (0-3...) : number of URs that were submitted between 0 and 3 days ago.
Ex : if a UR is still open today and was submitted 5 days ago, it will count as 1 in the "4-10" bucket.
In the picture, there are 5 UR for Basic Support in BW/BIM that are still open and have been submitted since 31 and 90 days ago.
Currently open UR by Submit Month
Shows the number of UR opened by month of submition.
In the Picture, we still have 1 UR open today that was subtmitted in 10.2009.
Aging by Technician
Shows the number of UR which are currently open by Technician assigned.
The Aging Buckets (0-3...) correspond to the number of URs that were submitted between 0 and 3 days ago.
Ex : In the picture, David has 14 open UR assigned to him, from which 1 is older than 180 days (was submitted at least 181 days ago)
No technician assigned
Counts the number of Open User request which have no technician assigned.
TIVIT No Accepted Date
Counts the number of user requests which are managed by TIVIT (Outsourced = YES) and for which the Production Due date is empty.
Evolution Overview
Completed by Month
Shows the number of UR's completed by month (whatever the data at which the UR was submitted)
The X axis corresponds to the month of :
- Completion of the UR
- Transfer of the UR (if the UR was transfered).
- Rejection of the UR (if the UR was rejected)
By default the number of UR is splitted by the status type which shows how the UR was completed : by transfering or rejecting or actual completion.
Submitted by month
Counts the number of UR submitted by month.
By default, the indicator is split by the current status of the user request.
Avg Open Days to Complete/Transfer
Measures the average working days between the submition date and completion/transfer date.
The result is displayed by month of completion or transfer (NOT submit date)
Ex : a UR submitted in 01.2012 and completed in 02.2012 will be counted in the 02.2012 average.
Avg Open Days to Complete/Transfer (Table)
Measures the average working days between the submition date and completion/transfer date.
The result is displayed by month of completion or transfer (NOT submit date)
Ex : a UR submitted in 01.2012 and completed in 02.2012 will be counted in the 02.2012 average
Note : The result is the same as on the graphic (bar) display. This table is only used to get a detail.
12M Open UR as End of Month
This KPI shows the number of User Requests that were still open at the end of each month (12 rolling months). It's basically the backlog remaining at the end of each month.
Ex : At the end of January 2011 there were 66 Open UR but at end of February 2011 only 55 UR.
For this KPI to work correctly, please remove any filter on the Submit year and submit month.
End of Month Open Assigned UR (Workload)
This table gives the same KPI as the "12M Open UR as End of Month" graphic but on a table format with detail (Technician Assigned or submitter).
This KPI shows the number of User Requests that were still open at the end of each month (12 rolling months). It's basically the backlog remaining at the end of each month.
Ex : At the end of January 2011 there were 66 Open UR but at end of February 2011 only 55 UR.
The best way to get IT support is to use the new
Service One Platform.