Skip to Content


You must be Logged on to comment or reply to a post.

  1. Denica Baeva Post author

     Putting the default value as the column name that is used in the IN condition unfortunately excluded nulls from the result if you skipped the input parameter. Putting the ”’ALL”’ work as a default input parameter but the language has to be SQL not Column Engine. For this option I had to go back to Studio because it wasn’t available in the Web Workbench.

    1. Daniel K

      Hi Denica Baeva

      Thanks for the blog, it helped me a lot in times of trouble.

      BTW, you have kept “ALL” in expression editor. For which column, you have mentioned like this ?  I assume this is for multiple values, but is it still work for “Is Mandatory” – checked or unchecked ?



      HANA Developer

  2. Former Member

    Good blog Denica. Thanks for sharing it.


    By the way, am right now pondering over an security issue with the construct of the “sample call” you shared – where the filter values are passed openly (unencrypted)! what if the user is was allowed access to TORONTO and then they debug and chage it to LOS ANGELES from the UI code.. is there a simple way to prevent this kind of data tampering?




    1. Denica Baeva Post author

      This is kind of late but if the users have two separate HANA Accounts the quick and dirty way to do it is have a function that returns select current_user from dummy. Have a table that stores the HANA user to city mapping. Join the two to get the current user’s regions and then use those regions as part of an inner join filter in your graphical CV. So then even if they enter LOS ANGELES they wouldn’t get any data.

  3. Oliver Schmidt

    Hi Denica,

    Great Blog and thanks for the Input.

    What ist the reason you use Input parameters for simple filtering problems?
    You state that one of your reason is that you want to ‘ Have filters that get passed down to the base query via input parameters in graphical views.’

    I face a smiliar problem now and tried to find out if the normal odata Filter statement even has this problem.

    Ongoing from this Blogpost i anaylzed the sql statement that was generated by odata by adding “&profile=html” to my odata query.
    I got the generated sql statement and anlyzed it with the PlanViz Tool in Eclipse and saw that the SQL Engine pushes down the Filters to the Tables on it’s own. I even use nested Calculation View and still the where statement is pushed down to the bottom of the execution plan.

    Are my queries not complex enough or are there special queries where the Input Parameter makes a difference for Filtering?


    Oliver Schmidt

  4. Rajaganapathi Rangdale Srinivasa Rao

    Hi Denica,

    I need your guidelines on this approach

    I followed the exact steps mentioned in this blog.  But when trying to display the data through calculation view I’m getting either 0 records (For Option 2 & 3 of “Running CV Alone”) or an error message (for Option 1 of “Running CV Alone”).  I’m currently using HANA 1.0 SPS12

    Also could you please help me in understand the point 3 on the prerequisites for Odata services.

    “Make sure that that the input parameter filter had a default ‘ALL’ value for the drop down”.

    Thanks in advance.




  5. Rohit Malik

    This was a very interesting blog and I sincerely want to thank for your efforts.

    I have couple of questions.

    1. Is it better to put $filters in the URI or should we have Input parameters for the better performance of Odata Service and Calculation View? In my project, the service could be looking for billions and billions of records, but since i dont have access to large amount of data, i am unable to do the comparison.
    2. I am fetching data from multiple sources and I have calculation views for some of these sources. If i try to consume these already existing Calculation Views from a parent calculation view, Input Parameters on the child view doesn’t work..Is there anything i might be missing out if i want to pull data from child view with input parameters via parent view using xsodata service?


    1. siva palaniswamy

      Hi Rohit,

      1. Having input parameter to the service help performance for huge volume than filtering at the end point.
      2. Check if you have managed mapping between parent and child views. Also make sure the input parameter in child view is filtered against the column in a expression for graphical view. If scripted view, then the input parameter can be passed to where condition like :input_parameter.






Leave a Reply