STRING_AGG function in SAP HANA SQL Script

[Former Member]

Hi,

We have HANA Revision 7.3.

STRING_AGG function seems to work when we just execute the query without assinging it to the value.

However as soon as we assign it to a value in a stored procedure or scripted Calcuation view, it fails.

Any ideas?

Thanks,

Hyun

[lbreddemann]

Hi Hyun

provide an reproducible example, please.

At least show us your coding and the error message.

Vague problem descriptions like this are hard to  work with and you don't want to make life hard for the ones that should help you, do you?

- Lars

[Former Member]

Lars,

My apologies.

Here are 3 screen shots. Two are error message generated
when using STRING_AGG in a Calculation View, one is it running successfully in
SQL window when it is not assigned to output variable.

Thanks,

Hyun

[lbreddemann]

I cannot reproduce this with SPS 8.

In my example I set the Data Category of the calculation view to "empty" - so that no default aggregation is performed.

- Lars

[lbreddemann]

And of course, both output colums are attributes...