Custom field in EPPM WBS structure

[FranciscoCosta]

Dear experts,

Our client has a requirment to have a field that indicates how far along a project or a WBS is. To meet thos requirement, we have created the custom field "Project Execution".

This printscreen shows how the custom field was created.

However we are facing two issues:

1 - The first issue is that we are only being able to record values, for this field, for the WBS elements not for the project. When we try to save values for the project, after saving, the field value goes back to 0.00.

2 - The customer also wants this field to show up in a custom report that we have built. However, for the column Project Execution, its rows are being filled in with the maximum value, which is not correct.

Best regards,

Francisco Costa

[14seeryt]

Hello Customer We helped you to accept the answer, since there were no updates after 7 days. You can unaccept it anytime if you have further questions. Best Regards, Tim

[Chuma · Accepted solution]

Hello @FranciscoCosta 

Thank you for your question. The screenshots are very helpful.

You are addressing two separate issues:

1st, Value resets on the project header

Your field is created in the WBS (Project Element) business context, so it saves on PRPS only. The project header PROJ has nowhere to store it - it snaps back to 0.

Fix: create a second field in the Project header context and enable it in UIs and the Reports and If you want the header to reflect WBS progress, add a small derivation avg/max/weighted in Custom Fields & Logic on the Project header.

2nd, The report shows the maximum everywhere

Analytics is treating your numeric field as a measure and aggregating it.

Fix: in Custom Fields & Logic - field - General Information, set Aggregation to None or Average if that’s your logic.
Then, in your custom query/report, set the field’s Exception Aggregation to None/Average accordingly. Republish and refresh.

Use the Checklist below;

• Create a Project header field and keep the existing WBS field.
• Enable both under UIs and Reports for the apps/cubes you use.
• Set proper aggregation, republish, and refresh the report cache.
• (Optional) Add roll-up logic from WBS - Project.

Refer to the SAP documentations below;

SAP Help Portal – Creating Custom Fields & enabling for UIs and Reports

SAP Help Portal – Custom Analytical Queries (Fiori app): Measures & Exception Aggregation

Let me know if it works

With best regards

Chuma

[FranciscoCosta · Accepted solution]

.

[FranciscoCosta · Accepted solution]

For the fields that I am trying to create, the system, for the Aggregation field, only shows the values: Sum, Maximum and Minumum...