How use custom fields inside an interaction in an analytical COUB?

[former_member610158]

Hi,

I've added custom fields YY1_PAYMENT_STAT_MIA and YY1_ORDER_STAT_MIA to interaction object and added it to custom CDS based on I_MKT_InteractionCube. But in my custom analytical query( based on this cds) there is no data for these fields (see the screenshot below):

Note: Data for the "Order Status" field in sales orders is transmitted and displays in segmentation. E.g. ORDER_CREATED, ORDER_HANDED, ORDER_RETURNED, etc.

Also I've tried use a custom field as a restriction, but there is no data too:

How can I display these fiedls with data?

[former_member610158]

This earned. Just to rebuild the CDS on which was maden the custom analytical query. Use I_MKT_IntearctionCube as a Primary Data Source.

[former_member226]

Hi,

When a custom field is added in segmentation then correpondingly 2 fields are added

a. YY1_<FieldName>_MIA Ex: YY1_FITBITNUMBEROFSTEP_MIA

b. ACC_YY1_<FieldName>_MIA. Ex: ACC_YY1_FITBITNUMBEROFSTEP_MIA

segmentiation-config.png

So please make sure which field you are checking segmentation. If the field ID is same then CDS which is associated to Analytical query should be able to show the data.

Here I am showing some data from test system:

Else please SAP support and they can tell you the exact reason why values are not appearing.

BR
Saurabh

[former_member610158]

Thanks for the answer, Saurabh! Yes, it's correct

>Else please SAP support and they can tell you the exact reason why values are not appearing.
Try this.

BR,

Ekaterina

[former_member610158]

Btw sum of custom amounts or sum of custom fields in numbers are working. Didn't work only displaying text custom field