House Keeping activities in a non cumulative ADSO (Inventory)

[Oscar_Alberto]

Hi guys.

I am in the process of carrying out maintenance activities on the inventory cube, as you well know this cube is non-cumulative.

I would like to do one delete per day but in transaction DELETE_FACTS I don't see the 0CALDAY feature.

Is there a better way to purge information from a non-cumulative cube?

Thanks in advance.

PS. I forgto to mention that I'm working on BW/4HANA 2.0 SP11

[umasaral · Accepted solution]

Hi 

Check the below some steps:

In BW/4HANA, managing non-cumulative cubes and performing deletions involves a different approach compared to cumulative cubes. Here are some insights and steps you can consider for purging data from a non-cumulative cube:

Understanding Non-Cumulative Cubes in BW/4HANA:

Non-cumulative cubes store data differently than cumulative cubes. They typically contain snapshots of data at specific points in time, often tied to characteristics like time periods (e.g., day, week) rather than continuously aggregating values over time.

Steps to Purge Data from a Non-Cumulative Cube:

1. Use of DELETE_FACTS Transaction
- In BW/4HANA, the traditional transaction `DELETE_FACTS` might not show 0CALDAY or other time characteristics for non-cumulative cubes because these cubes store data differently.
- For non-cumulative cubes, data is typically managed based on the characteristic that defines the non-cumulative behavior (e.g., period of non-cumulation).

2. Identify the Key Characteristics
- Determine which characteristics uniquely identify the data you want to delete. This is crucial because non-cumulative cubes are often keyed by time periods or other dimensions that define the non-cumulative behavior.
- For example, if your cube stores daily snapshots, you might identify the relevant characteristic that represents each day (like a DATE or 0CALDAY).

3. Using Data Warehousing Workbench (Eclipse)
- Navigate to the Data Warehousing Workbench in Eclipse (ADT - ABAP Development Tools).
- Find your non-cumulative cube and navigate to its maintenance options.

4. Data Deletion Strategies
- Instead of using `DELETE_FACTS`, consider using selective deletion based on the key characteristics of your non-cumulative cube.
- You can create a custom ABAP program or use standard BW/4HANA functionalities to execute selective deletes based on these characteristics.

5. ABAP Managed Database Procedures (AMDP)
- For advanced scenarios, you might leverage AMDP to implement more complex delete operations directly in the database layer, ensuring efficient and optimized data purging.

6. Consult SAP Documentation and Community
- Review the latest SAP documentation and community forums for BW/4HANA to find specific guidance and best practices for managing non-cumulative cubes and data purging tasks.

Example Approach:

Assuming your cube snapshots daily data and is keyed by 0CALDAY:
- Use BW/4HANA tools to create a selective deletion task.
- Specify the range of 0CALDAY values or other relevant characteristics.
- Execute the deletion task to remove the desired data from the cube.

Managing non-cumulative cubes in BW/4HANA involves understanding their unique characteristics and adopting appropriate deletion strategies. By focusing on key characteristics and using BW/4HANA tools effectively, you can successfully purge data while maintaining data integrity and performance in your environment. If specific tools like `DELETE_FACTS` do not support certain characteristics, custom or selective deletion methods tailored to your cube's structure are essential.

[Oscar_Alberto · Accepted solution]

Thank you @umasaral.

I will follow your advice along with @roland_szajko.

BR Oscar

[roland_szajko]

Hi Oscar

This is something available in BW/4HANA 2021:

https://help.sap.com/docs/SAP_BW4HANA/107a6e8a38b74ede94c833ca3b7b6f51/321a4042ffba4898a68003116192d...

It is possible to delete:

• Reference points
• Use date as filter criteria for the deletion (only <= supported)

br

Roland

[Oscar_Alberto]

Thank you @roland_szajko.unfortunately

[Oscar_Alberto]

Thank you @roland_szajko.

Unfortunately the version of our BW/4HANA is 2.0 SP11.

However when mananging the ADSO with non cumulatives from the BW/4HANA Cockpit I see the option where I can apply a selective deletion base on Calday. I am going to do some exercises to validate that it works correctly.

Regards

[roland_szajko]

In BW/4HANA 2.00 it is not possible to run selective deletion of movements in ADSOs with NCUM key figures based on time characteristics. This restriction was made to avoid inconsistencies that will occur when data is deleted that has not been activated and thus added to the reference points.

Yet this is already there in BW/4HANA 2021.