no aggregation in custom views for scores possible

[chholzermsg]

Hi,

to calculate a score for contacts, I want to filter specific interactions and aggregate a custom attribute of them (i.e. sum them up).

So I thought I could create a custom view for this with an aggregation node. But when I try to import this view into the SAP Marketing Cloud, I get the error message that "Aggregation type view cannot be imported". This has to be a problem specific to scores, because, when I import the same view for segmentation, I do not get this error message.

So is there a workaround for this problem?

P.S.: I have the same issue if I use the view as describe https://blogs.sap.com/2020/11/16/building-custom-sap-hana-view-for-sap-marketing-cloud-to-segment-cu.... (besides the message that IP_JOIN_SET_ID is missing)

[Abd_Am_K]

Hi chholzer_msg ,

Please create the IP_JOIN_SET_ID parameter and also check the help link for any other scoring views requirements.

https://help.sap.com/viewer/13d84c47bb6749a188fd53915c256516/2102.500/en-US/0152466af9c04bb5be60a7be...

[chholzermsg]

Hi @abdullah.amerk,

i tried with and without the parameter. And I am pretty sure that I follow all instructions given in the application help. As said, with importing the view for segmentation everything works fine, but for scores I get this aggregation error.

[Abd_Am_K]

Hi chholzer_msg,

Did you also check these requirements

https://help.sap.com/viewer/13d84c47bb6749a188fd53915c256516/2102.500/en-US/b47365ad125b4f8c803eecb5...

• The outputViewType of the calculation view is not Aggregation.

[chholzermsg]

Hi abdullah.amerk,

I have tried this already - but no change regarding the aggregation erroe message. I now use the view in segmentation - as a workaround.

Regards

Christian

[Abd_Am_K]

Hi chholzer_msg,

I think you are creating an analytical Cube as the hana view type. It should be dimension instead. If you open your view in notepad and search for outputviewType, you will notice that it is an aggregation.

I hope this helps.

[chholzermsg]

Hi abdullah.amerk,

correct outputviewType is "aggregation".

What should it be?

Regards

Christian

[Abd_Am_K]

Hi chholzer_msg ,

When you create a view of the type Cube, the output view type is then Aggregation. I Think you have to create a view of the type Dimension. This way the outputviewtype will be Projection at the end. Also remember to add the IP_JOIN_SET_ID parameter. Its an empty parameter of the type nvarchar and length 32 with no default value. It can be created at any level in the view.

Thanks.