Issue with Field lenght 'INTERACTIONSOURCEDATAURL' Type g with length 000000 not supported

[Former Member]

Hello Experts,

In SAP Marketing Cloud, While creating a Custom CDS view having an issue with field length of the field "INTERACTIONSOURCEDATAURL" .

while keeping this field in selection fields system throwing an error "Field INTERACTIONSOURCEDATAURL_01 ignored: Type g with length 000000 not supported". Hence I could not able to see this field while creating Custom analytics Query.

Please someone help me how to overcome this error as I need to show URL field in Reports.

Thanks,

Regards,

Sudhakar Y.

[andreasfranz]

Hi Sudhakar,

currently the analytics engine does not support unstructured texts.

However there is a workaround which is documented in a blog entry:

https://blogs.sap.com/2019/02/26/how-to-use-interaction-string-fields-in-analytical-queries/

best regards

Andreas Franz