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

Problem with Input Parmeters

Hi All,

I am trying to create a SQL based Calculation View.I have a two queries here.

1. I want to calculate the count of employees whose BEGDA <= DATE1 where the user gives the DATE1 as input during the runtime. Used Input Parameters and placeholder to capture this as below.But still i observed that the data is coming for all the dates.i do not know where should i assign this functional check BEGDA <= DATE1

2.If i have to calculate the employee count with the conditions BEGDA <= DATE1 and DATE1 <= ENDDA along with the existing condition STAT2='3' how should i place the Place holders in the script?Will my below script work?

BEGIN

var_out = select MANDT,

PERNR,

to_Date(BEGDA,'YYYYMMDD') as BEGDA,

to_DATE(ENDDA,'YYYYMMDD') as ENDDA,

STAT2,

case when (STAT2='3' and BEGDA<= '$$DATE1$$' and ENDDA>= '$$DATE_1$$') then count(t1.PERNR) END as EMP_COUNT,

from "_SYS_BIC"."Modelling/EMPLOYEE_DETAILS_ATV" (PLACEHOLDER."$$DATE1$$" => :DATE1)

group by MANDT,

PERNR,

BEGDA,

ENDDA,

STAT2;

END

Thank You all,

DSK

View.PNG (26.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Oct 03, 2016 at 11:42 AM

    Hello DSK,

    as you are selecting from another view in your scripted view, the operator (e.g. <=) which is used for the filter is/must be defined in a filter expression in the view you select from. As an alternative you could use a simple where-clause. How is the DATE1 parameter used in view EMPLOYEE_DETAILS_ATV?

    Your second statement will not work in that way. It has to be solved either by a filter expression in view EMPLOYEE_DETAILS_ATV or by a where clause.

    Regards,

    Florian

    Add a comment
    10|10000 characters needed characters exceeded

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.