How to restrict custom measure on custom CDS View

[elena73]

Dear SAP Expert,

in a custom CDS view based on the standard view I_MKT_InteractionProduct we are calculating, based on the field InteractionProductQuantity, a custom calculated field called "quantity" that counts products quantity expressed at interaction item level for a given custom interaction "ZOrder".

We are associating this Custom CDS view with the I_Mkt_Interaction view and on top of that with I_Mkt_Initiative.

Our business requirnment is to calculate "quantity" restricting by I_MKT_InteractionProduct._MKT_Product.Brand where I_MKT_InteractionProduct._MKT_Product.Brand is equal the value of a custom field "YY1_Brand1_MIN", populated at Campaign Header level, present in the I_Mkt_Initiative view.

In example: on a "ZOrder" interaction, is calculated 10 as total quantity. 2/10 are related to products for brand x , 2/10 on y, 6/10 are related to Z.

We need to calculate "quantity" restricted on "Z" brand. "Z" should be retrived dynamically from custom field YY1_Brand1_MIN on I_Mkt_Initiative .

Do you have any suggestions on how we can achive this?

BR Stefano

[Abd_Am_K]

Hi elena73 ,

You can also checkout these blogs for the tips on how to develop cds views.

1) Custom analytics content for sap marketing cloud

2) Visualizing using CDS and MKT

Thanks

[former_member1277]

Hi elena73

If I understand you rightly, you need to add a filter on your CDS view for the field "I_MKT_InteractionProduct._MKT_Product.Brand" = Z brand.

You can consider a parameter to receive the Z Brand or make it a fixed value for the Filter.

Hope this helps !

Cheers