Remodeling DataStore Objects

Objectives

After completing this lesson, you will be able to:

  • Use JSON for Remodeling DataStore Objects

Using JSON for Remodeling DataStore Objects (Advanced)

Suppose, you have already loaded data into your DataStore object (advanced) and want to add new elements (InfoObjects or fields). You may know the remodeling toolbox that is available through the SAP BW/4HANA cockpit, which allows you to manually define rules for replacement of existing data, or for deriving new values. In addition, an expert can now define a rule using JSON. This rule is then applied to the existing data by a remodeling job.

The following use cases apply:

  • Fill with constants and fields of local table

  • Fill with fields from at least one other table

In Remodeling of the ADSO you can use Filed by JSON option and create an entry such as { formula: 2 *($KEY2$ + $ATTR2$) }. When you activate the ADSO, a message informs you that this requires to run a remodeling job. Additional changes to an ADSO with data that require to execute a remodeling request include the following: change of ADSO Modeling Properties, change of ADSO key definition, change InfoObject/field criteria, change Partitions and related settings, add compounding Child InfoObject while compounding parent is already in ADSO and contains Values, change Indices and related technical settings, change field data type , change conversion type (some cases), change of Data Tiering properties (most cases), change InfoObject Master Data Check (most cases).

Remodeling with JSON is integrated into the Remodeling dialog box. You choose the Field by JSON option and enter your JSON code which must include the type of field derivation, such as formula or attribute, followed by details. In addition to defining a rule, other functions are available for validation, formatting, and for data preview.

In a JSON based rule, you can use the permitted SQL functions listed in the documentation which is a subset of the SQL functions available in SAP HANA.

Note that the system does not check whether the data types of the result of the formula match the data type of the field during the definition and check. As a user, you have to check this yourself.

Log in to track your progress & complete quizzes