Open topic with navigation

Demand

The Demand iCube enables you to create ad-hoc reports that help you view and analyze new ideas, IT Service requests, proposals, product enhancements, and requirements that help fulfill new opportunities. You can track and manage the process of converting these demands into projects that are aligned to various portfolios. Using this iCube , you can analyze parameters, such as status, impact of the demand, risks, business alignment, financial return, and so on.

The following data sets are combined together to create the Demand iCube:

Attributes

ClosedExpand this link to view the list of attributes used in the Demand iCube.

ITPA_Demand

Attributes Description
Calendar Date Gregorian calendar date displayed in the format 'M/D/YYYY'
Calendar Month Gregorian calendar month displayed in the format 'Mmm YYYY'
Calendar Quarter Gregorian calendar quarter displayed in the format 'Q# YYYY'
Calendar Week Gregorian calendar week displayed in the format 'Mmm W#'
Calendar Year Gregorian calendar year displayed in the format 'YYYY'
Company Name of the company for which the demand is being created
Date Date on which the demand was created
Demand New ideas, IT Service requests, proposals or product enhancements. It is the initial stage in the creation of opportunities for investment such as projects, assets, applications, products, services, and other work.
Demand Approval Date

Date when the demand was approved.

  • In case of ServiceNow, date when the 'State' changes to 'Approved'.
  • In case of HPE Micro Focus Project and Portfolio Management (PPM), date when the 'Status' changes to 'Project Creation'.
  • In case of CA PPM, date when the 'Status' changes to 'Approved'.
Demand Approval Delay Flag Indicates if there was a delay in approval of a demand. If Demand Approval Delay Time>=0 then 'Y' else 'N'
Demand Business Alignment Indicates how well the demand is aligned with the organization's business goals. For example, the values displayed are Good Alignment, Poor Alignment, and Average Alignment.
Demand Category Displays the category to which the demand belongs to. Categories could be defined as New Development, Compliance, Security, Enhancement, and so on.
Demand Conversion Date Date when the demand was converted
Demand Creation Date Date when the demand was created
Demand Due Date Date by when the demand needs to be fulfilled
Demand Fulfilled within Budget Flag Indicates if the demand was fulfilled within the allocated budget. For fulfilled demands, if Actual Project Cost < = Demand Planned Cost then 'Y' else 'N'.
Demand Fulfilled within Time Flag Indicates if the demand was fulfilled within the due date. If demand is fulfilled and Demand Fulfillment Date < Demand Due Date, then 'Y' else 'N'
Demand Fulfillment Date If Project associated to a demand is closed, Demand Fulfillment Date = Project Actual End Date. If not, Null.
Demand Goal Displays the business goal that the demand is trying to achieve.
Demand Impact Current impact of the demand
Demand Is Fulfilled Flag Indicates if the demand is fulfilled or not. If the project associated with the demand is closed, 'Y' else 'N'
Demand Manager Resource who is responsible to manage the demand
Demand Number Unique identifier to identify the demand
Demand Priority Displays the Priority specified for the demand
Demand Project Status If a demand is converted into a project, this attribute tracks the state of the associated project such as Not Started, In Progress, Closed and so on
Demand Requestor Resource who has raised the demand
Demand Risk Indicates the risk, such as Low, Medium, High, involved in completing the demand
Demand Start Date Date when the demand is planned to start
Demand State If a demand is converted into a project, this attribute tracks the state of the associated project such as Not Started, In Progress, Closed and so on
Note: This attribute is only applicable for CA PPM source system.
Demand Status Indicates the status of the demand. Possible values are: New, approved, incomplete, rejected, submitted for approval, unapproved, and converted
Demand Tshirt Size

Tshirt size refers to the various buckets or categories that are created to quantify each demand based on parameters, such as complexity, effort required, and available resources.

This attribute displays the size category to which the demand belongs, for example, Small, Medium, and Large
Demand Type Displays the type of demand that is being taken up, for example, Major Project, Application Change, and so on.
Demand Work Status Indicates the current work status of the demand, such as Active or Requested.
Department Department to which the demand belongs
Domain Domain to which the demand belongs
Is Project Demand Flag Indicates if there is a project associated with the demand
Lagging Count of Months Count of number of days since the first data record till current date
Lagging Count of Quarters Count of number of months since the first data record till current month
Lagging Count of Weeks Count of number of quarters since the first data record till current quarter
Lagging Count of Years Count of number of weeks since the first data record till current week
Location Location to which the demand belongs
Objective Brief description of the objective that the demand is trying to accomplish
Portfolio Displays the portfolios linked to the projects associated with the demand
Note: In CA PPM, a project might be associated to multiple portfolios. However,this attribute displays only the first assigned portfolio.
Project Displays projects that are associated with the demand
Project Number Unique identifier to identify the project

ITPA_Demand YTD

Attributes Description
Calendar Date Gregorian calendar date displayed in the format 'M/D/YYYY'
Calendar Month Gregorian calendar month displayed in the format 'Mmm YYYY'
Calendar Quarter Gregorian calendar quarter displayed in the format 'Q# YYYY'
Calendar Week Gregorian calendar week displayed in the format 'Mmm W#'
Calendar Year Gregorian calendar year displayed in the format 'YYYY'
Company Name of the company for which the demand is being created
Date Date on which the demand was created
Demand New ideas, IT Service requests, proposals or product enhancements. It is the initial stage in the creation of opportunities for investment such as projects, assets, applications, products, services, and other work.
Demand Approval Date

Date when the demand was approved.

  • In case of ServiceNow, date when the 'State' changes to 'Approved'.
  • In case of HPE Micro Focus Project and Portfolio Management (PPM), date when the 'Status' changes to 'Project Creation'.
  • In case of CA PPM, date when the 'Status' changes to 'Approved'.
Demand Approval Delay Flag Indicates if there was a delay in approval of a demand. If Demand Approval Delay Time>=0 then 'Y' else 'N'
Demand Business Alignment Indicates how well the demand is aligned with the organization's business goals. For example, the values displayed are Good Alignment, Poor Alignment, and Average Alignment.
Demand Category Displays the category to which the demand belongs to. Categories could be defined as New Development, Compliance, Security, Enhancement, and so on.
Demand Conversion Date Date when the demand was converted
Demand Creation Date Date when the demand was created
Demand Due Date Date by when the demand needs to be fulfilled
Demand Fulfilled within Time Flag Indicates if the demand was fulfilled within the due date. If demand is fulfilled and Demand Fulfillment Date < Demand Due Date, then 'Y' else 'N'
Demand Fulfillment Date If Project associated to a demand is closed, Demand Fulfillment Date = Project Actual End Date. If not, Null.
Demand Goal Displays the business goal that the demand is trying to achieve.
Demand Impact Current impact of the demand
Demand Is Fulfilled Flag Indicates if the demand is fulfilled or not. If the project associated with the demand is closed, 'Y' else 'N'
Demand Manager Resource who is responsible to manage the demand
Demand Number Unique identifier to identify the demand
Demand Priority Displays the Priority specified for the demand
Demand Project Status If a demand is converted into a project, this attribute tracks the state of the associated project such as Not Started, In Progress, Closed and so on
Demand Requestor Resource who has raised the demand
Demand Risk Indicates the risk, such as Low, Medium, High, involved in completing the demand
Demand Start Date Date when the demand is planned to start
Demand State If a demand is converted into a project, this attribute tracks the state of the associated project such as Not Started, In Progress, Closed and so on
Note: This attribute is only applicable for CA PPM source system.
Demand Status Indicates the status of the demand. Possible values are: New, approved, incomplete, rejected, submitted for approval, unapproved, and converted
Demand Tshirt Size

Tshirt size refers to the various buckets or categories that are created to quantify each demand based on parameters, such as complexity, effort required, and available resources.

This attribute displays the size category to which the demand belongs, for example, Small, Medium, and Large
Demand Type Displays the type of demand that is being taken up, for example, Major Project, Application Change, and so on.
Demand Work Status Indicates the current work status of the demand, such as Active or Requested.
Department Department to which the demand belongs
Domain Domain to which the demand belongs
Lagging Count of Months Count of number of days since the first data record till current date
Lagging Count of Quarters Count of number of months since the first data record till current month
Lagging Count of Weeks Count of number of quarters since the first data record till current quarter
Lagging Count of Years Count of number of weeks since the first data record till current week
Location Location to which the demand belongs
Objective Brief description of the objective that the demand is trying to accomplish
Portfolio Displays the portfolios linked to the projects associated with the demand
Note: In CA PPM, a project might be associated to multiple portfolios. However, this attribute displays only the first assigned portfolio.

Metrics

ClosedExpand this link to view the list of metrics used in the Demand iCube.

ITPA_Demand

Metric Name Description Formula Expected Value
% Fulfilled Demand in Budget Percentage of demands that were completed within the allocated budget (No. of Fulfilled Demands where [Demand Fulfilled within Budget Flag='Y'])/[No. of Fulfilled Demands] 0% to 100% closer to 100% is ideal
% Fulfilled Demand in Planned Time Percentage of demands that were completed within the planned time (No. of Fulfilled Demands where [Demand Fulfilled within Time Flag='Y'])/[No. of Fulfilled Demands] 0% to 100% closer to 100% is ideal
% P1 Demands Percentage of high-priority demands (No. of Demands where [Demand Priority='HIGH'])/[No. of Demands] 0% to 100%
% Unapproved Demand Percentage of demands that are not approved (in pending state) [No. of Pending Demands] / [No. of Demands] 0% to 100%
Actual Project to Demand Cost Variance Difference between the Planned Demand Cost and actual costs of all projects associated with a demand [Project Actual Cost] - [Demand Planned Cost] 0 or >0
Approval Compliance % Percentage of demands that were approved without delay ([No. of Approval Compliance Demands] / [No. of Demands]) 0% to 100%
Approved Demand Cost Planned Cost for approved demands Sum([Demand Planned Cost] where [Demand Status = APPROVED] 0 or >0
Approved Demand Ratio Percentage of approved demands [No. of Approved Demands] / [No. of Demands] 0% to 100%
Demand Actual Cost Actual cost incurred on a demand Obtained directly from the source 0 or >0
Demand Actual Effort (Hours) Actual Effort spent on a demand in hours Obtained directly from the source 0 or >0
Demand Approval Delay (Days) Total delay in approving demands with respect to Mean Time To Approve

If Demand is Approved,
Demand Approval Time - Mean Time To Approve (Days)

else [last refresh date - Demand Creation Date - Mean Time To Approve (Days)]

If the value returned is negative, it is set to 0.

 0 or >0
Demand Approval Time (Days) Duration in days between Demand Approval Date and Demand Creation Date. [Demand Approval Date] - [Demand Creation Date] 0 or >0
Demand Conversion Ratio Displays the percentage of demands that are converted ([No. of Converted Demands] / [No. of Demands]) 0% to 100%, closer to 100% is ideal
Demand Financial Return Net financials return expected once the demand is fulfilled Obtained directly from the source 0 or >0
Demand Fulfill to Converted Ratio Indicates the percentage of converted demands that were fulfilled [No. of Fulfilled Demands ] / [No. of Converted Demands] 0% to 100%, closer to 100% is ideal
Demand Fulfillment Delay (Days) Indicates the delay in fulfillment of a demand in days with respect to Demand Due Date (If Demand is fulfilled then [Demand Fulfillment Date - Demand Due Date]
else [last refresh date- Demand Due Date])
If the value is negative, it is set to 0		 0 or >0
Demand Fulfillment Ratio Percentage of fulfilled demands [No. of Fulfilled Demands] / [No. of Demands] 0% to 100% closer to 100% is ideal
Demand Fulfillment Time (Days) Difference between when the demand was created and when the project associated with the demand was completed [Demand Fulfillment Date] - [Demand Creation Date] 0 or >0
Demand Planned Capital Cost Capital cost estimated for fulfilling a demand Obtained directly from the source  
Demand Planned Cost The estimate of cost for a Demand. This could be updated as the project progresses. Obtained directly from the source 0 or >0
Demand Planned Effort (Hours) Amount of effort planned to be spent on a demand in hours Obtained directly from the source 0 or >0
Demand Planned Financial Benefit Total amount that the organization stands to gain by fulfilling a demand Obtained directly from the source 0 or >0
Demand Planned Operating Cost Amount of operating cost incurred as part of the planned amount to be spent on a demand Obtained directly from the source 0 or >0
Demand Fulfill to Converted Ratio Displays the percentage of fulfilled demands as compared to converted demands [No. of Fulfilled Demands] / ([No. of Converted Demands]) 0% to 100%, closer to 100%
Fulfilled Demand Cost Cost estimated for all fulfilled demands Sum([Demand Planned Cost]) where [Is Fulfilled Flag = Y] 0 or >0
Mean Time To Approve (Days) Average approval time in days for all approved demands ([Demand Approval Time (Days)] / ([No. of Approved Demands]+[No. of Converted Demands]) 0 or >0
Mean Time to Fulfillment (Days) Average fulfillment time in days for all fulfilled demands ([Demand Fulfillment Time (Days)] / [No. of Fulfilled Demands] 0 or >0
New Demand Cost Demand planned cost for all new demands Sum([Demand Planned Cost]) where [Demand Status = NEW]  
New Demand Ratio Percentage of new demands [No. of new demands] / [No. of demands] 0% to 100%
No. of Approval Compliant Demands Number of demands that were approved without any delay Count([No. of Demands]) where[Demand Status = APPROVED AND CONVERTED AND Approval Delay Flag = N] 0 or >0
No. of Approved Demands Total number of demands that have been approved. Count ([No. of Demands])<[Demand Status = APPROVED] 0 or >0, higher value is ideal
No. of Cancelled Demands Number of demands that were cancelled Count([No. of Demands]) where[Demand Status = CANCELLED] 0 or >0
No. of Converted Demands Number of demands that were converted Count([No. of Demands]) where [Demand Status = CONVERTED] 0 or >0
No. of Demands Total number of demands that are created Count ([No. of Demands]) 0 or >0
No. of Fulfilled Demands Number of demands converted and associated projects completed. Count ([No. of Demands]) where [Is Fulfilled Flag = Y] 0 or >0, higher value is ideal
No. of Fulfilled Demands within Budget Number of demands converted and associated projects completed within the allocated budget. Count([No. of Demands]) where [Is Fulfilled Flag = Y AND Demand Fulfilled Within Budget Flag = Y] 0 or >0
No. of Fulfilled Demands within Time Number of demands converted and associated projects completed within the Planned Time Count([No. of Demands]) where [Is Fulfilled Flag = Y AND Demand Fulfilled Within Time Flag = Y] 0 or >0
No. of New Demands Total number of new demands Count ([No. of Demands]) where [Demand Status = NEW] 0 or >0, closer to 0 is ideal
No. of P1 Approved Demands Number of high-priority demands that have been approved Count([No. of Demands]) where [Demand Priority = HIGH AND Demand Status = APPROVED] 0 or >0
No. of P1 Demands Number of high-priority demands Count([No. of Demands]) where [Demand Priority = HIGH] 0 or >0
No. of P1 Fulfilled Demands Number of high-priority, fulfilled demands Count([No. of Demands]) where [Demand Priority = HIGH AND Is Fulfilled Flag = Y] 0 or >0
No. of P1 Pending Demands Number of high-priority, pending demands Count([No. of Demands]) where [Demand Priority = HIGH AND Demand Status = PENDING] 0 or >0
No. of P2 Pending Demands Number of medium-priority, pending demands Count([No. of Demands]) where[Demand Priority = MEDIUM AND Demand Status = PENDING] 0 or >0
No. of Pending Demands

Total number of demands that are submitted but are yet to be approved

 Count ([No. of Demands]) where [Demand Status = PENDING] 0 or >0, closer to 0 is ideal
No. of Project Demands Number of demands which were converted into a project Count([No. of Demands]) where [Is Project Demand = Y] 0 or >0
No. of Rejected Demands Number of demands that were rejected Count([No. of Demands]) where [Demand Status = REJECTED] 0 or >0
P1 Approved Demand Ratio Percentage of high-priority, approved demands ([No. of P1 Approved Demands] / [No. of Demands]) 0% to 100%
P1 Demand Fulfillment Ratio Ratio of number of high-priority, fulfilled demands against total number of demands ([No. of P1 Fulfilled Demands] / [No. of Demands]) 0% to 100%
Pending Demand Cost Sum of Demand Planned Cost for all the pending demands Sum([Demand Planned Cost]) where [Demand Status = PENDING] 0 or >0
Pending Demand Ratio Percentage of pending demands [No. of Pending Demands] / [No. of Demands] 0% to 100%
Planned Project to Demand Cost Variance Difference between Planned Demand cost and planned cost of all the associated projects of a demand ([Project Planned Cost] - [Demand Planned Cost])  
Project Actual Cost Actual cost incurred on a project Obtained directly from the source 0 or >0
Project Planned Cost Planned cost to complete a project Obtained directly from the source 0 or >0
ROI% Return On Investment - A performance measure that gives the amount gained from the comparison of the profit on investment with the total cost on the investment. Obtained directly from the source 0 or >0

ITPA_Demand YTD

Metric Name Description Formula Expected Values
YTD Approved Demand Cost Planned Cost for approved demands in the current year Sum([Demand Planned Cost]) where [YTD & Demand Status = APPROVED] 0 or >0
YTD Demand Actual Cost Actual cost incurred on a demand in the current year Sum([Demand Actual Cost]) where [Year To Date] 0 or >0
YTD Demand Actual Effort (Hours) Actual Effort spent on a demand in the current year in hours Sum([Demand Actual Effort (Hours)]) where [Year To Date] 0 or >0
YTD Demand Financial Return Net financials return expected in the current year once the demand is fulfilled Sum([Demand Financial Return]) where [Year To Date] 0 or >0
YTD Demand Planned Capital Cost Capital cost estimated in the current year for fulfilling a demand Sum([Demand Planned Capital Cost]) where [Year To Date] 0 or >0
YTD Demand Planned Cost The estimate of cost for a Demand in the current year. This could be updated as the project progresses. Sum([Demand Planned Cost]) where [Year To Date] 0 or >0
YTD Demand Planned Effort (Hours) Amount of effort planned to be spent on a demand in the current year in hours Sum([Demand Planned Effort (Hours)]) where [Year To Date] 0 or >0
YTD Demand Planned Financial Benefit Total amount that the organization stands to gain in the current year by fulfilling a demand Sum([Demand Planned Financial Benefit]) where [Year To Date] 0 or >0
YTD Demand Planned Operating Cost Amount of operating cost incurred as part of the planned amount to be spent on a demand in the current year Sum([Demand Planned Operating Cost]) where [Year To Date] 0 or >0
YTD Fulfilled Demand Cost Cost estimated for all demands fulfilled in the current year Sum([Demand Planned Cost]) where [YTD & Is Fulfilled Flag = Y] 0 or >0
YTD New Demand Cost Demand planned cost in the current year for all new demands Sum([Demand Planned Cost]) where [YTD & Demand Status = NEW] 0 or >0
YTD Pending Demand Cost Sum of Demand Planned Cost for all the demands pending in the current year Sum([Demand Planned Cost]) where [YTD & Demand Status = PENDING] 0 or >0

© 2022 Digital.ai Inc. All rights reserved.