Question Re: STRING_AGG function in SAP HANA SQL Script in Technology Q&A

STRING_AGG function in SAP HANA SQL Script

Former Member — Sun, 22 Jun 2014 03:43:04 GMT

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

Re: STRING_AGG function in SAP HANA SQL Script

lbreddemann — Sun, 22 Jun 2014 12:52:22 GMT

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

Re: STRING_AGG function in SAP HANA SQL Script

Former Member — Sun, 22 Jun 2014 14:46:28 GMT

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

Re: STRING_AGG function in SAP HANA SQL Script

lbreddemann — Sun, 22 Jun 2014 16:11:26 GMT

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

Re: STRING_AGG function in SAP HANA SQL Script

lbreddemann — Sun, 22 Jun 2014 16:12:06 GMT

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

Re: STRING_AGG function in SAP HANA SQL Script

ruediger_karl — Tue, 08 Jul 2014 16:27:14 GMT

Hi,

please note that the STRING_AGG() function will not be supported earlier than SPS09. So, you found an undocumented feature. For now the feature is intended for SAP-internal usage only.

Regards, Ruediger

Re: STRING_AGG function in SAP HANA SQL Script

Former Member — Wed, 10 Sep 2014 05:50:08 GMT

It seems STRING_AGG appeared in the latest SAP HANA SQL Reference. Expressions - SAP HANA SQL and System Views Reference - SAP Library

Re: STRING_AGG function in SAP HANA SQL Script

lbreddemann — Wed, 10 Sep 2014 11:29:41 GMT

Yes, as usual the documentation production is asynchronous with the actual product.

As long as product management, here represented by Ruediger doesn't release the feature officially it will stay in this half-supported state...

Re: STRING_AGG function in SAP HANA SQL Script

ruediger_karl — Mon, 29 Sep 2014 13:58:10 GMT

Hi,

good news. The STRING_AGG() feature has been released earlier than expected. It is now officially supported - rev82 onwards.

Regards, Ruediger

Re: STRING_AGG function in SAP HANA SQL Script

Former Member — Thu, 29 Jan 2015 11:51:00 GMT

It will be a cool feature if STRING_AGG function is included in the list of

Semantic-> Columns panel -> Aggregate (list)

Re: STRING_AGG function in SAP HANA SQL Script

Former Member — Tue, 31 Mar 2015 12:49:40 GMT

That would be awesome!

+1 on this idea

Re: STRING_AGG function in SAP HANA SQL Script

former_member184969 — Thu, 04 Aug 2016 16:05:23 GMT

I Just putted it in the idea place. I think it's time to advertise 🙂

Re: STRING_AGG function in SAP HANA SQL Script

former_member184969 — Thu, 04 Aug 2016 16:21:45 GMT

The STRING_AGG functions seems a bit limited by the fact that the <delimiter> has to be a constant. Is there any plan to make it compliant with variables or functions(like CHAR(13) ?

Thanks.

Re: STRING_AGG function in SAP HANA SQL Script

Astrid_Gambill — Thu, 04 Aug 2016 20:08:56 GMT

Assuming you mean this - https://ideas.sap.com/D35515 - I just gave it a thumbs up.