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 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 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.

SAP HANA - Useful formulas for Date / Time / Month / Day / Year in Calculation View

Hi,

There is a function to extract desired parts from DATE and TIME.

Function name:

• component

Syntax:

• component(date, desired_value )

Usage:

• Value for desired_value argument may be int the range 1..6, the values mean year, month, day, hour, minute, second, respectively. 
• If a component is not set in the date, the component function returns a default value, 1 for the month or the day, 0 for other components. 
• You can also apply the component function to longdate and time types.

Examples :  You can use the below formulas.

• Today Date:   NOW( )
• Year from a Date:  COMPONENT ( NOW ( ) , 1 )

SAP BW - How to see all variables and details used in a BEx query

Hi,

If you want to see a detailed list of variables used in a Bex Query, You can use one Function Module to list down.

1. Go to SE38 
2. Run FM  " RSRD_MS_GET_VARIABLE_DEF "
3. Enter QU for I_OBJECT_TYPE as input.
4. Enter the Query technical name fir I_OBJECT_ID as input.
5. Execute the FM.
6. Double click on E_T_VARIABLE_DEFINITION or value to get the complete details.

You can refer the below screenshot.

Detailed list of variables:

SAP BW - How to export Process Chains as a picture for documentations

It is very often that we need to create documentations for the objects we developed.

For Process Chains, Many take screenshots and arrange them in an order which is terribly a hard task.

There is an option in SAP itself to save the entire process chain as a JPEG picture with process chain name to your local machine.

You can follow below steps to export the process chain as a picture.

    1. Go to RSPC transaction and double click on desired process chain.
    2. Go to Process Chain menu at the top and click on "Save as Picture" option.
    3. Choose the desired location on local machine to save.

Thanks.

SAP BW - Not able to view output of Composite Provider - View or Procedure invalidated

This issue can be seen as below.

Whenever you encounter this type of issue, first you can try to create the index for composite provider records.

To create index, you can run program RSDDB_LOGINDEX_CREATE in SE38 for that composite provider.


Reason can be:

    1. These errors can be caused by inconsistencies persist in infoproviders.
    2. This is due to inconsistent column view or logical index in SAP HANA.


Thanks.

SAP BW - HANA - How to perform Delta Merge manually.

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>'

To check the history of delta merge of a table... read more.

for more details on delta merge: http://sapway.com/WILLSYS/HANADB/deltamerge.pdf

SAP BW - Column store error: search error: [2750] indexMgr index not found

Column store error: search error: [2750] indexMgr index not found

you may face this while using calculation views as a data source in BW.

If you face this issue while running Infopackage, there can be an issue with index of any of the underlying source infoprovider.

Solution:

To create index, you can run program RSDDB_LOGINDEX_CREATE in SE38 for all composite providers which are used in source calculation view.


Reason can be:

    1. These errors can be caused by inconsistencies persist in infoproviders.
    2. This is due to inconsistent column view or logical index in SAP HANA.



Thanks.

SAP BW - Value xx for characteristic yyy unknown Message no. BRAINOLAPAPI510

Value xx for characteristic yyy unknown 
Message no. BRAINOLAPAPI510


This issue is not a common issue.

This can be caused many reasons, one cause of this error could be the below one.

If you have faced this issue while loading the data with APD (Analysis Process Design) which has Bex Query as a source InfoProvider, the resolution is as follows.

This might be caused when you are frequently loading the data using Query as source.
You need to clear the cache and regenerate the report definition.

  1. Copy the technical name of Query.

  2. Goto RSRT, give the query technical name.

  3. Click on Cache Monitor, go to Cache Database

  4. Find your query and right click on query name and delete the content.

  5. Go back and click on Regenerate Report.

When its done then run the APD, Hopefully this should help to solve the issue.


If the issue is not with APD, You may check another reason and resolution which is on SCN.

https://wiki.scn.sap.com/wiki/display/BI/BRAINOLAPAPI510+-+Value+for+characteristic+unknown

SAP BW - List of SCN blog posts for BW Concepts SAP BW professional must know

• Analysis Process Designer

SAP BW - Data is not available for reporting in InfoCube though the request is completed

First of all, Unless and until it is really required; It is always better to keep the DTP setting to "Set Overall Status Automatically"

You need to set the status manually if the setting is "Set overall status manually"

If the DTP setting is set to manually, In this cass, After the request is completed the load in InfoCube it will show status in yellow color.

In such cases, You have to manually change the status to completed (green color).

While changing the status manually, You need to follow the sequence if there are more than one request.

You need to change from the bottom to top approach, You need to change for the request which is loaded to infocube first.

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 modify DSO data directly for testing purpose

It is very usual for a BW professional to have some data in DSO for testing purpose.

If you want to test with desired data, You can change the content of DSO directly in DSO table using RSINPUT tcode.

 You can use this tcode - RSINPUT

NOTE: This allows only Direct Update DSO.

       

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.