How to extract scope change or change requests in one go for all the projects ?

[abhishekthathoo]

How to extract scope change or change requests in one go for all the projects in SPM ?

[Bhuvan · Accepted solution]

@abhishekthathoo 

You can configure it from reports [sys_report table] using below conditions,

If you want to use Data Visualization, go to Application Navigator -> Platform Analytics -> Library -> Data Visualizations -> Create New Visualization and select List

In Add Data Source -> Select 'project_change_request' table and filter the data based on your requirement

Hope you appreciate the efforts to replicate this in PDI and provide a solution. If this helped you, please mark the posts helpful & accept the solution.

Thanks,

Bhuvan

[Bhuvan]

@abhishekthathoo 

Create a report or data visualization and add filter conditions from related list based on how you maintain the relationships and export in PDF or Excel.

'project_change_request' table maintains the changes requested for 'project' and you can use 'parent' field to retrieve the information of all projects related to project change requests.

Alternate option, would be to create database view table to see consolidated information.

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[abhishekthathoo]

In the report section , I have able to see only resource based tables, managed by admin, any other alternated ...can you suggest me a path .... like ' ALL ---- Platform Analytics-  Data visualization etc . ?, considering I am new to this.

[Bhuvan · Accepted solution]

@abhishekthathoo 

You can configure it from reports [sys_report table] using below conditions,

If you want to use Data Visualization, go to Application Navigator -> Platform Analytics -> Library -> Data Visualizations -> Create New Visualization and select List

In Add Data Source -> Select 'project_change_request' table and filter the data based on your requirement

Hope you appreciate the efforts to replicate this in PDI and provide a solution. If this helped you, please mark the posts helpful & accept the solution.

Thanks,

Bhuvan

[abhishekthathoo]

Thanks Bhuvan and I really appreciate your help & support for taking your time out in this community.

Thanks a lot