HANA View Optional Input Parameter - Having issue in Universe
We have HANA views with Optional input parameter. We are using derived table in IDT and calling the HANA view using PLACEHOLDER syntax.
First we cannot use the parameter created in the universe because there is no optional option available.
So, we used the traditional @prompt syntax for optional (Like Below), the derived table was validated successfully but the universe query builder and webi report throwing "Failed to execute runnable error" error when i run the wide open optional prompt. If i select the value for the optional prompt the SQL is working.
SELECT * FROM "HANA VIEW" ('PLACEHOLDER'=('$$IN_MTRL$$',@Prompt('Enter Material','N','Lov',Mono,Free,Optional))
Couple of SAP note mentioned Optional prompt work only as a Business Filter. Is that mean the HANA view should not have Optional Input parameter and the optional parameter should only declare in the universe?