Passing Parameters from a Universe to a Scripted View

[Former Member]

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?

[Former Member]

Hi Steve,

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

Regards,

Rashmi

[Former Member]

Hi Rashmi,

Thanks for your response.  Yes I have tried that. The Information Design Tool requires that parameters not be set to mandatory.  However in a scripted calculation view, parameters by default are created as mandatory - that seems to be the cause of the problem.  In the properties view of the parameter, I set the 'Is Mandatory' value to FALSE and provide a default value.  However, this does not clear the inaccessable checkbox in the pop up window for the parameter nor does it change properties of the parameter as viewed by the IDT.

Steve

[Former Member]

Hi Steve,

Can you share the IDT query where you are passing the parameters? It will be useful to analyse the error.

-- Rashmi

[Former Member]

  Have you attempted to create a non mandatory input parameter for a scripted calculation view?

[vairma]

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. [https://scn.sap.com/docs/DOC-27676].

Hope this helps.

Best Regards,

Vaibhav