december 2014.

From time to time it happens that the source system delivers special characters and the Business Warehouse system can not handle it. So the loading process may be crashed.

One solution is the following ABAP code:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19

DATA:
  zeichen(1) TYPE c,
  muster(2) TYPE c,
  field TYPE c LENGTH 000060.
  field = SOURCE_FIELDS-YYSTREET.

DO.
  IF field CO ' !"%&()*+,-./:;<=>?_0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZÄÖÜßabcdefg' && 'hijklmnopqrstuvwxyzäöü '.
    EXIT.
  ELSE.
    zeichen = field+sy-fdpos(1).
    muster+0(1) = zeichen.
    muster+1(1) = space.
    TRANSLATE field USING muster.
  ENDIF.

ENDDO.

RESULT = field.

While checking or activation of an InfoSet the BW System generates the following Dump:

"UNCAUGHT_EXCEPTION" CX_RS_INPUT_INVALID

"CL_RSQ_ISET_APPEND ============ CP"

"SPLIT_APPENDNM_FALIAS"

Solution: This is a program error and by installing the SAP Note 1970282 resolve this issue.

Unfortunately, SAP export negative numbers like "Number-":

There is a SAP Note which was released 2009. This Note shows how to change key figures of an InfoProvider, even though they are used. The Note is 579342.

1. Transaction rsa1 or rsdcube
2. Menu >> Extras
   
3. Select "Unlock InfoObjects"
   

The following source code allows you to connect your DataSource to a BW system. The workbook must contain a DataSource (DS_1). At this moment you can't open a workbook like BEx 3.5 or 7.0. In Analysis for Office 2.3 you have now the option to open a workbook with the function SAPOpenWorkbook.

When the BEx Query Designer crashes while you are creating or modify a query, the user lock this query in the database. You can remove the lock with the Transaction sm12 and erase the entry.

1. Open TA sm12
2. Click list
3. Select the required entry
4. Click delete

From time to time it is necessary to replicate DataSources from other SAP systems, eg if the DataSource has changed in the source system. To replicate a DataSource, use the transaction rsa1.

1. Open the TA rsa1
2. Search for your InfoSource
3. Right-click on the InfoSource and replicate DataSource
4. Change and activate DataSource
5. Replicate DataSource again

Now the DataSource can be used.