Skip to Content
author's profile photo Former Member
Former Member

Passing Parameters from a Universe to a Scripted View

I have had success, thanks to information provided on these pages in passing parameters from a universe to HANA graphical views; however, my application requires passing parameters to a scripted view. I have not been able to do this: when I attempt to define the view in a universe, the Information Design Tool interprets parameters as manditory and throws an error: seach on calculation model requires parameters; required variable <parameter> is not set. Can someone help me with a solution to this problem?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 02, 2014 at 03:40 PM

    Hi Steve,

    Have you tried setting a default value to the parameters in the scripted view?



    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Steve,

      By looking your screen shot, you have defined an input parameter with name "REGION" and in Script based calculation view, you are using "inregion" instead of "REGION" in placeholder.

      If possible, use UPPER CASE "REGION" instead of SMALLER CASE "region" while defining script based calculation view.

      Couple of more points:

      If you have created a semantic layer using calculation view contains input parameter in BO Information Design tools.Then later when you access the same semantic layer through BI tools then automatically prompt dialog should appears asking for values. OR With universes on a single view it is possible to use the END_SQL parameter where you add the parameters to pass to the view, something like:

      END_SQL defined as WITH PARAMETERS ('PLACEHOLDER' = ('$$CURRENCY_CODE$$', 'EUR'), 'PLACEHOLDER' = ('$$DATE$$', '09092007'))

      And you can actually use prompts instead of hard coded values.

      Please refer this document from Page No 16. [].

      Hope this helps.

      Best Regards,


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.