sap bw.

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 Visio Shapes

I want to document a BW data model and searched for a Microsoft Visio shape, but I found nothing. So I build my own Visio shapes. At the moment there are the following types available:

  • DataSource
  • Transformation
  • DataStoreObject
  • InfoCube
  • SPO
  • MultiProvider
  • DTP
  • InfoSource
  • OpenHub
  • Query

I used them in my last blogpost about Copy Queries to a new MultiProvider.

Read More 1 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 Analysis Process Designer (APD)

At the moment I had to deal with a special problem. I have data in a SPO from two different sources and the goal was to find the corresponding two data lines and make one out of it. This line should marked with a special character. So I decided to build an Analysis Process (APD).

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

How to build a RFC Server with NCo 3.0 Part 2

So it is done, Part 2 finally is written and an example is uploaded to github. It took me about 8 months to release Part 2 of these series. Part 1 was released in March 2016 and now I had time to write an example for Part 2 and upload it to github. Part 1 discover the basics about a RFC Server with the SAP NCo Connector, part 2 now explain how to build a RFC Server more flexible.

Read More 0 Comments

BW Modeling Tools

This week the new open SAP course BW/4HANA in a Nutshell started. It is a free course. One big thing is that BW/4HANA no longer supports the good old BEx Suite. You now have to use the BW Modeling Tools based on Eclipse. In this and further posts I will go deeper into the BW Modeling Tools and what is possible and what is not possible at the moment.

 

If you have any questions feel free to ask or correct me ;) So let's get started.

Read More 2 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 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 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

How to build a RFC Server with NCo 3.0 Part 1

In some cases you want to trigger an external program from a SAP system. In this part 1 I explain how to build a RFC Server with NCo 3.0. I had several problems when I started with this topic so I decided to write a short example. If someone want the Visual Studio project files, please contact me.

 

So let's go.

 

This Post describes how to build a simple RFC Server using SAP NCo 3.0 and the app.config. Part 2 will be describe how to build a RFC Server with RFC Parameter. As example program I use STFC_CONNECTION. It is a good example, because it contains importing and exporting parameters.

 

First you have to download and install NCo 3.0 (OSS login required). Afterwards you have to start a new project in Visual Studio.

 

Setting up the Visual Studio Project:

 

In the properties of the project you have to use a new console application. As target framework I use .Net Framework 4.5.

Read More 0 Comments

Support SAP Connector for Microsoft .Net (NCo)

In the last time I had several problems with external access to a SAP BW System. The access was realized with an old version of the SAP Connector. And that is the problem. If you have a SAP Business Warehouse System version which is greater than 7.3, you maybe get troubles. For example SAP added new fields or like in 7.4 you now have the option for "Long text is XL" in the master data. So the old versions would not work with this.

 

I just found a very good table about the maintenance of all versions in Martins blog.

Read More 0 Comments

Rename and delete an Analysis Office Workbook

If you want to delete or rename an Analysis Office Workbook, you have to right click on the Workbook Opendialog.

Read More 0 Comments

Video How to maintain Master Data in SAP 7.4 

After „SAP BW 7.4 Maintain characteristics“ is one of the most read posts. I visualize this post in a short video.

Read More 0 Comments

Analysis Office Goto ala BEx Query

In BEx Analyzer you could jump into another query from a query / workbook. The GoTo-Function make sense if you have one query for overview and one for detail.

Read More 0 Comments

SAP BW find orphaned workbooks

You can use the ABAP program RRMX_WORKBOOKS_GARBAGE_COLLECT to find workbooks that are currently assigned to a user or group of users via the transaction SE38. Through the hook "Workbooks found erase" these are removed from the system.

Read More 0 Comments

Relocation of OLAP functions on SAP HANA

With every new release of SAP HANA functions are moved from the OLAP engine into the database. The current state of the push down can be found in note 2063449. So check this note from time to time, if it is interesting to implement a service pack.

 

Note: You need a S-User to access this note.

Read More 0 Comments

SAP BW hierarchy and attribute change run for all InfoObjects

  1. Call transaction se38
  2. Run Program RSDDS_AGGREGATES_MAINTAIN
  3. Select InfoObjects or hierarchy
  4. Run
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 COPA keyfigure assignment

  1. Call transaction sbiw
  2. Select menu item "Settings for Application-Specific DataSources (PI) >> Profitability Analysis >> Assign Key Figures
  3. Choose either "New Entries" or modify existing one.
Read More 2 Comments

Define SAP COPA key figure schemes

  1. Call transaction SPRO
  2. Calling SAP Reference IMG
  3. Controlling >> Profitability Analysis >> Information System >> Report Components >> Define Key Figure Schemes
  4. Choose Operating concern
  5. Select Elements of the key figure scheme
  6. Select a key figure
Read More 0 Comments

Remove BW Query from user favorites

  1. Call transaction se16
  2. Select table SMEN_BUFFC
  3. Enter Username and/or Report
  4. Run
  5. Select entry
  6. Go to menu >> table entry >> Delete the entry
Read More 0 Comments

Explosion of structured items 2LIS_03_BF

From time to time there is a mistake in the resolution of structured items and the transfer of material hierarchies to BW. It helps the Note 1410263.

Read More 0 Comments

Factors affecting the performance of the BEx Analyzer

In SAP Support Portal you find the Note 1101143. The Note provides an overview of the factors which affecting the performance of BEx Analyzer.

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

 

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

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

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

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

SAP BW Query Read Mode

Query to Read All Data at Once

 

Advantages:

  • query navigation after first call very quickly as data completely present in OLAP cache

Disadvantages:

  • Initial call slow
  • Using characteristics aggregates greatly restricted
  • Large memory requirement in the OLAP cache

Recommendation:

  • Using the read mode only for small InfoCubes
  • Using the read mode only in queries with a few free characteristics

Query to Read Data During Navigation

Advantages:

  • Good hit rate in characteristic aggregates
  • Quick response times for small hierarchies

Disadvantages:

  • Waiting period required in successive runs when selection is not identical to Initial call

Recommendation:

  • Using the read mode for small hierarchies
  • Using the read mode for large result sets

 

Query to Read When You Navigate or Expaned Hierarchies

Advantages:

  • Initial call of the query quickly because only the necessary data is selected

Disadvantages:

  • Selects the least amount of data in the Initial call, so read access to database with modified navigation required

Recommendation:

  • Using the read mode when hierarchy aggregates required
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

Connecting via VBA to a SAP system

If you want to create automated reports with data from an SAP ERP or Business Warehouse system, you first need to connect to a SAP system. The connection can be used later to access system tables in the ERP or Business Warehouse or to trigger various other action.

Read More 0 Comments