We use Multi-source data foundation(Universe) which connect SQL-Script CalculationView in HANA.
And the CalculationView has an InputParameter.
Derived table Expression SELECT * FROM "_SYS_BIC"."GV/ITOA"('PLACEHOLDER'=('$Z_DAY$',@Prompt(bo_para)))
$Z_DAY$ is HANA Input parameter.
bo_para is BO parameter.
Now I create WebiReport and Input Prompt value, but does not work.
The following error occurred The following database error occurred:
[Data Federator Driver] [Server] [Connector '[TEST]UNIVERSE_HANA_1.0']
The database has reported an Exception: SAP DBTech JDBC: [257] (at 67):
sql syntax error: incorrect syntax near "TO_DATE": line 3 col 55 (at pos 67)
(SQLState: HY000, Vendor code: 257). For information about this error,
please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal.
(IES 10901) (Error: INF )
<Question>
1. Could you tell me how to make an InputParameter without any error in Multi-source data foundation?
2. Please tell me SAP NOTE if an InputParameter doesn't work in the Multi-source data foundation.
I found an information as below which is from Information Design Tool User Guide. However I coundn't find on SAP NOTE for the evidence. Information Design Tool User Guide (SAP BusinessObjects Business Intelligence platform Document Version: 4.2 Support Package 5 ? 2017-12-15)
P.28 Note
SAP HANA optional input parameters are not supported on derived tables. You receive an error message when you run Check Integrity to validate a data foundation that includes a derived table containing SAP HANA optional input variables
Any pointers would be appreciated.
Thank you.
-----
SAP HANA2.0 SPS02 Rev23
BO4.2 SP5
SAP HANA database 1.0(JDBC)
-----