cancel
Showing results for 
Search instead for 
Did you mean: 

column store error IN hana

Former Member
0 Kudos

Hi Guys,

Kindly help me on this.

I am trying to load a calculation view into a table.

select LOC  INTO L_LOC FROM (SELECT LOGSYS, STRING_AGG(CONCAT(CONCAT('''''',"STORT"),''''''),',') AS LOC


from (SELECT DISTINCT LOGSYS, STORT FROM "SIE_BDP"."SIE_BDP_PMLOC" WHERE LOGSYS = L_LOGSYS) GROUP BY LOGSYS);

I am storing the loc column into a stored variable L_LOC.

When I try to set the parameters of the calculation view and the run the procedure, it gives me a column store error.

The highlighted part throws the error. Could you please tell me how to assign a stored variable using place holder or if anything is wrong with the string_agg function.

SELECT GJAHR, MONAT, ORGUNIT, COMMODITY, ARENR, HWAER, LSART, MFESN, HERKL

FROM "_SYS_BIC"."SIE_BDP_VIEWS.Reporting/SIE_BDP_CAPPVIEW"

(

   PLACEHOLDER."$$BIP_MONAT1$$" => :L_MONAT1,

   PLACEHOLDER."$$BIP_MONAT2$$" => :L_MONAT2,

  PLACEHOLDER."$$BIP_LOC$$" => :L_LOC, (this part does not work)

   PLACEHOLDER."$$BIP_GJAHRMWPV$$" => '''2016'',''2015''',

   PLACEHOLDER."$$BIP_APPCONS$$" => 'NO') ;

Thanks ,

Jan

Accepted Solutions (0)

Answers (1)

Answers (1)

pfefferf
Active Contributor
0 Kudos

Hello Jan,

what exact error do you get? I think it is related to the double single quotes surrounding each single value you create with the STRING_AGG function.

Regards,

Florian