Skip to Content
0
Oct 23, 2019 at 03:05 PM

Call a calculation view from another calculation view with parameters issue.

164 Views

In HANA calculation view I have the following part of code:

select "SPCode",.....

from ....

inner join ( SELECT "SalespersonCode" FROM "_SYS_BIC"."sap.test/IDMS_BI_ISVALIDSALESPERSON" ('PLACEHOLDER' = ('$managerUserCode$',:managerUserCode),'PLACEHOLDER' = ('$userCode$', :userCode)) ) as isvalid on isvalid."SalespersonCode" = "SPCode"

During activation I get the following error:

Repository: Encountered an error in repository runtime extension;Model inconsistency. Deploy Calculation View: SQL: sql syntax error: incorrect syntax near ":managerUserCode": line 129 col 41 (at pos 5070)

How can I solve this issue?

Regards,

Dimitris