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

SAP BW - How to monitor Process Chains using web browser and UI5 App.

If you want to monitor process chains in web browser instead of RSPC.

     1. Go to RSPCM and add desired process chains to list to monitor.


     2. After adding, Go to RSPCM_WEB transaction tcode.

It will open an URL in web browser which will open an UI5 app provided by SAP to monitor process chains.

You can perform all basic corrections in process chains using this UI5 app in web browser it self.

If the organization allows you to access SAP URLs in personal devices / office devices like iPad / mobile / Laptop, You can use the URL of the app to monitor on the move.  

SAP BW - Blank data for few Keyfigures in BEx query designer [Solved]

This error could have been caused because of missing restriction on Auth relavant characteristics.

You should restrict all the Auth. Relevant characteristics present in InfoProvider either in query global filters or in all RKFs used in the Query.

Please check whether you have missed any of them.