december 2014.

SAP BW ABAP remove symbols

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.
Read More 0 Comments

Infoset throws dump while checking or activating

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.

Read More 0 Comments

Display SAP Minus keyfigures correct in Excel

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

Read More 0 Comments

Define default Workbook in Analysis Office

AO Settings
AO Settings

There are two ways to define a default workbook in Analysis for Office (AO). Either every user can define autonomously a Workbook as default Workbook or the IT sets this globally for all users permanently. The first way is very time-consuming because you have to define the default workbook for every Analysis Office User manually. The second way is much more comfortable.

Read More 0 Comments

Overview SAP Business Objects tools

SAP BusinessObjects Web Intelligence

  • For executives of middle manager, business analysts and employees without management responsonsibility
  • Access to data from various sources without technical background
  • Mobile access via SAP Business Objects Mobile
Read More 0 Comments

Change key figures of an used InfoProvider

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.

Read More 0 Comments

Unlock InfoObjects in Business Warehouse

  1. Transaction rsa1 or rsdcube
  2. Menu >> Extras
  3. Select "Unlock InfoObjects"
Read More 0 Comments

Connecting error in Analysis for Office

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.

Read More 0 Comments

Unlock Business Warehouse database lock

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
Read More 0 Comments

SAP Analysis for Office function undo

AO Undo
AO Undo

There are a lot of new features in Analysis for Office 1.4.

 

As you can see the Undo/Redo function of Analysis for Office is much more extensive than in the good old BEx Suite. it is now possible to go several steps back and to revoke.

Read More 0 Comments

Replicate SAP BW DataSource

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.

Read More 0 Comments