BLOG

8

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...

25

Hierarchies and formatting rules

A few weeks ago I was called by a SAP BO consultant, his name is Raoul Labega. He told me he was working on a project in Denmark. During this project he found a very good function in WebI that developers can use in combination with hierarchies. He wants to share...

5

SimpleUsernames in BI4

If you installed SAP BO BI4 on top of a SAP BW 7.x system, users can login with their own SAP BW account. But if there are more source systems (i.e. non SAP), users need te be logon with different usernames. This is not a practical situation, also when you...

12

Debugging in BI4 WebIntelligence

Last 5 years I worked a lot with SAP BW, debug BEx query’s, ABAP, etc. The debug mode could easily be found. Since I’m working with BI4 I was not aware how to debug reports in WebIngelligence, because it’s an web interface and all the Java errors are difficult to...