Skip to Content
avatar image
Former Member

HANA View Optional Input Parameter - Having issue in Universe

Hello,

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?

Thanks

VJ

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 16, 2015 at 09:14 PM

    1928536 - Native filter does not support optional prompt, althouth it is possible to define native filter with optional prompt in

    Information Design Tool

    Add comment
    10|10000 characters needed characters exceeded