SAP BW fix incorrect data in a DataStore-Object

Here just a short notice if somebody doesn't know it yet. If you have a false information in a data record you can fix this manually either in a PSA or (A)DSO. Just select the desired entry and click Display (F7).

Read More 0 Comments

SAP BW Reset request/task status

In my current project we have a go live. So I needed a function to reset the transport status of some transports. So if you release your transport falsely the transport is locked by release and can no longer be removed from the transport status. Maybe you also want to delete the entire transport request. This option is also denied as soon as the tasks have been released. The standard procedures are very laborious and not only cost a lot of time, but also have a certain risk potential. SAP offers a report which solves your problem. The report is RDDIT076. As you see in the next picture, the transport is released.

Read More 0 Comments

SAP BW Create own reversal entry

Lately, all my posts started with "In my current project", so now something else, even if it was developed in the current project. The problem we are facing with is that we get a data extraction which deliver us only the new data records, not the reverse data record.

Read More 0 Comments

BW/4HANA Export Transports

I know that I don't publish a lot of new posts the last few weeks. The reason is I am writing on my diploma thesis. The title is "S/4HANA versus BW/4HANA - Zukunft der Datenanalyse". My deadline is in the middle of September so I have to write a lot these days. At the moment, I have access to a BW/4HANA instance in the cloud and I want to share how you could export your development before you terminate the instance. First you have to log on with the SAP* user in the client 000. Go to the transaction stms and select the System Overview.

Read More 0 Comments

Install your own SAP BW on a virtual machine

I described in a earlier post how to use BW/4HANA on Amazon AWS. But if you just need a developing system for some time and don't want to use BW/4HANA, you can use the BW 7.5 SP2 developer edition on a virtual machine.

Read More 2 Comments

SAP BW Copy Queries to a new MultiProvider

In my current project, we want to separate the current MultiProvider with VirtualProvider underneath into one MultiProvider with VirtualProvider and one MultiProvider without VirtualProvider. This step is necessary, because we receive a lot of data and don't want to push all these data through the VirtualProvider. The VirtualProvider only add one field which we haven't got in our InfoCubes and it isn't necessary in all queries just a few.

Read More 0 Comments

SAP BW Check your data model

Sometimes it is necessary to check your data model if it still fit your needs. For this you can use the transaction rsrv. Select there under All Elementary Tests >> Database >> Database information about InfoProvider tables.

Read More 0 Comments

SAP BW find meta chain

In my current project I had to clean up the existing process chains. A lot of process chains were created via SPOs and not really used in the system. First I had to check, if one is used in a another process chain or in which one they are used.

Read More 0 Comments

SAP BW Change Object Directory Entries

In my current project we have to transport from a maintenance system to our development system. The problem is when you now transport the objects into quality system, you have to check the option "Overwrite Originals" so that your transport is working. But you have to put this flag on every transport you make in the future from your development system to quality.

Read More 1 Comments

Analysis Office Hide Customize User Interface

In this thread on blogs.sap.com, Michael Hamm asked how to hide or deactivate the Customize User Interface button. At first, at the moment SAP doesn't offer any checkbox which you can check and uncheck in the settings.

Read More 0 Comments

SAP BW Transport of Copies

In my current project, we have a copy of the productive system as a maintenance system, because we made huge changes in

the development system in case of the project. So if there is an error in the production, we can easily repair it.

 

Some changes have also be transported into the development system, so we have the same state and our future request can be transported into production. For this we use the functionality Transport of Copies. All objects of the originally request are still locked. If you want to create a transport of copies, open the transaction SE01. Check the option “Transport of Copies” and click on Display.

Read More 0 Comments

SAP BW Create SPO via BAdI - Part 3

After we created in Part 1 the transparent tables and in Part 2 all BAdI implementation, we can now maintain and create our SPO. First we have to fill our table ZSPOPATTERN with a PATTERNID and a corresponding INFOOBJECT. Go to the se16 and create a new table entry. As PATTERNID enter a unique id for example CALYEAR and as INFOOBJECT 0CALYEAR. For TXTLG and TXTSM enter a useful text. Depending on how many InfoObject are used for a partition, create the other pattern.

Read More 0 Comments

SAP BW Create SPO via BAdI - Part 2

After we created in part 1 all tables and objects, we can now create a new BAdI to generate the partitions. Go to the transaction se19 and create a new implementation with the Name RSLPO_BADI_PARTITIONING.

Read More 0 Comments

SAP BW Create SPO via BAdI - Part 1

At my current project I needed a way to create Semantic Partitioning Object (SPO) via BAdI to reduce the end-of-year work. After a little search via Google (you cannot find anything on the new SAP Community Page), I found these threads.

Read More 0 Comments

Setup BW/4HANA on Amazon AWS

So after I read a lot about BW/4HANA, I decided to create a own SAP BW/4HANA 1.0 [Developer Edition] instance on my Amazon AWS account. First I had to extend my normal AWS account with a IAM user. For this you choose under Security, Identity & Compliance >> IAM. Under Users you click on Add user.

Read More 2 Comments

Install BI Platform and setup Windows AD authentication

This week I want to test the integration of a BI Platform to my .Net program. So I want to install a test version of the BIP, but my virtual machine hadn't enough space. The first step was to extend the space of the disk. It is very easy in VirtualBox to extend the disk.

  1. Open the Windows Console
  2. Go to the path where you installed Virtual Box. (Default: C:Program FilesOracleVirtualBox)
  3. Type VBoxManage.exe modifyhd "Path to the disk" --resize 100000 (=100 GB)
  4. Press Enter and your VirtualBox will be extended

After my VirtualBox was ready I could install the BIP. But the next issue was found very soon. I need a license key.

Read More 9 Comments

Settings for the Analysis for Office Plug-in

In Analysis for Office 2.2 SP3 some new interesting parameter for Ao_app.config were delivered. The following parameter are interesting and in some case maybe very useful.

  • MaxNumberOfParallelThreads

Use this setting to define the maximum number of parallel threads that can be used to open the SAP HANA DataSources of a workbook. This only works with SAP HANA.

Use this setting to specify the mode of the prompting dialog when you open a workbook from the NetWeaver that contains exactly one DataSource.

Read More 0 Comments

Analysis for Office Variable Operator Contains Pattern

Analysis for Office Prompt without Pattern
Analysis for Office Prompt without Pattern
Read More 0 Comments

Error while executing function module BICS_PROV_OPEN

I just got access to a NetWeaver 7.5 SP2 and I want to test it with Analysis for Office 2.3. So I open Excel and insert a query. And here we go first error: "unable to open data source", so I thought maybe the query is broken and I developed a new query and insert it. Here we go, same error. Maybe queries don't work, so I insert a InfoCube directly. Same error...

 

Now I refresh the insert query and got an Analysis for Office message: Error while executing function module: BICS_PROV_OPEN

In the explanation was one line with the hint "wrong parameter type in an rfc call", so I looked into st22 and saw a dump which the message: CALL_FUNCTION_ILLEGAL_P_TYPE

Read More 2 Comments

Change Requests after release

  1. Open transaction se38
  2. Open program RDDIT076
  3. Execute (F8)
  4. Enter a request or task number
  5. Execute (F8)
  6. Doubleclick on a selected entry
  7. Switch between Display and Change (F9)
  8. Change your request
  9. Save (CTRL + S)
Read More 0 Comments

Process Chain Change Process Type

  • Call transaction sm30
  • Open Table/View RSPROCESSTYPES
Read More 0 Comments

SAP BW 7.4 Maintain characteristics 

Unfortunately, SAP shifted the maintenance of master data in SAP BW 7.4 into the Web. Not everyone wants to maintain the master data on the Web. Here is a small workaround.

Read More 2 Comments

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

Unlock InfoObjects in Business Warehouse

  1. Transaction rsa1 or rsdcube
  2. Menu >> Extras
  3. Select "Unlock InfoObjects"
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

How to use a remote enabled function module in SAP BW with VBA

If you have created your own SAP function module, you can use this with the following VBA code.

 

Sub FunctionModule()

'Variables Definition

Dim MyFunc As Object

Dim E_INSERTED As Object

Dim E_MODIFIED As Object

Dim DATA As Object

Set MyFunc = R3.Add("Z_RSDRI_UPDATE_LCP") 'FunctionModule Name in SAP BW

Set E_INSERTED = MyFunc.imports("E_INSERTED") 'InsertFunction in SAP BW

Set E_MODIFIED = MyFunc.imports("E_MODIFIED") 'ModifyFunction in SAP BW

 

Set DATA = MyFunc.tables("I_T_DATA") 'Table to store data and write to BW.

 

'Add data

DATA.Rows.Add 'add new data

rowDATA.Value(1, 1) = Sheet1.Cells(1, 10).Value 'First Cell of the data table is filled with the value from Sheet1.Cells(1,10)

 

'Call Insert or Modify

Result = MyFunc.CALL

 

'Message to the User

If Result = True Then

MsgBox "Insert Rows: " & E_INSERTED.Value & " Modify Rows: " & E_MODIFIED.Value, vbInformation

Else

MsgBox MyFunc.EXCEPTION 'Exception

End If

End Sub

Read More 0 Comments

List of all SAP BW Users

Sometimes you want to know which users are created on a Business Warehouse system and if these have access or have been blocked from by incorrect logon. For this you can use the transaction rsusr200. In the transaction you can see the last login, the users validity, etc.

  1. Call transaction rsusr200
  2. Run
  3. List of all users appears
Read More 0 Comments

SAP BW Authorization check

Sometimes you have to check the rights of users. For this you can use the transaction su53.

Read More 0 Comments

Activate all inactive transformations

If you adjusts many objects in the Business Warehouse, a lot of transformations are automatically inactive. So you don't have to activate each transformation by hand, there is a ABAP program named RSDG_TRFN_ACTIVATE.

  1. Call transaction se38
  2. Run program RSDG_TRFN_ACTIVATE
Read More 0 Comments

How to check the InfoCube scheme

SAP Business Warehouse transaction listschema
SAP Business Warehouse transaction listschema

There are several ways to look at the structure of an InfoCube. One way possibility would be to analyze it on the transaction rsa1. Another way to show the structure of an InfoCube is the transaction listschema.

 

  1. Call transaction listschema
  2. Choose a type of InfoCube
  3. Select a specific InfoCube
  4. Run
Read More 0 Comments