In SAP DataSphere, creating calculated columns in a view allows users to derive new data based on existing data within the view. Users can define formulas or expressions to perform calculations on the available columns, generating additional insights or measures that can be utilized in data analysis and reporting.
SAP Data Intelligence is an end-to-end data management and integration platform. It allows you to create calculated columns using Data Pipelines. Here's how you can create calculated columns in SAP Data Intelligence:
Open SAP Data Intelligence Studio: Log in to the SAP Data Intelligence platform and open the Data Intelligence Studio.
Create a New Pipeline: In the Data Intelligence Studio, create a new Data Pipeline. A Data Pipeline is a visual representation of data flow, where you can define data processing steps.
Add Data Source: Drag and drop a data source operator into the pipeline canvas. This operator represents the source from which you want to create the calculated column. For example, you can use a File Operator to read data from a file or a Database Operator to read data from a database.
Add Transformation Operator: After adding the data source, you need to add a Transformation Operator to the pipeline. This operator allows you to perform data transformations, including creating calculated columns.
Configure Transformation Operator: Double-click the Transformation Operator to open its configuration window. In this window, you can define the logic for your calculated column.
Create Calculated Column: In the Transformation Operator configuration, you'll see options to add new columns or modify existing columns. To create a calculated column, add a new column and define the formula or expression for the calculated value. You can use various functions, operators, and data manipulation techniques to define the formula.
Map Input Columns: If your calculated column's formula depends on other columns, you'll need to map the input columns to the transformation operator. This ensures that the calculation is performed using the correct data from the data source.
Save and Validate: Save your changes and validate the pipeline to ensure that there are no errors in the configuration.
Run the Pipeline: Once your calculated column is defined and the pipeline is validated, you can run the pipeline to process the data and create the calculated column.
View the Results: After the pipeline run is complete, you can view the output data, which will include the calculated column.