Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
jan_zwickel
Product and Topic Expert
Product and Topic Expert
This example is referenced in my other post about input parameters. Please have a look at the other post to get a better understanding of the context for this example
 

We will filter for the substring ng (e.g., oranges) in column product using SQL function LOCATE.

 

To create the example:

a)  Change in Example 2 the filter expression to:

LOCATE("product", '$$IP_1$$')

b)  Save, build, and preview the Calculation View. When asked for a value enter ng

In result you will see all records for which the value in column product contains ng:



 

Based on the past experiences the generated SQL statement should not be surprising:

SELECT TOP 1000

"date",

"product",

SUM("productRating") AS "productRating",

SUM("amount") AS "amount"

FROM "INPUTPARAMETERS_HDI_DB_1"."inputParameters.db::example3"

    (placeholder."$$IP_1$$"=>'ng')

GROUP BY "date", "product";

 

Click here to navigate back to the context in which this example is discussed. You will also find further examples there.