How to Administer DataStore Objects (Advanced) in SAP BW/4HANA

DataStore Objects (Advanced) are the main objects for storing transaction data in SAP BW/4HANA. They can be defined using fields or InfoObjects, and they can have different properties and types depending on the scenario. DataStore Objects (Advanced) can be used for staging, standardization, data mart, or reporting purposes.

To administer DataStore Objects (Advanced) in SAP BW/4HANA, you need to use the BW/4HANA Cockpit, which is a web-based tool that provides various functions for managing and monitoring your data warehouse. In this blog post, we will show you how to use the BW/4HANA Cockpit to perform some common tasks related to DataStore Objects (Advanced), such as:

• Creating and activating DataStore Objects (Advanced)
• Loading data into DataStore Objects (Advanced)
• Managing requests and data records in DataStore Objects (Advanced)
• Deleting data from DataStore Objects (Advanced)
• Viewing the technical details of DataStore Objects (Advanced)

Creating and Activating DataStore Objects (Advanced)

To create a DataStore Object (Advanced), you need to follow these steps:

1. In the BW/4HANA Cockpit, go to the Modeling tab and choose New > DataStore Object (advanced).
2. In the wizard, enter a name and description for your DataStore Object (Advanced) and choose Next.
3. In the General step, choose the properties that you need for your DataStore Object (Advanced). For example, you can choose whether to generate an external SAP HANA view, whether to enable snapshot support, whether to enable unique data records, etc. Choose Next.
4. In the Details step, select the InfoObjects or fields that you want to include in your DataStore Object (Advanced). You can also create groups to organize them. Choose Next.
5. In the Settings step, you can optionally define partitions, secondary indexes, or technical settings for your DataStore Object (Advanced). Choose Next.
6. In the Summary step, review your settings and choose Finish.

You have now created a DataStore Object (Advanced) in your BW project. To activate it, you need to right-click on it and choose Activate.

Loading Data into DataStore Objects (Advanced)

To load data into a DataStore Object (Advanced), you need to create a Transformation and a Data Transfer Process (DTP) between your source object and your target object. A Transformation defines the rules and logic for transforming data from the source to the target. A DTP defines the parameters and settings for executing the data transfer process.

To create a Transformation and a DTP, you need to follow these steps:

1. In the BW/4HANA Cockpit, go to the Modeling tab and right-click on your source object (such as a DataSource, an InfoSource, an Open ODS View, etc.) and choose Create > Transformation.
2. In the wizard, enter a name and description for your Transformation and choose Next.
3. In the Target Object step, choose your DataStore Object (Advanced) as the target object and choose Next.
4. In the Rule Group step, choose whether you want to create a single rule group or multiple rule groups for your Transformation. A rule group is a set of rules that apply to a subset of records based on certain conditions. Choose Next.
5. In the Summary step, review your settings and choose Finish.
6. Right-click on your Transformation and choose Create > Data Transfer Process.
7. In the wizard, enter a name and description for your DTP and choose Next.
8. In the Extraction Mode step, choose whether you want to load data in full mode or delta mode. In full mode, the entire dataset of the source is transferred to the target; in delta mode, only the data that was posted to the source since the last data transfer is transferred. Choose Next.
9. In the Processing Mode step, choose whether you want to process data in serial mode or parallel mode. In serial mode, the data is processed one package after another; in parallel mode, the data is processed in multiple packages simultaneously. Choose Next.
10. In the Error Handling step, choose how you want to handle errors during the data transfer process. You can specify whether you want to update erroneous records into an error stack or not; whether you want to update correct records into a separate request or not; whether you want to continue or stop the data transfer process in case of errors; etc. Choose Next.
11. 11. In the Summary step, review your settings and choose Finish.

You have now created a Transformation and a DTP for your DataStore Object (Advanced). You can execute your DTP by right-clicking on it and choosing Execute.

Managing Requests and Data Records in DataStore Objects (Advanced)

To manage requests and data records in a DataStore Object (Advanced), you need to use the Data Management tab in the BW/4HANA Cockpit. There, you can find a tile named DataStore Object, which provides various functions for administering your DataStore Objects (Advanced), such as:

• Displaying the requests and data records in the inbound table, the active table, or the change log of your DataStore Object (Advanced).
• Activating the requests or data records in the inbound table of your DataStore Object (Advanced).
• Deleting the requests or data records from the inbound table, the active table, or the change log of your DataStore Object (Advanced).
• Compressing the requests or data records in the active table of your DataStore Object (Advanced).
• Rebuilding the requests or data records in the active table of your DataStore Object (Advanced) from the inbound table or the change log.
• Displaying the statistics and logs of your DataStore Object (Advanced).

To perform any of these functions, you need to select your DataStore Object (Advanced) from the list and choose the corresponding button.

Deleting Data from DataStore Objects (Advanced)

To delete data from a DataStore Object (Advanced), you have two options:

• You can delete requests or data records from the inbound table, the active table, or the change log of your DataStore Object (Advanced) using the Data Management tab in the BW/4HANA Cockpit, as explained in the previous section.
• You can delete data selectively based on certain criteria using a Delete DTP. A Delete DTP defines the parameters and settings for deleting data from a target object based on a source object.

To create a Delete DTP, you need to follow these steps:

1. In the BW/4HANA Cockpit, go to the Modeling tab and right-click on your source object (such as an InfoObject, an InfoSource, an Open ODS View, etc.) and choose Create > Delete DTP.
2. In the wizard, enter a name and description for your Delete DTP and choose Next.
3. In the Target Object step, choose your DataStore Object (Advanced) as the target object and choose Next.
4. In the Filter Options step, define the filter criteria for deleting data from your target object based on your source object. You can use constants, variables, formulas, or routines to specify the filter values. Choose Next.
5. In the Summary step, review your settings and choose Finish.

You have now created a Delete DTP for your DataStore Object (Advanced). You can execute your Delete DTP by right-clicking on it and choosing Execute.

Viewing the Technical Details of DataStore Objects (Advanced)

To view the technical details of a DataStore Object (Advanced), such as its DDIC elements, SAP HANA views, SQL views, etc., you need to use the Properties tab in the BW/4HANA Cockpit. There, you can see information about your DataStore Object (Advanced) and use the links provided to navigate to the relevant information.

Conclusion

In this blog post, we have explained what DataStore Objects (Advanced) are, how they work, and how you can administer them in SAP BW/4HANA. We have shown you how to use the BW/4HANA Cockpit to perform some common tasks related to DataStore Objects (Advanced), such as creating, activating, loading, managing, deleting, and viewing them.

DataStore Objects (Advanced) are powerful and flexible objects for storing transaction data in SAP BW/4HANA. They can be used for different scenarios and purposes in your data warehouse.

We hope you have found this blog post useful and informative. If you have any questions or feedback, please feel free to leave a comment below.

Disclaimer: This content is generated by AI.