SPM — Strategic Portfolio Management (Zero → Pro)

اقرأ أولاً: ../MASTER_ALL_IN_ONE_SUMMARY.md · ../html/MASTER_ALL_IN_ONE_SUMMARY.html
الدليل الشامل: ../MASTER_ALL_IN_ONE.md · ../html/MASTER_ALL_IN_ONE.html
ممارسة الشاشات: ../html/MASTER_PRACTICE_GUIDE_ALL_TOPICS.html
Australia · Scope x_786686_hr_leave

Australia Instance — نسخة أستراليا

Direct Navigation URLs — روابط التنقل المباشرة

Platform target: ServiceNow Australia (Sep 2026) · next EA: Brazil
URLs: ../../SERVICENOW_DIRECT_URLS_CATALOG.md · 1-week: ../../SERVICENOW_ONE_WEEK_STUDY_DEPLOY_AUSTRALIA.md
HR Leave: Scope x_786686_hr_leave

CIS-SPM / CIS-PPM Professional Implementer Guide
الأسلوب: عربية + إنجليزية تكمّلان بعضهما — بدون ترجمة حرفية لأسماء الشاشات.

ملخص ووصف بالعربية (Arabic Summary)

ملخص في سطر: SPM مظلة · PPM مشاريع داخلها · مسار: هدف استراتيجي → فكرة → Demand → مشروع → منفعة.

وصف مختصر: يشرح الفرق SPM/PPM/ITBM، Innovation، Demand Workbench، Planning Console، Resource Workbench، Agile، Cost/Benefit. CIS-SPM/PPM.

1) Overview & Business Value

SPM (Strategic Portfolio Management) is ServiceNow’s suite for turning strategy into funded, resourced, delivered work.
PPM (Project Portfolio Management) is the project/delivery app inside that suite — not a rival to SPM. — SPM = مجموعة تطبيقات (استراتيجية → فكرة → طلب → مشروع → موارد → ميزانية). PPM = جزء من SPM يُدير المشاريع والتسليم — ليس بديلًا لـ SPM.

Read first: §1B Strategy → Goals → Innovation → Demand → Project — Full Map

Executives set strategy & goals; the organization submits ideas; PMO governs demands; approved work becomes projects with resources and financials — all visible on portfolios and roadmaps.

الإدارة تضع الاستراتيجية والأهداف → الموظفون يقدّمون أفكارًا → PMO يقيّم الطلبات → المعتمد يصبح مشروعًا → موارد وميزانية → منافع تُغذّي الاستراتيجية مجددًا.

Core applications (SPM suite — separate licenses on Store):

1B) Strategy → Goals → Innovation → Demand → Project — Full Map

Use in workshops when the client asks: “Where do strategy goals live?” or “What is Demand vs Project?”
الأسلوب: عربية + إنجليزية تكمّلان بعضهما في نفس السياق.

1B.1 SPM vs PPM vs ITBM — naming (not “either/or”)

SPM is the umbrella. PPM is one app inside it. You implement strategy execution with the whole SPM stack, not “PPM only” if the client cares about goals and demand governance.

SPM = المظلة · PPM = المشاريع داخلها · Demand = البوابة قبل المشروع · Strategy = القمة.

┌──────────────────────────────────────────────────────────────┐
│ BUSINESS OUTCOME — execute strategy, fund the right work │
└────────────────────────────┬─────────────────────────────────┘
 │ implemented on ServiceNow as
 ▼
┌──────────────────────────────────────────────────────────────┐
│ SPM (Strategic Portfolio Management — product suite) │
│ Strategy · Innovation · Demand · PPM · Resource · Agile · $ │
└──────────────────────────────────────────────────────────────┘

1B.2 The full stack — top to bottom (strategy to value)

LAYER 1 — STRATEGY (Why are we investing?)
 Enterprise Strategy / Strategic Goals / Initiatives
 Roadmap Planning (when on timeline)
 │
 │ alignment score / portfolio link
 ▼
LAYER 2 — PORTFOLIO GOVERNANCE (What buckets of work?)
 Portfolio (pm_portfolio) → Program (pm_program)
 │
 ▼
LAYER 3 — INTAKE (What should we consider?)
 Idea (Innovation Management) — employee / partner suggestions
 │ promote
 ▼
LAYER 4 — DEMAND (Should we fund it?)
 Demand (dmn_demand) — assess, score, stage gates, approve/reject
 │ convert
 ▼
LAYER 5 — DELIVERY (How do we build it?)
 Project (pm_project) — Waterfall WBS OR Agile stories/sprints
 Resource plans + allocations
 Cost plan + benefit plan
 │
 ▼
LAYER 6 — VALUE (Did it work?)
 Close project → benefit realization → portfolio review
 │
 └──────► feeds Layer 1 (next planning cycle)

العربي — طبقة بطبقة:

1B.3 Each SPM module — different question (not the same app)

1B.4 Strategy goals → portfolio → project (alignment chain)

Strategic goals express outcomes (e.g. “Increase digital revenue 20%”). Portfolios collect funded work that supports those goals. Projects are how goals become reality.

الهدف الاستراتيجي = نتيجة · المحفظة = مجموعة مشاريع تخدم الهدف · المشروع = التنفيذ.

Strategic Goal: "Improve customer self-service"
 │
 ├─ Initiative: "Launch mobile portal"
 │ │
 │ └─ linked Portfolio: "Digital Customer Experience"
 │ │
 │ └─ Program: "Mobile 2026"
 │ │
 │ ├─ Project: "Mobile app phase 1"
 │ └─ Project: "API modernization"
 │
 └─ Roadmap: shows goals + projects on timeline (executive view)

Alignment score / strategic fit (Demand & Project):
Demand and project records often carry fields linking to goal or portfolio — used in prioritization dashboards.

1B.5 Innovation → Demand → Project (intake pipeline)

This is the most common CIS-SPM exam path and the PMO governance story.

Employee / stakeholder
 │
 ▼
IDEA (Innovation Management)
 • Low barrier — anyone submits via /sp or Idea portal
 • Categories, voting, comments (optional)
 │
 │ PMO / demand manager: "promote to demand"
 ▼
DEMAND (Demand Management)
 • Stages: Draft → Submitted → Screening → Qualified → Approved/Rejected
 • Assessment / scorecard (value, risk, cost, strategic alignment)
 • Flow Designer approvals (stage gates)
 │
 │ Approved + convert
 ▼
PROJECT (or Enhancement / Defect — other conversion types)
 • Methodology: Waterfall | Agile | Hybrid
 • Planning Console (WBS) OR Agile board
 • Resource plan + cost/benefit plan

لا تنشئ مشروعًا مباشرة إذا العميل يريد حوكمة — مرّ عبر Demand (أو على الأقل Idea → Demand).

1B.6 How modules share data (integration — not silos)

 Strategic Goals
 │
 ┌─────────┴─────────┐
 ▼ ▼
 Portfolio Roadmap
 │
 ├─ Program
 │ └─ Project ◄──── converted from Demand ◄──── Idea
 │ ├─ Resource plan / allocations
 │ ├─ Cost plan / benefit plan
 │ └─ Tasks (WBS) OR Stories (Agile)
 └─ Executive dashboard (PA / portfolio workbench)

1B.7 SPM vs other ServiceNow modules (boundaries)

ITSM = يومي · SPM = استثمار وتسليم مشاريع · قد يتقاطعان عند Change مرتبط بمشروع.

1B.8 Which apps to license first (consultant phasing)

Most mature path: Portfolio + Demand first, then PPM + Resource, then Strategy/Roadmap when exec reporting is ready. — مسار ناضج: محفظة + طلب (Demand) أولًا → ثم مشاريع + موارد → ثم استراتيجية وخارطة طريق.

1B.9 Demand lifecycle vs Project lifecycle (do not confuse)

Demand states (governance — should we?):

Draft → Submitted → Screening → Qualified → Approved / Rejected

Project states (delivery — are we done?):

Pending → Open / Work in Progress → Closed Complete / Closed Incomplete
(+ % complete, schedule, status reports)

1B.10 Quick interview / workshop answers

2) Architecture & Data Model

Key tables:

Hierarchy (detail in §1B):

Strategic Goals / Initiatives (Strategic Planning)
 └─ Portfolio (pm_portfolio)
 └─ Program (pm_program)
 └─ Project (pm_project)
 ├─ Project Task / WBS (pm_project_task) ← Waterfall
 └─ Story / Sprint (rm_story / rm_sprint) ← Agile
Idea (idea) → promote → Demand (dmn_demand) → convert → Project
Resource plan + allocation · Cost plan + benefit plan · Roadmap overlay

3) Plugins & Activation

How to activate:

1. Navigate: All > System Applications > All Available Applications > All. — Open direct
2. Activate the SPM apps you need (PPM, Demand, Resource, Agile).
3. Guided Setup:
   Navigate: All > Guided Setup > SPM (or PPM). — Open direct

4) Guided Setup & All Options

Sections:
- Foundation — fiscal calendar, cost centers.
- Demand — stages, scoring, assessment.
- Project — methodology (Waterfall/Agile/Hybrid), templates, WBS.
- Resource — resource plans, allocation, availability.
- Agile — scrum/SAFe, story points, sprints.
- Financials — cost plans, benefit plans, budgets.
- Portfolios & Roadmaps — planning.

Important options:

5) End-to-End Process Cycle

Idea → value flow (see §1B.5):

Strategic Goal / Initiative (why)
 → Idea (Innovation — anyone submits)
 → Demand (assess, score, align to goal/portfolio, approve)
 → Project / Enhancement (convert when approved)
 → Plan: WBS or Agile, resources, cost/benefit
 → Execute: tasks / sprints, track % complete
 → Monitor: status reports, financials, portfolio RAG
 → Close → benefit realization → portfolio & strategy review

Demand lifecycle:

Draft → Submitted → Screening → Qualified → Demand → Approved/Rejected

Project lifecycle:

Pending → Open/Work in Progress → Closed Complete
(states tracked + % complete + schedule)

6) Development

Business Rule — roll up project status note

(function executeRule(current, previous) {
 if (current.percent_complete >= 100 && current.state != 'closed_complete') {
 current.work_notes = 'All tasks complete — consider closing the project.';
 }
})(current, previous);

Development topics:
- Demand assessment & scoring (Assessment Designer).
- Project templates & WBS automation.
- Resource allocation rules.
- Agile: stories, sprints, story points, velocity.
- Cost/Benefit plans + roll-ups.
- Portfolio dashboards & roadmaps.

7) Administration

Key roles:
- it_project_manager / project_manager — مدير المشروع.
- resource_manager — مدير الموارد.
- it_demand_manager — مدير الطلب.
- scrum_master, it_agile_developer — أدوار Agile.
- it_pps_user / portfolio roles.

8) Hands-on Labs

Lab 1 — Idea → Demand:
1. Navigate: All > Innovation Management > Ideas → create an idea. — Open direct
2. Promote to Demand; score it in the Demand Workbench.

Lab 2 — Project + WBS:
1. Create a Project from the approved demand.
2. Open Planning Console; build WBS tasks with dependencies.

Lab 3 — Resource Management:
1. Create a resource plan, request resources.
2. Allocate in the Resource Workbench.

Lab 4 — Agile:
1. Create stories, assign points, plan a sprint.
2. Track on the Agile Board.

Lab 5 — Financials & Portfolio:
1. Add a cost plan + benefit plan to the project.
2. Review the portfolio dashboard.

9) Best Practices & Common Mistakes

Best practices:
- Start with Demand to enforce intake governance.
- Use Planning Console for scheduling (not manual dates).
- Keep resource plans realistic (capacity vs allocation).
- Tie projects to portfolios for strategic visibility.

Common mistakes:
- إنشاء مشاريع بلا Demand (لا حوكمة دخول).
- تجاهل Resource capacity فتتعارض التخصيصات.
- خلط Program و Portfolio.

10) CIS-SPM Exam Focus

High-yield:
- Strategy → Idea → Demand → Project — see §1B (exam favorite).
- SPM vs PPM — suite vs project app (§1B.1).
- Portfolio → Program → Project → Task hierarchy.
- Demand lifecycle vs project lifecycle (§1B.9).
- Demand conversion (to project/enhancement/defect).
- Strategic alignment / goal linkage on demand & project.
- Resource Management (plan, allocation, capacity, workbench).
- Project methodologies (Waterfall/Agile/Hybrid) + Planning Console/WBS.
- Agile 2.0: stories, sprints, points, SAFe.
- Cost plan vs benefit plan; fiscal periods.
- Roadmaps & strategic planning vs project schedule.
Exam tip: — احفظ مسار الفكرة → الطلب → المشروع والفرق بين Portfolio/Program/Project.

11) Portals, Workspaces, Role Hierarchy & Feature Catalog

ملاحظة عن الروابط:
الكثير من SPM يُدار عبر Workbenches وPlanning Console وليس Portal تقليدي.

11.1 Portals & Self-service

11.2 Workspaces & Consoles (PMO/managers)

11.3 Role Hierarchy

admin
└─ it_pps_admin / spm_admin
 ├─ it_portfolio_manager
 │ └─ it_program_manager
 │ └─ it_project_manager / project_manager
 │ └─ it_project_user (team member)
 ├─ it_demand_manager → it_demand_user
 ├─ resource_manager → resource_user
 └─ scrum_master / it_agile_developer / product_owner

11.4 Full Business Cycle

Strategy / Goals (Strategic Planning)
 → Idea (Innovation) → Idea Portal
 → Demand (assess, score, prioritize) — Demand Workbench
 → Approve → Project / Enhancement / Defect
 → Plan (Planning Console): WBS, schedule, dependencies
 → Resource Plan + Allocation (Resource Workbench)
 → Execute: Waterfall tasks OR Agile stories/sprints
 → Financials: cost plan vs benefit plan, budgets
 → Monitor: status reports, % complete, risk
 → Close → realize benefits → Portfolio review → feed strategy

11.5 Feature Catalog

Process features:
- Innovation/Idea Management.
- Demand Management (intake, scoring, assessment).
- Project Portfolio Management (Waterfall/Agile/Hybrid).
- Planning Console & WBS.
- Resource Management (plans, allocations, capacity).
- Agile Development 2.0 (SAFe, stories, sprints, velocity).
- Test Management 2.0.
- Financial Management (cost/benefit plans, budgets, fiscal periods).
- Strategic Planning & Roadmaps.
- Program & Portfolio management.

Platform features used:
- Workbenches & Planning Console (drag-drop scheduling).
- Assessment Designer (demand scoring).
- Flow Designer (approvals/stage gates).
- Performance Analytics (portfolio dashboards).
- Now Assist for SPM.
- Reporting on roll-ups (program/portfolio).

12) End-to-End Implementation (Post-Activation)

اقرأ هذا بعد تفعيل تطبيقات SPM (PPM, Demand, Resource, Agile).

12.1 Application Menus map

All > Innovation Management > Ideas
All > Demand
 ├─ Demands / Demand Workbench / Assessments
 └─ Administration (stages, scoring)
All > Project
 ├─ Projects / My Projects / Planning Console
 ├─ Project Tasks (WBS) / Templates
 └─ Status Reports
All > Resource
 ├─ Resource Plans / Allocations / Resource Workbench
 └─ Availability / Capacity
All > Agile Development
 ├─ Stories / Sprints / Agile Board / Backlog
 └─ Scrum / SAFe config
All > Financial Management (Cost/Benefit Plans, Fiscal periods)
All > Strategic Planning / Roadmaps
All > Project Portfolio (Portfolios / Programs / Workbench)

12.2 Core tables to know

12.3 End-to-end build order

1. Strategy & portfolio foundation (see §1B):
   - Strategic goals / initiatives (if licensed).
   - Portfolios, programs, link to goals.
   - Roadmap (optional exec view).
2. Platform foundation:
   - Fiscal calendar/periods, cost centers, companies.
   - Roles (portfolio mgr, PM, demand mgr, resource mgr, scrum master).
3. Intake pipeline:
   - Innovation/Idea Management + Idea Portal /sp.
   - Demand Management: stages, assessment/scoring, alignment to goals.
4. Project setup:
   - Methodologies (Waterfall/Agile/Hybrid), project templates, WBS.
5. Resource Management:
   - Resource plans, allocation, capacity in Resource Workbench.
6. Agile:
   - Scrum/SAFe config, stories, sprints, story points.
7. Financials:
   - Cost plans, benefit plans, budgets, roll-ups to portfolio.
8. Flows:
   - Demand approval stage gates, project approvals.
9. Dashboards:
   - Portfolio + strategic alignment dashboards + PA.
10. Self-service:
    - Service Portal intake /sp, Employee Center /esc.
11. Test full path: goal → idea → demand → project → benefit.
12. Deploy Update Set.

12.4 All configuration pages

Study path note: — للدراسة من الصفر اتبع: STUDY_ROADMAP.md

13) Options & Instance Notes

14) Implementation Scenarios, Options, Best Practices & Customizations

Playbook: MODULE_IMPLEMENTATION_PLAYBOOK.md → SPM

14.1 Scenarios

14.2 Options matrix

14.3 Plugins

SPM/PPM (Store), Agile Development, Resource Management, Demand Management — Guided Setup SPM

14.4 Roles

Portfolio manager, project manager, resource manager, team member, executive viewer.

14.5 Common developments

Demand workflow, project templates, resource plans, timecards, Jira integration, custom dashboards, strategic alignment scoring.

14.6 Best practices

Governance board before opening idea flood; one demand evaluation model; align project method to org (agile vs waterfall).

14.7 Go-live

• [ ] Demand→project conversion tested
• [ ] Resource allocation conflicts handled
• [ ] Financial baseline approved

15) Zero-to-Hero End-to-End Implementation (Scratch → Go-Live)

Framework: MODULE_ZERO_TO_HERO_CONSULTING.md

من الاستراتيجية والأهداف → فكرة → طلب (Demand) → مشروع → موارد وميزانية → منافع — راجع §1B.

15.1 Business goals

Full strategy stack: §1B

15.2 Phase 0 — Discover (strategy & PMO)

Deliverable: strategy-to-delivery target model referencing §1B layers 1–6.

15.3 Phase 1 — Activate

SPM suite apps (as licensed): Strategic Planning, Innovation, Demand, PPM, Resource, Agile, Financials — Store + Guided Setup SPM.

15.4 Phase 2 — Strategy & portfolio (Week 1–3)

لا تبدأ بمشاريع عشوائية — اربط محفظة بـ هدف استراتيجي أولًا (§1B.4).

15.5 Phase 3 — Innovation & demand (Week 2–5)

Idea portal /sp, categories, promote idea → demand, evaluation scorecard, demand stages, approval Flow, demand→project conversion rules.

15.6 Phase 4 — Project delivery (Week 4–10)

Templates, methodologies (waterfall/agile/hybrid), Planning Console WBS, milestones, status reports, link project to portfolio/program/goal.

15.7 Phase 5 — Resources & financials (Week 6–12)

Resource plans, Resource Workbench allocations, capacity conflicts, cost plan + benefit plan, fiscal periods.

15.8 Phase 6 — UAT & go-live

End-to-end: goal → idea → demand → approve → project → resource → close → benefit field.

15.9 Phase 7 — Operate

Portfolio dashboards, strategic alignment reports, benefit realization reviews, feed next planning cycle.

15.10 Master checklist

• [ ] Strategic goals + portfolio linked (§1B.4)
• [ ] Idea → Demand → Project path tested
• [ ] Demand governance board signed off
• [ ] Resource UAT · Financial baseline · Executive dashboard

16) Full E2E Practice · Pages · Requirements · Options (AR + EN)

Portfolio · Demand · Project · Resource · (Agile) · Financials.

16.1 Business goals

Strategy-to-value stack: §1B

Why buy SPM: English: Spreadsheets cannot connect strategy goals → governed intake → funded projects → resources → benefits at enterprise scale. — SPM يربط هدف استراتيجي → فكرة → طلب → مشروع → موارد → ميزانية → منفعة في منصة واحدة.

16.2 Requirements

16.3 Consultation cycle

Questions: Who approves demand? Who owns resource conflicts?
من يعتمد الطلب؟ من يحل تعارض الموارد؟

16.4 Options (A / B / C)

16.5 All pages (Navigate)

16.6 Full PDI lab (20 steps)

16.7 Sign-off

• [ ] Governance board sign-off on evaluation model · [ ] Resource managers trained · [ ] Portfolio dashboard reviewed by exec sponsor · [ ] Demand→project path documented AR+EN

§17 — Power User Playbook (SPM)

17.1 Personas

17.2 Day-in-Life — PM (Hybrid Waterfall + Agile)

1. Morning: open Planning Console → review portfolio dependencies, milestones.
2. Update task % complete; risks raised by team; mitigate or escalate.
3. Switch to Agile board → review sprint burn-down; reassign stories.
4. Timecard review at lunch — approve team timecards.
5. Cost plan check — actuals vs plan; flag if variance > 10%.
6. End of day: status report (auto from PA).

17.3 Day-in-Life — Resource Manager

1. Open /now/rm workspace — see heat-map of allocations.
2. Identify over-allocated user (>100% in week 30).
3. Re-allocate or hire freelancer; negotiate with PM.
4. Run capacity report by skill.

17.4 Top 20 SPM Scripts

1. Idea → Demand auto-promotion when votes ≥ 50

// Scheduled Job — every hour
(function {
 var idea = new GlideRecord('idea');
 idea.addQuery('state', 'submitted');
 idea.addQuery('votes', '>=', 50);
 idea.query();
 while (idea.next()) {
 var demand = new GlideRecord('dmn_demand');
 demand.initialize();
 demand.setValue('short_description', idea.getValue('short_description'));
 demand.setValue('description', idea.getValue('description'));
 demand.setValue('idea', idea.getUniqueValue());
 demand.setValue('stage', 'screen');
 demand.setValue('submitted_by', idea.getValue('opened_by'));
 var demandId = demand.insert();

idea.setValue(‘state’, ‘promoted_to_demand’);
idea.setValue(‘demand’, demandId);
idea.update();
gs.eventQueue(‘spm.idea.promoted’, idea, demandId);
}
})();

2. Demand scoring formula

var SPMDemandScorer = Class.create();
SPMDemandScorer.prototype = {
 initialize: function {},

/* Computes weighted score: strategic 40%, financial 30%, risk 20%, effort 10% /
score: function (demandSysId) {
var d = new GlideRecord(‘dmn_demand’);
if (!d.get(demandSysId)) return 0;

var strategic = this._n(d.getValue(‘strategic_alignment’));
var financial = this._npv(d);
var risk = 100 - this._n(d.getValue(‘risk_score’));
var effort = 100 - this._n(d.getValue(‘effort_score’));

var weighted = (strategic * 0.4) + (financial * 0.3) +
(risk * 0.2) + (effort * 0.1);
var rounded = Math.round(weighted);

d.setValue(‘overall_score’, rounded);
d.update();
return rounded;
},

_n: function (v) { return parseFloat(v || 0); },

_npv: function (d) {
var benefit = parseFloat(d.getValue(‘expected_benefit’) || 0);
var cost = parseFloat(d.getValue(‘expected_cost’) || 0);
if (cost <= 0) return 0;
return Math.min(100, Math.round((benefit - cost) / cost * 100));
},

type: ‘SPMDemandScorer’
};

3. Resource over-allocation detector

function detectOverAllocations(periodStart, periodEnd) {
 var conflicts = [];
 var resources = new GlideRecord('sys_user');
 resources.addActiveQuery();
 resources.addQuery('u_resource', true);
 resources.query();
 while (resources.next()) {
 var capacity = parseFloat(resources.getValue('u_weekly_capacity') || 40);
 var alloc = new GlideAggregate('resource_allocation');
 alloc.addQuery('resource', resources.getUniqueValue());
 alloc.addQuery('start_date', '<=', periodEnd);
 alloc.addQuery('end_date', '>=', periodStart);
 alloc.addAggregate('SUM', 'hours');
 alloc.query();
 if (alloc.next()) {
 var totalH = parseFloat(alloc.getAggregate('SUM', 'hours'));
 if (totalH > capacity) {
 conflicts.push({
 user: resources.getDisplayValue(),
 capacity: capacity,
 allocated: totalH,
 over: totalH - capacity
 });
 }
 }
 }
 return conflicts;
}

4. Project → Cost plan auto-create

// Business Rule on pm_project (after, insert)
(function (current) {
 var cp = new GlideRecord('cost_plan');
 cp.initialize();
 cp.setValue('task', current.getUniqueValue());
 cp.setValue('type', 'planned');
 cp.setValue('cost', current.getValue('budget_cost'));
 cp.insert();
})(current);

5. Burn-down chart data API

function burnDown(sprintSysId) {
 var s = new GlideRecord('rm_sprint');
 if (!s.get(sprintSysId)) return null;
 var start = new GlideDateTime(s.getValue('start_date'));
 var end = new GlideDateTime(s.getValue('end_date'));
 var totalPoints = 0;

var st = new GlideRecord(‘rm_story’);
st.addQuery(‘sprint’, sprintSysId);
st.query();
while (st.next()) {
totalPoints += parseInt(st.getValue(‘story_points’), 10) || 0;
}

var days = [];
var d = new GlideDateTime(start);
while (d.compareTo(end) <= 0) {
var done = new GlideAggregate(‘rm_story’);
done.addQuery(‘sprint’, sprintSysId);
done.addQuery(‘state’, ‘done’);
done.addQuery(‘sys_updated_on’, ‘<=’, d);
done.addAggregate(‘SUM’, ‘story_points’);
done.query();
var burned = done.next() ? parseInt(done.getAggregate(‘SUM’, ‘story_points’), 10) : 0;
days.push({ date: d.getDate().getValue(), remaining: totalPoints - burned });
d.addDaysLocalTime(1);
}
return { total: totalPoints, days: days };
}

6. Status RAG calculator

var SPMRAGCalculator = Class.create();
SPMRAGCalculator.prototype = {
 initialize: function {},

/* Returns ‘green’ | ‘amber’ | ‘red’ /
calc: function (projectSysId) {
var p = new GlideRecord(‘pm_project’);
if (!p.get(projectSysId)) return ‘unknown’;
var schedule = this._schedule(p);
var cost = this._cost(p);
var risk = this._risk(p);

var worst = Math.max(schedule, cost, risk);
if (worst >= 2) return ‘red’;
if (worst >= 1) return ‘amber’;
return ‘green’;
},

_schedule: function (p) {
var planned = new GlideDateTime(p.getValue(‘planned_end_date’));
var current = new GlideDateTime(p.getValue(‘end_date’));
var diffDays = (current.getNumericValue() - planned.getNumericValue()) /
(1000 * 60 * 60 * 24);
if (diffDays > 14) return 2;
if (diffDays > 0) return 1;
return 0;
},

_cost: function (p) {
var plan = parseFloat(p.getValue(‘budget_cost’) || 0);
var act = parseFloat(p.getValue(‘actual_cost’) || 0);
if (plan <= 0) return 0;
var over = (act - plan) / plan;
if (over > 0.1) return 2;
if (over > 0) return 1;
return 0;
},

_risk: function (p) {
var r = new GlideAggregate(‘pm_project_risk’);
r.addQuery(‘project’, p.getUniqueValue());
r.addQuery(‘state’, ‘!=’, ‘closed’);
r.addQuery(‘severity’, ‘IN’, ‘4,5’); // high/critical
r.addAggregate(‘COUNT’);
r.query();
var critRisks = r.next() ? parseInt(r.getAggregate(‘COUNT’), 10) : 0;
if (critRisks > 3) return 2;
if (critRisks > 0) return 1;
return 0;
},

type: ‘SPMRAGCalculator’
};

7. Milestone slip alert

// Scheduled Job — daily
(function {
 var ms = new GlideRecord('pm_project_task');
 ms.addQuery('is_milestone', true);
 ms.addQuery('state', '!=', 'complete');
 ms.addQuery('planned_end_date', '<', new GlideDateTime());
 ms.query();
 while (ms.next()) {
 gs.eventQueue('spm.milestone.slipped', ms,
 ms.getValue('project'), ms.getValue('number'));
 }
})();

8. Capacity vs demand chart data — GlideAggregate on resource_plan.requested_hours grouped by month.

9. Strategic goal alignment scorer — sum of weighted demand scores per goal.

10. Project Cloning — Use Project Template + clone via new sn_pm.ProjectCloneUtil().clone(srcId).

11-20. Quick recipes

§18 — From-Scratch Implementation (Day 0 → Day 30)

18.1 Day-by-day

Day 0 — Strategy & governance model
- Strategic goals (3-5 enterprise level)
- Portfolio structure
- Decision rights (RACI for stage-gate decisions)
- Demand types (Project, Enhancement, Operational)

Day 1 — Plugins

- com.snc.sdlc.scrum.pp
- com.snc.financial_planning_workspace
- com.sn_planning_console_workspace
- com.snc.demand_management
- com.snc.resource_management
- com.snc.cost_plan_v2

Day 2-3 — Portfolio + Program hierarchy
- 3-5 portfolios (Digital, Modernization, Compliance, etc.)
- Programs under each
- Strategic alignment to enterprise goals

Day 4 — Idea Portal config — /sp?id=ideas
- Categories
- Voting enabled
- Auto-promotion threshold

Day 5-6 — Demand stage gates
- Screen → Qualify → Approve → Reject/Backlog
- Scoring criteria (strategic, financial, risk, effort)
- Sponsor approval flow

Day 7-8 — Project templates
- Waterfall (Initiation → Planning → Execution → Closure)
- Agile (Sprint 0 → Sprint N)
- Hybrid

Day 9 — Task hierarchy + dependencies
- Phase → Task → Sub-task
- FS, SS, FF, SF dependencies
- Critical path

Day 10 — Planning Console
- Multi-project Gantt
- Dependencies visualization
- Resource conflict overlay

Day 11 — Project status reporting
- Weekly status template
- Auto-RAG calculator (script #6)

Day 12-13 — Resource pool
- Capacity per user
- Skill catalog
- Cost rates (by role)

Day 14 — Resource Plans
- Project requests resources by role + skill
- Resource manager approves/assigns
- Conflict resolution UX

Day 15 — Allocations + conflict detection (script #3)

Day 16-17 — Timecards
- Bi-weekly cycles
- Approval workflow (PM + manager)
- Categories: project, vacation, training, admin

Day 18-19 — Cost plans
- Labor (rates × hours)
- Vendor / contract costs
- Capex vs Opex
- Variance reports

Day 20 — Benefits tracking
- Planned benefit per project
- Actual measurement post-go-live
- Realization waterfall report

Day 21 — Risks + Issues register
- Risks: pre-occurrence, probability × impact
- Issues: occurred, mitigation, owner

Day 22 — Change requests on projects (scope changes)

Day 23-24 — Agile setup
- Scrum / Kanban / SAFe
- Boards
- Backlog grooming
- Sprint planning
- Story points + velocity

Day 25 — Dashboards
- Executive (RAG, ROI, alignment)
- Resource (utilization, conflicts)
- Project (Gantt, burn, cost)
- PA: Demand throughput, project health trend

Day 26 — Now Assist
- Project status auto-summary
- Risk identification
- Resource recommendation

Day 27 — ATF — 10 scenarios across demand, project, resource

Day 28 — Training
- PMs (2 days)
- Resource managers (1 day)
- Team members (½ day)
- Executives (1h dashboard tour)

Day 29 — Pilot with 5 projects across 2 portfolios

Day 30 — Full launch + Hypercare

18.2 KPIs Month 1

§19 — CIS-PPM / SPM Exam & Z-to-Hero Feature Labs (with 40 inline questions)

No external exam bank exists — this section provides 40 CIS-style questions inline.

19.1 Z-to-Hero Feature Labs (12 labs)

19.2 40 SPM/CIS-PPM Practice Questions

Demand & Strategy (Q1-Q10)

1. Where does Idea promotion to Demand happen?
   A. Service Portal | B. Demand Workbench | C. Idea record action | D. Both A and C — Answer: D

2. Demand scoring formula uses what default weights (strategic / financial / risk / effort)?
   A. 25/25/25/25 | B. 40/30/20/10 | C. 50/30/10/10 | D. Custom always — Answer: B (default in SPMDemandScorer)

3. Strategic alignment links Demand to:
   A. Project | B. Goal | C. Initiative | D. B and C — Answer: D

4. Portfolio vs Program difference?
   A. Same | B. Portfolio = collection of programs; Program = collection of related projects | C. Reversed | D. Random — Answer: B

5. Idea state for “approved to become Demand”:
   A. promoted_to_demand | B. approved | C. qualified | D. closed — Answer: A

6. Who approves Demand by default?
   A. Anyone | B. Sponsor (defined on Demand) | C. PMO | D. Resource Manager — Answer: B

7. Demand stage screen means:
   A. Approved | B. Initial validation before scoring | C. Rejected | D. In-flight — Answer: B

8. Strategic goal table:
   A. pm_project | B. strategy_goal | C. dmn_demand | D. pm_initiative — Answer: B

9. Demand → Project conversion preserves:
   A. Score | B. Sponsor | C. Cost estimates | D. All of the above — Answer: D

10. Demand fiscal year is set:
    A. Automatically from expected_start | B. By sponsor | C. By PMO config | D. Manual only — Answer: A (when configured)

Project Management (Q11-Q20)

11. Project task hierarchy is limited to:
    A. 3 levels | B. 10 levels | C. No limit (recommended ≤ 5) | D. 1 level — Answer: C

12. Critical path is:
    A. Longest sequence of dependent tasks determining min project duration | B. Most expensive | C. Highest risk | D. First sequence — Answer: A

13. Milestone is identified by:
    A. is_milestone = true | B. Task type = milestone | C. Both | D. None | Answer: C

14. RAG status comes from:
    A. PM judgment | B. Schedule + Cost + Risk auto-calculator | C. Sponsor | D. Random — Answer: B (when SPMRAGCalculator is configured)

15. Project template includes:
    A. Tasks only | B. Tasks + Milestones + Roles + Cost Plan template | C. Just dates | D. Resources only — Answer: B

16. Dependency types in Planning Console:
    A. FS only | B. FS, SS, FF, SF | C. AND/OR | D. Hard/soft — Answer: B

17. Project state “open” means:
    A. In execution | B. Not yet started | C. Both A and B (depending on sub-state) | D. Closed — Answer: C

18. Closing a project requires:
    A. All tasks complete | B. Benefits captured | C. Final cost actuals | D. All above — Answer: D (best practice)

19. Project Risks differ from Issues:
    A. Risk = future, may occur; Issue = already occurred | B. Same | C. Risk is higher priority | D. Issue is higher — Answer: A

20. Earned Value (EV) calculations require:
    A. Cost actuals + % complete | B. Budget only | C. Just schedule | D. None — Answer: A

Resource Management (Q21-Q30)

21. Resource Plan request states include:
    A. Requested → Confirmed → Allocated | B. Just one state | C. Pending only | D. Random — Answer: A

22. Over-allocation is when:
    A. User assigned > 40h/week | B. User assigned > capacity field | C. User booked on > 5 projects | D. Random — Answer: B

23. Capacity field is on:
    A. Project | B. User (sys_user.u_weekly_capacity) | C. Role | D. Department — Answer: B

24. Allocation conflicts can be resolved via:
    A. Hire freelancer | B. Reschedule projects | C. Reduce scope | D. All — Answer: D

25. Timecards default cycle:
    A. Daily | B. Weekly | C. Bi-weekly | D. Monthly — Answer: B (most common, but configurable)

26. Time category examples:
    A. Project, vacation, training, admin | B. Just project | C. Random | D. Hourly only — Answer: A

27. Resource manager view URL:
    A. /now/rm | B. /now/sow/home | C. /sp?id=rm | D. /rm.do — Answer: A

28. Skill match for resource request:
    A. Exact only | B. Hierarchical (e.g., Senior includes Mid) + Exact | C. Manual only | D. Random — Answer: B

29. Resource Bench reports:
    A. Users not assigned to anything | B. Just contractors | C. Just managers | D. Random — Answer: A

30. Cross-project resource scheduling uses:
    A. Manual coordination | B. Planning Console + Resource Workbench | C. Email | D. Spreadsheets — Answer: B

Financials & Agile (Q31-Q40)

31. Cost Plan vs Actuals tracking field:
    A. planned_cost vs actual_cost | B. budget vs spend | C. Same | D. No tracking — Answer: A

32. Benefit realization tracking starts:
    A. At project end | B. At demand approval | C. Throughout project + post-go-live | D. At cost plan creation — Answer: C

33. Variance threshold for “Amber” RAG cost:
    A. 5% | B. 10% | C. 20% | D. Configurable — Answer: D (10% common default)

34. Multi-currency cost normalization uses:
    A. Manual conversion | B. ServiceNow fx_rate table + scheduled refresh | C. External tool | D. None — Answer: B

35. Agile board types:
    A. Scrum only | B. Kanban only | C. Scrum + Kanban + Custom | D. None — Answer: C

36. Story states (typical):
    A. To Do → In Progress → Done | B. New → Active → Closed | C. Both depending on board | D. Random — Answer: C

37. Sprint burn-down measures:
    A. Story points remaining over time | B. Cost burn | C. Velocity | D. Quality — Answer: A

38. SAFe Program Increment (PI) duration default:
    A. 1 week | B. 2 weeks | C. 8-12 weeks (5 iterations) | D. 1 year — Answer: C

39. Velocity = ?
    A. Story points completed per sprint (rolling avg) | B. Bugs fixed | C. Cost | D. Schedule slip — Answer: A

40. OKR scoring:
    A. Always 0 or 1 | B. 0.0 to 1.0 per Key Result, then average | C. % alone | D. Hard targets — Answer: B

19.3 What “Hero” looks like for SPM

Implements full strategy-to-delivery: portfolio + programs, demand intake with scoring, project templates (waterfall + agile), resource capacity + conflict resolution, cost + variance, benefits realization, RAG dashboards, Now Assist for project status summary.

Hands-on Labs — مختبرات عملية

Step-by-step labs for PDI / Australia instance. Replace {BASE} with your instance URL.
مختبرات خطوة بخطوة — استبدل {BASE} برابط نسختك.

1. Lab 1 — Strategic goal / هدف استراتيجي — Create goal in {BASE}/now/strategic-planning/home; link to initiative.

2. Lab 2 — Idea → Demand / فكرة → طلب — Submit idea at {BASE}/idea_list.do; promote to Demand.

3. Lab 3 — Demand scoring / تقييم الطلب — Score demand in Demand Workbench; approve or reject.

4. Lab 4 — Project from Demand / مشروع من طلب — Convert approved demand to project at {BASE}/pm_project_list.do.

5. Lab 5 — WBS & tasks / هيكل العمل — Build project plan with phases, tasks, dependencies.

6. Lab 6 — Resource plan / خطة موارد — Create resource plan; allocate hours to project tasks.

7. Lab 7 — Agile story / قصة Agile — Create story on board {BASE}/rm_story_board.do; complete sprint.

8. Lab 8 — Roadmap view / خارطة طريق — Visualize initiatives on {BASE}/now/roadmap/home.

Best Practices — أفضل الممارسات

Deployment Checklist — قائمة النشر

Direct URLs Quick Reference