Skip to Content
0

How to combine two different rows into a one Single row in HANA Calculation View.

Jul 09, 2017 at 06:59 PM

115

avatar image
RUFUS SAMUEL

Hi Experts


I have a requirement as below, Kindly help me to fix this.

Normal Output
Partner Role

SAP A
SAP B
SAP C

Expected Output

Partner Role

SAP A,B,C

Here SAP has three different rows in database, But in calculation view I need to display them as a one single row in HANA.

Can some one help me to achieve this ??

Thanks

Rufus Samuel

BW SAP HANA Modeling Tools (Eclipse)
SAP S/4HANA migration object modeler | SAP HANA
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
avatar image
Christian Kalweit Answered Jul 16, 2017 at 06:54 PM
0

You could implement it as a table function and use HANA SQL function STRING_AGG.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
RUFUS SAMUEL
Dec 30, 2017 at 06:04 AM

Hi Christian

Can you please provide some sample code, so that it will be more useful to do the same for my requirment.

Thanks
Rufus Samuel

0
Christian Kalweit
Jan 08 at 07:40 PM

There's an example at SAP Help:

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.02/en-US/a924ee1e98ab435a874efa32e6f0ae14.html

0
Comment