Posts tagged SAP


Adapt your SAP BW and SAP BO authorizations


When employees in your organization need authorization for SAP BW and SAP BO, assignments of authorizations need to be executed in both tools.
When you have to do this for some users, the work is limited. If you, however, receive a request for many users, it would be nice if this process could be simplified.
This blogpost describes a way of working on how you can easily adapt your SAP BW and SAP BO authorizations.
If you’re interested in how to setup a good and maintainable authorization-structure in SAP BW and SAP BO, please read the how-to document, you can download the document here.


Performance optimizer SAP BO Analysis


Performance issues with the filter function in SAP BO Analysis…? This solution can help you to speed-up SAP BO Analysis!
This optimizer can be used for the filter function on the right panel in SAP BO Analysis (see image below). When you want to filter on an object that contains a lot of records (i.e. 0MATERIAL, 0PRODORDER, etc.), users can wait a long time.

First all posted values are read from the SAP BW infocube. In the properties of an infoobject the standard setting for “Query Execution Filter Val. Selectn” (tab BusinessExplorer) is set to “Only Posted Values for Navigation”. This is the reason why SAP BO Analysis take much time to read the posted values.
To speed up SAP BO Analysis, you can change the setting “Query Execution Filter Val. Selectn” to “Values in Master Data Table” (see image below).

This is not the full solution!!! Read more… (more…)


Generated demodata for SAP BW InfoCube


All consultants have the experience to make a quick demo in SAP BW, but demodata is sometimes an issue. If you need to create a demo in a short time, use an ABAP program that will generate the data for you. Follow these instructions to fill your InfoCube with generated data:
– Create your InfoCube with all relevant InfoObjects
– Start transaction SE38
– Execute (F8) program “CUBE_SAMPLE_CREATE”
– Choose the InfoCube that need to be filled with demo data
– Select the number of records you want
– Execute the program and the cube will be filled
– Run your report or display the cube data and you’ll see results

Note: The generated data will not be representable to show it to your client(s), the data can be used for internal demo purposes. If your masterdata is up to date and representable, select the option “Vals from Master Data Table”

Replicating datasources

Replicating SAP BW datasources automatically


Since a long time ago I’m back into SAP BW datawarehousing, currently I’m working in a project where SAP BW is a main focus. From datasources to BEx queries…. I need to retrieve my knowlegde from years ago :-) During a transport procedure on the ECC side from development to test I transported some datasources. Normally after every transport with datasources, a manual replication for the datasources on the BW side is necessary. I found a simple solution that you will not need replicate the datasources manually. If you add an object into your transportrequest, the replication can be automatically be done.

Follow the next procedure to replicate your datasources automatically:

  1. Modify your current transportrequest in SAP BW
  2. In your BW transport add an extra object “ISFS” with program ID “R3TR”
  3. Save your transportrequest
  4. Transport your request to the next environment (be sure that de datasources will exist on the source side, i.e. ECC)

This is not a new solution, but it’s very useful to share :-).


AverageIf function in Dashboards 4.0


In SAP Dashboards 4.0 not all excel functions are supported, for example the function”AVERAGEIF”. When you use this function in your dashboard and bind the cell to a component, the error “Unsupported Excel function: AVERAGEIF” will be displayed. This function can be very useful in some cases. To solve this issue, you can use an alternative.

In the example below I calculate the average profit where the region is equal to *west*. This results in EURO 16.734,- with the AVERAGEIF function. In the picture on the right you’ll find an alternative to calculate the average with the same condition equal to *west*. Use a combination of both functions: “COUNTIF” and “SUMIF”.

This will make your dashboard development much better! Good luck!


Note: Because the COUNTIF and SUMIF are very complex functions, don’t use these functions on large datasets! Thanks to Ryan Goodman for this addition.

Go to Top