Posts tagged SAP
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…)
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”
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:
- Modify your current transportrequest in SAP BW
- In your BW transport add an extra object “ISFS” with program ID “R3TR”
- Save your transportrequest
- 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 .
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.
It’s a long time ago that I post a new message to this blog. Last week I installed a clean installation of SAP BusinessObjects BI4.0 and I’m struggling with the configuration. For example…how can I connect a BW system, what are simple usernames, how can I connect with my iPad? Time to post a new “How to…” document and bundle the solutions.
Year 2012 is the year that mobile will be an important role in a lot of organisations. But when organisations want to know more about mobility, consultants need to be skilled. With my manual you’re able to install your own SAP BusinessObjects BI4.0 environment and configure your iPad. So, don’t hesitate and download the manual to install your own BI4.0 environment.
Because mobile will be very important the next years, within a few weeks a new post will arrive on www.pieterverstraeten.com about the comparison of mobile solutions.
For the geeks, i’m sorry…this is not a manual how to tune the SAP BusinessObjects BI4.0 server. But only How to install BI4.0 and some good tips and tricks!