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 ...

Get SAP Data Services 4.x Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.