Skip to Content
avatar image
Former Member

Call a Graphical Calc view with input Parameters from a Script Based Calc View

Hi All.

I am trying to call a graphical calculation view with input parameters from a script based calculation view as below but getting syntax error:

SESSION_SAMPLE = SELECT SESSION_CREATE_DATE,SHA256,CA_MEASURE

                             FROM "_SYS_BIC"."WILDFIRE/CV_SESSION_SAMPLE"

                             WITH PARAMETERS  ('PLACEHOLDER' = ('$$IP_START_DATE$$',:START_DATE),

                                 'PLACEHOLDER' = ('$$IP_END_DATE$$',:END_DATE));

START_DATE  and END_DATE are input parameters of the script based calculation view.

Can anyone please help me with the correct syntax for accomplishing this?

Thanks,

Goutham

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Jul 08, 2014 at 08:10 AM

    Have a look on this thread

    Regards,

    Krishna Tangudu

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 08, 2014 at 08:56 AM

    Please check the document below, it has screenshots for achieving the similar syntax.

    Implementation of WTD, MTD, YTD in HANA using Script based Calc View calling Graphical Calc view

    Ravi

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 08, 2014 at 03:25 AM

    Hi,

    This should work,

    SESSION_SAMPLE = SELECT SESSION_CREATE_DATE,SHA256,CA_MEASURE

                                 FROM "_SYS_BIC"."WILDFIRE/CV_SESSION_SAMPLE"

                                   ('PLACEHOLDER' = ('$$IP_START_DATE$$','$$START_DATE$$'),

                                     'PLACEHOLDER' = ('$$IP_END_DATE$$','$$END_DATE$$'));

    Regards,

    Vinoth

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Gautham,

      One more option  what i would like you to try is the below option , here i have just changed the order of passing nothing else.

      SESSION_SAMPLE = SELECT SESSION_CREATE_DATE,SHA256,CA_MEASURE

                                   FROM "_SYS_BIC"."WILDFIRE/CV_SESSION_SAMPLE"

                                     ('PLACEHOLDER' = ('$$IP_END_DATE$$','$$END_DATE$$'),

                                    'PLACEHOLDER' = ('$$IP_START_DATE$$','$$START_DATE$$'))

                                      

      Regards,

      Vinoth

  • Jul 08, 2014 at 05:30 AM

    Hi Gautham,

    Can you check with single input parameter instead of two and let me know if it works fine.

    Regards,

    Vinoth

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 08, 2014 at 11:45 AM

    Hi Goutham,

    Can you try this one?

    SESSION_SAMPLE = SELECT SESSION_CREATE_DATE,SHA256,CA_MEASURE

                                 FROM "_SYS_BIC"."WILDFIRE/CV_SESSION_SAMPLE"

                                 WITH PARAMETERS  (PLACEHOLDER.'$$IP_START_DATE$$' => :START_DATE,

                                     PLACEHOLDER.'$$IP_END_DATE$$' => :END_DATE);

    --

    Shreepad

    Add comment
    10|10000 characters needed characters exceeded