How to display sum of sales orders in custom campaign report?

[former_member610158]

Hi, experts!

In Custom Analytical Queries we made custom report based on Campaign Success for Messages CUBE (C_MKT_CAMPAIGNSUCCESSQ). But we can't count Sum of Interactions Amount for Sales Orders. The report displays the correct sum amount if there was one Sales Order, but when there are more orders, the indicator is not considered.

Tried next variants:

1) Restricted Measure based on Amount and Fixed value for Interaction Type includes SALES_ORDER (see screenshots below):

2) Calculated Measure without exception aggregation(see the screenshot below):

Has anyone know how to correct count this value and display that in a report?

[Abd_Am_K · Accepted solution]

Hi Ekaterina,

You need to define the Aggregation on the CDS view using the custom CDS view app. Please note that aggregations can be only previewed in the Custom analytical Query app or the Sap Analytics Cloud.

- You create a custom cds view using the I_Mkt_Interaction view. In the field selection select your amount field and in the field properties select the aggregation type (sum in this case).

- You create an analytic query on top and add the fields to the final view. The preview will show you aggregates at this point. Unless you have too many values for the viewer to support.

Best Regards,

Abdullah Amer