Skip to Content
avatar image
Former Member

How do I should use Input Parameters with multiple values on a scripted CalcView?

Hi,

I need to make some projections on a scripted Calculation View with several values in the where clause of a CE Function using multiple values from an Input Parameter. I found the way to set intervals or single values but nothing like what I'm looking for.

In SQL it should be something like:

SELECT ATTR1, sum(MEASURE1) FROM "<calc_view>" PLACEHOLDER ( "$$MONTH$$", ['val1','val2','val3','val4']) GROUP BY ATTR1;

Or like SELECT-OPTIONS in ABAP.

Does scripted calculation views have a way to filter a table by a field with several values using Input Parameters?

How do I set the Input Parameters to reach that?

How is the syntax to call that calculation view and set several values in the place holders?

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Dec 30, 2014 at 04:13 AM

    As of now input parameter does not support for multiple values like select-options in abap, but you can use input variable for achieving the same.

    Regards,

    Amol

    Add comment
    10|10000 characters needed characters exceeded

    • Amol,

      I am working on something very similar. I have a logic for the dates, then I get IP_MONTH_FROM and IP_MONTH_TO as two separate Input parameters.

      Next, I would like to fill the Default Values of one Interval Variable with those input parameters. The question is, how to? In other words, what is the syntax for something similar to RANGE-LOW and RANGE-HIGH in CMOD in BW?

      Thanks in advance for your insight.

      Dmitry

  • Jan 19, 2015 at 10:55 AM

    Hi Ivan,

    First of all, input params are not meant for filtering. And there is no direct way to pass multiple values to a input param.

    But if its a critical requirement there is a way. But will require some work around.

    Pass your values to one single input param seperated by a comma or something. Then in your script parse it and store it separately in different variables. Hope this helps you.

    Regards,

    Safiyu

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 21, 2015 at 07:25 AM

    Hello Ivan Cernigoj,

    Please go through this guide by Krishna Tangudu

    ,he explained it beautifully I hope it will solve your problem


    Using Multiple Values in Input parameter for filtering in Graphical Calculation View

    and

    SAP HANA: Handling Dynamic Select Column List and Multiple values in input parameter

    Regards

    Debasis Nayak

    Add comment
    10|10000 characters needed characters exceeded