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]

Hello @FranciscoCosta 

My apologies for the late reply,😊

If you only see the Properties tab, it means you’re not working on a measure. In Custom Analytical Queries (CAQ), the Aggregation and Expression tabs are visible only for measures, not for characteristics.

How to activate Average.

1. In Custom CDS Views, define an Analytical Cube based on your data source and include your numeric custom field as a measure, setting a default aggregation such as Sum, Max, or Min.
2. Publish the cube, then add a Calculated Measure in Custom Analytical Queries and set Exception aggregation converted to average, using a reference characteristic such as Project/PROJ or Work. Breakdown Structure (WBS).

You also refer to the below-mentioned official SAP Documentation

• SAP Help – Custom Analytical Queries (features incl. calculated measures & exception aggregation). SAP Help Portal-Custom Analytical Queries and Services
• SAP Help/Tutorial – Building CAQ with Calculated Measures and Exception Aggregation. SAP-Create Custom Analytical Queries With Calculated Measures
• SAP Help – Create Analytical Cube in Custom CDS Views (make the field a measure first). SAP Help Portal-Creating a Cube
• KBA 2544478 – fields must have an aggregation in the CDS to be usable as measures in CAQ. SAP Support Portal-2544478 - Custom CDS View Fields Don't Appear in Custom Analytical Queries

Let me know if it works

With regards

Chuma