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.
To create calculated columns in SAP DataSphere, follow these steps:
Select the Dataset: Choose the dataset to which you want to add the calculated column.
Click on "Prepare": Click on the "Prepare" option to enter the data preparation mode.
Open "Add Calculated Column": Locate and select the option to "Add Calculated Column" in the data preparation interface.
Define the Calculation: In the calculated column editor, define your calculation using expressions, functions, and data columns. You can use the formula bar to write your calculations.
Validate and Apply: Once you've created the calculated column, validate the formula to check for any errors. If everything looks good, apply the calculated column to your dataset.
Save and Publish: After creating and validating your calculated column, save your changes, and publish the dataset to make the calculated column available for use.
Please note that the exact steps and the user interface may vary depending on the specific version of SAP DataSphere you are using. Always refer to the official documentation or user guides for the most accurate and up-to-date instructions.