O'Reilly logo

SAP Data Services 4.x Cookbook by Ivan Shomnikov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using math functions

Data Services has a standard set of functions available to perform mathematical operations. In this recipe, we will use the most popular of them to show you what operations can be performed on numeric data types.

How to do it…

  1. Create a new job and name it Job_Math_Functions.
  2. Inside this job, create a single dataflow called DF_Math_Functions.
  3. Import the FactResellerSales table in your DHW datastore and add it to the dataflow as a source object.
  4. Add the first Query transform after the source table and link them together. Then, open it and drag two columns to the output schema: PRODUCTKEY and SALESAMOUNT. Specify the FACTRESELLERSALES.PRODUCTKEY = 354 filtering condition in the WHERE tab:
  5. Add the second Query transform and rename it ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required