SAP BW/HANA - Transaction RSPM_MONITOR (BW Process Monitor)

Hello,

You can use this transaction to see all BW processes of all statuses.
All the required selections are provided in this transaction

E.g., You can enter an ADSO and see all types requests performed on that ADSO such as data loads, Activations, deletions, selecting deletions, data remodeling requests. etc.,

SAP HANA - Useful formulas for STRING operations

1. If you need a sub-string from starting of the value.

      leftstr("string value or field", < length of string >)

2. If you need a sub-string from ending of the value.

      rightstr("string value or field", < length of string >)

3. If you need a sub-string from the middle of the string.

     midstr("string value or field", < length of string >)

SAP BW HANA - How to solve issue - Maximum number of rows per partition reached for [table_name]

Please try to run Delta merge manually for that table.

Hopefully, You may not get error next time.

You can check this out for more knowledge:
https://apps.support.sap.com/sap/support/knowledge/mimes/call.htm?number=2212518

SAP BW - How to generate Test Data for SAP BW Objects

For InfoCube: 

You can use this program in SE38 for only InfoCubes - CUBE_SAMPLE_CREATE.

For DSO:

You can follow below work around.

    1. Create a test infocube with fields same as your DSO.

    2. Go to SE38 and execute CUBE_SAMPLE_CREATE.

    3. Give test infocube name and number of rows and select the READY-FOR-INPUT-ALV option in input mode and execute.

    4. In the next screen, sample data will be shown.

    5. Export the output to a spreadsheet.

    6. Then you can create a flat file PSA to load the data using this exported spreadsheet.

    7. Create transformation and DTP to load data to DSO from this PSA.

SAP HANA - How to check the last DELTA MERGE performed on SAP HANA table

If you want to check the time stamp when was the last time delta merge done for a table in SAP HANA.

You can follow below simple steps.

1. Go to tables in Catalog.
2. Right click and apply filter to find quickly.
3. Double click on the table.
4. Go to Runtime Information.
5. Details will be shown on delta size and last delta merge and other details.

You will see details as below screenshot.

If you want to perform Delta Merge manually, You can use below ways.

   1. Using menu:  

1. In the Systems view, navigate to the table.
2. In the context menu of the table, choose Perform Delta Merge.
3. Choose OK.

   2. Using SQL: run the below SQL.

         MERGE DELTA OF '<table_name>'


for more details on delta merge:

http://sapway.com/WILLSYS/HANADB/deltamerge.pdf