arun_vydianatha
ServiceNow Employee
ServiceNow Employee

[X-Post from Portfolio Data Model]

This article explains Portfolio data model and how portfolio gets associated to demands and projects. A portfolio is basically collection of related projects and demands. Demands were included part of portfolio starting from Fuji Release.

Demands are associated to Portfolio in a simple 1:m relation (i.e. 1 portfolio can have m demands).

d2p.png

When it comes to Project the relation between portfolio and project becomes little complex. First we need to understand two different tables - "Portfolio Projects" and "Portfolio Status".

Portfolio Projects or Project View table is associated with a project record and holds the same data as the project, such as the planned start and end dates, with some additional information related to milestones, risks, issues and goals for corresponding project. This data is basically used for reporting purposes to add views to the portfolio dashboard. Any updates to the Project propagate to the Portfolio Project as well. A project record can have many portfolio project records.

Portfolio Status is a many-to-many relationship table between Portfolio Projects and Portfolio table.

Project is related to Portfolio through the Portfolio Projects and Portfolio Status tables as shown in the diagram below.

pm2mp.png

Starting with Fuji — we support a simplified association between Project and Portfolio. A new column has been added in project table — primary_portfolio through which you can associate a project to a portfolio by simply populating the field in the project record. This way of usage supports 1:m relation between portfolio and project.

p2p.png

To summarize here are the ways to associate project and portfolio

Starting with Fuji - In the project form you can enter the primary_portfolio field with relevant portfolio you want to associate the project with. This method can be used only if you want to have a 1:m relation between portfolio and project.

Fuji and prior - When you create a project, a portfolio project record automatically gets created. And the portfolio project record needs to be associated to the portfolio. For this do the following

  1. Open the Portfolio record
  2. On the Project view related list, click Edit, and add the project (note by this you are associating the portfolio project with the portfolio)

Note: Project view related list doesn't appear you can configure Related list and bring in the related list.

Starting with Fuji Portfolio record has two related list added - Demand and Project. Project view related list is hidden, but due to prior customizations if it appears you can hide it by going to Configure -> Related Lists option

Projects not appearing in CIO Roadmap

We have seen many customer questions around projects not appearing or missing in CIO Roadmap. This is mostly caused by data issues where the project and portfolio are not related through the portfolio status table. Make sure that the projects have a proper "Portfolio Project" record created and the "Portfolio Project" record is associated to the portfolio through the "Portfolio Status" table. If the association of project and portfolio is proper through the "Portfolio Status" table then projects would appear in CIO Roadmap.

1 Comment