Corbu theme for BW

Changes on Infoprovider

When some changes are about the infoprovider in production environment, the queries sometime don't work correctly.
Should be some runtime errors with message like:
- InfoProvider &V1 was changed and activated during query runtime.

In order to update the cache for inforpovider you should run Abap report

RSR_MULTIPROV_CHECK

Put in the parameter the name of infoprivider mentioned in the error message.

that's all.

Program for finding invalid chains and processes

From SP 25 of BW 7 is available the report

RSPC_METADATA_CLEANUP

It's possible add the report with note 1484887

The program RSPC_METADATA_CLEANUP for finding and deleting process chains and processes that are no longer required or no longer valid does not exist.

Improve performances of InfoObject / Infoprovider

Available from P18 of BW 700, reference note 1143710.
Notes update: 1378477, 1475235, 1676451

The standard abap program RSSM_AUTODEL_REQU_MASTER_TEXT allows remove request of attributes and text of infoobject, without remove the data: this improves the performance to manage the infoobject.

The parameters of program are:
- the name of infoObejct for master data, ex. 0MATERIAL oe the same name plus $T for the text, ex. 0MATERIAL$T
- Delete all request information that is older than XX days
- Remaining number of requests that should stay in data target NN

Before use of the abap, please check that you have tha latest versione of code; from SNOTE transaction: install the notes 1143710, 1378477, 1475235, 1676451

Note 1622324 - Cleaning up BW Infocube Dimension Tables

It' s possible use a sap abap in order to clean the bw infocube dimension. In attach of 1622324 note on the OSS there is a abap code.
The name of program is ZSAP_DIM_CLEANER

In order to show the actual dimension of all infocubes run the program SAP_INFOCUBE_DESIGNS

The deletion of entry in the dimension allow a better performance in write and read data of cube.

Sap BW in my Box

Sap BW runs on windows 7 in a virtual machine on my Debian 64 bit. I use from remote pc with sapgui.

SAP BW message: translation error

Process Cancellarzioene di richieste dal PSA, variant Canc. PSA - Vendite has status Terminato con errori (instance PSAD_66313UORU2Q

Message no. RSPC009

BW - transaction RSRV - Remove unused dimension

Some operation in RSRV transaction take too long time and the process of correction go down because dump timeout occurs.

NEWS 01/2013 --> Standard SAP Abap, apply note 1622324


In my case I want repair the entries in the dimensional table in order to remove these unused.

In the transaction RSRV isn't possible to run the repair in background.

I searched the abap code for this correction, and put these in the report; it's only a function module :)
From SE38 it's possible run the correction in background.

that's all

the code:

*&---------------------------------------------------------------------*
*& Report  ZRSDRD_DIM_REMOVE_UNUSED
*&
*&---------------------------------------------------------------------*
*&
*& From DelihiTech Blog by Pipex
*&---------------------------------------------------------------------*

REPORT  ZRSDRD_DIM_REMOVE_UNUSED.

TYPES: rsd_s_tbhd      LIKE rsdtbhd.   "table header
TYPES: BEGIN OF rsd_s_cube.                                 "infocubes
        INCLUDE STRUCTURE rsdcubev.
TYPES:   ddstate TYPE rsd_s_tbhd-ddstate,        "state of View
       END OF rsd_s_cube.
TYPES: rsd_infocube    TYPE rsd_s_cube-infocube,
       rsd_ts_infocube TYPE SORTED TABLE OF rsd_infocube
                       WITH UNIQUE KEY table_line.

PARAMETERS: p_cube TYPE  RSD_INFOCUBE,
            p_dim TYPE  RSD_T_DIME ,
            p_check as CHECKBOX DEFAULT 'X'.

CALL FUNCTION 'RSDRD_DIM_REMOVE_UNUSED'
  EXPORTING
    I_INFOCUBE              = p_cube
   I_T_DIME                = p_dim
   I_CHECK_ONLY            = p_check
   I_COMMIT_AFTER_N        = 50000
   I_REPORT_ONLY_N         = 5
* IMPORTING
*   E_REPAIR_POSSIBLE       =
* CHANGING
*   C_T_MSG                 =
 EXCEPTIONS
   X_MESSAGE               = 1
   OTHERS                  = 2
          .

IF SY-SUBRC <> 0.
  MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
          WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

Update rules disattive

Capita a volte di modificare un oggetto su BW e che il non attento tecnico si dimentichi di riattivare le update rules.
E’ sempre necessario controllare, dopo aver fatto un refresh della RSA1, ogni oggetto dipendente da quello che si sta modificando.
Per le update rules è possibile cercare quali sono quelle disattive consultando la tabella RSUPDINFO con utente ultima modifica IMPACT.
Ricerca tramite tabella RSUPDINFO

Con la SE16 effettuare una selezione con
OBJVERS = A
TSTPNM = IMPACT


Se non si vuole controllare ed attivare ogni regola in questo stato è possibile utilizzare un Abap standard.

PROGRAMMA PER GENERARE UPDATE RULES

RSAU_UPDR_REACTIVATE_ALL
Riattiva tutte le UR che hanno un target attivo

è utile implementare la nota
nota 1481409 - RSAU_UPDR_REACTIVATE_ALL - Enhaced for inactive Data Targets

per evitare di incorrere in un errore del programma che genererebbe la update rules anche per oggetti inattivi dando errore.

How to find object in query if you have "query element"

Sometimes in the transport occur errors with "query element" like this:

Start of the after-import method RS_ELEM_AFTER_IMPORT for object type(s) ELEM (Sess. attivazione)
Error when activating element 0BVPO948IHVABDFEG9BM19158

In the table RSZCOMPDIR we found a match between object and query element
Run SE16 and put in the key field COMPUID the element

return code 4 converting field 0WS_APPL

Si tratta di un infobject relativo ai Survey di CRM.
In fase di caricamento dati anagrafici viene richiamato un function module di conversione legato al InfoObject stesso.
Il codice prevede che nel caso il campo chiave abbia uno dei due seguenti valori: 'SRM_EVAL' o 'SUSUCO', venga richiamato il function module RSDG_ID_GET_FROM_LOGSYS.
Il return code 4 che è segnalato dal monitor di caricamento corrisponde all'esito del function module sopra citato.



Eseguendo tramite la SE37 il function module RSDG_ID_GET_FROM_LOGSYS mi viene segnalato che non è valorizzato il "source system ID"; da RSA1 selezionare "tools" " Maintenance of Source system IDs" e valorizzare il campo relativo al source system da cui stiamo leggendo: nel mio caso il sistema CRM.

Activation of BW trasformation

In the standard BW 7 system there isn't a program for activation of BW Trasformations.
It's available only from SP24 for BW 7.0, or with application of notes.

Now I try to explain how to install the Program RSDG_TRFN_ACTIVATE on your BW system.

"Programm RSDG_TRFN_ACTIVATE for checks and regenerate transformation objects in case of technical incompleteness or inconsistency of metadata without creating a transport."
The program is included in SP24 for BW 7.00 or SP 10 in BW 7.10.

Note for Program's implementation

1408161 - Program for transformation activation

I have BW 7 with SP 20; the application of 1408161 is easy ad fast.


There's new implementation with enhancement for program - included in new note (delivered with SP25):

1507043 - RSDG_TRFN_ACTIVATE: Enhancements

In order to install this note you must be install others notes too:
1408161 Program for transformation activation
1434801 Automatic Adjustment of Transformation for ISET
1471117 SP25:RSDG_TRFN_ACTIVATE skips if M version has OBJSTAT 'INA'

The installation isn't easy because they have others notes required and some manually activity.

I missing the data elemnts :)