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 BW/HANA - Replicating or Removing BW Analysis Authorizations to HANA

Hello,

When you need to replicate or remove BW analysis authorizations to HANA.
You can simply run the below program with selections.
Enter the required details User IDs and List of BW Objects and execute the program.

RS2HANA_AUTH_RUN

SAP ABAP/HANA - Display DDL Source Codes in SAP GUI using ABAP Program

If you want to see the source code of DDL in SAP GUI without opening HANA Studio.

You can run this program. Eg. to see the source code of CDS view.

DEMO_SHOW_DDL_SOURCE

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 - Helpful things while Importing Transports (TRs)

Hi,

Re-importing a failed Transport request:

1. Copy the transport request number and go to Extras menu -> Other Requests -> Click on Add
2. Enter the transport number, and check Import Again check box
3. Click on Continue..

Done.


Undoing Released tasks of a transport request:

If some tasks of Transport Request are released by mistake and if you want to change the task status from 'Released' back to 'Modifiable'.

1. Go to SE38 – Execute Program RDDIT076
2. Enter the transport request Number and execute.
3. You will see STATUS field value as R for all released tasks.
4. You need to double click on the TR task, and update the STATUS field value from 'R' to 'D'.
5. Save and repeat the same for all Released tasks.

For more details:
https://blogs.sap.com/2014/01/06/how-to-change-transport-request-from-released-to-modifiable/

SAP BW - How to see full details about the BEx Query elements - Query Documentation TCODE

You can use Tcode

RSRTQ – Query Definition in Detail

You can also run program

RSRQ_QUERYDEFINITION

You can check below link for more detailed information if you need...

http://scn.sap.com/docs/DOC-26063

SAP - Finding Users list by using Role or Authorizations or profiles or any known data

You can use different reports available in SUIM transaction

SAP BW/HANA - Re-modelling pending on ADSO and must be completed before activation

You need to complete the pending Remodeling request.

1. check whether there is any pending request for remodeling in RSCNV_MONITOR
2. you can also check RSPM_MONITOR whether there is any on-going request already which is blocking activation.

SAP HANA - Transporting HANA objects using ABAP transport

Hello,

1. You can use transaction SCTS_HTA
2. Input or browse the Hana package and click on execute.
3. Choose the objects to transport and execute.
4. It will prompt to enter the Transport request details.
5. You can import the TR using STMS_IMPORT just like any other ABAP TR.

Thanks.

SAP BW/HANA - Program to Activate or Repair ADSO

You can use this ABAP report.

       RSDG_ADSO_ACTIVATE

You can use this program to..
1. Activate the DSO.
2. Correct wrong order of fields.
3. Correct hash definition.
4. Rebuild database views.
5. Correct info about semantic group.
4. Correct ref. To uom-object.

You can also simulate and repair.