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

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

October 11Hits:9
Advertisement
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

Answers

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

Read other 8 answers

Tags:

Related Articles

  • Call a Graphical Calc view with input Parameters from a Script Based Calc ViewOctober 11

    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 "_S

  • SQLPLUS Acitivity in process flow Input parameters to the scriptNovember 30

    I have a sqlplus Activity in the process flow. In the script section I have a update statement which has a where clause where I need to pass a date field as input paramter to this script to compare and update the records. Is there a way to pass Input

  • Call graphical calc view with parametersNovember 30

    Hello, We want to call a graphical calculation view that requires parameters via CE functions. Is this possible? How can we do that? Thanks, Oshrit.Hello, We still don't know, how is it possible to select from CV with parameter through CE function. T

  • Error while creating a BO Universe (using IDT) on top of SAP HANA Calculation View with Input ParametersOctober 11

    Hi All..       We are trying to create a Universe (using IDT-Version4.0) on top of the HANA Calculation view. The Calculation view has 4 input parameters, So in Universe side we have created the respective prompts. For the creation of derived table w

  • Hierarchy on HANA Calculation View with Optional Input Parameters FailsOctober 11

    Hi, Has anyone succeeded in building a hierarchy on top of a calculation view with optional input parameters, where an input parameter is not filled? The original requirement came from the wish to create a parent child hierarchy on a calculation view

  • Error when using Analytic view with Input ParametersOctober 11

    Hi, I am trying to create an info space based on my Analytic view which has input parameters. The infospace is validated and indexed without any issue. However when I ran the view, I get an error (50011) as it is unable to fetch any results. I tried

  • Using calculation view in excel with input parametersOctober 11

    Hello I have a calculation view which receives 2 input parameters for a range of dates, when i create the connecction with Excel i get the error "sql processing error: Hierarchy source query: SQL: column store error: search table error: [34092] searc

  • Questions on CDS Views with input parametersOctober 11

    Dear Experts, 1. Can we call a CDS View (or generated database view) with input parameters inside an AMDP? I am looking for something similar to the feature in HANA where we can consume calculation view with filters inside SQL Script? 2. I understand

  • Calculated view with input parametersOctober 11

    Hello there. I've created a calculated view with input parameters, which I am going to call  it  'VIEW_A'. This view has been working just fine. But now I have to create another calculated view and import the last one(VIEW_A) in a projection. But I g

  • Calculation view with input parametersOctober 11

    Hello there. I got a calculation with that expects 2 input parameters. But now I have to created another calculation view that import this calculation view. How can I pass these 2 parameters using sqlscript?   My script so far   cv1 = CE_CALC_VIEW("_

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.523 s.