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

[dimitris_emmanoulopoulos2]

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

[former_member631142 · Accepted solution]

Hi Dimitris,

Please try with below statement:

inner join ( SELECT "SalespersonCode" FROM "_SYS_BIC"."sap.test/IDMS_BI_ISVALIDSALESPERSON"
(PLACEHOLDER."$managerUserCode$"=>:managerUserCode, PLACEHOLDER."$userCode$"=>:userCode)
)

[former_member631142 · Accepted solution]

One correction in the answer:

(PLACEHOLDER."$$managerUserCode$$"=>:managerUserCode, PLACEHOLDER."$$userCode$$"=>:userCode))

[dimitris_emmanoulopoulos2 · Accepted solution]

Thank you!