Posts tagged WebIntelligence
Hierarchies and formatting rules
213 months ago
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 this information with other developers via www.PieterVerstraeten.com. In this post he explains how to use the “Depth()” function in WebI.
Alerters are a way to draw attention to specific parts of your report. For example when certain thresholds are met and action must be taken. In SAP BO BI4 these alerts are created using formatting rules. In the example below you see red text when the Sales Volume exceeds 60.000.000 euro’s.
But if you take a closer look you also see that the first line, 173.417.082 euro is not printed in red. This is definitely more than 60.000.000 euro. The threshold is not set for the total product hierarchy. After expanding the Machines we see another threshold for Pumps, if the Sales Volume exceeds 40.000.000 euro. Although the same Sales Volume of 43.546.066 euro occurs on the Machines-level, it is not highlighted on this level.
And we can do the same trick again on another level.
Debugging in BI4 WebIntelligence
126 months ago
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 read. When your are developing WebI reports, you will certainly once encountered an error (i.e. The report cannot be generated….java….). In WebI it’s possible to debug with a hidden feature! What kind of options you have to debug:
- Used memory
- Performance
- ReportOutput
- Event messages
- Document properties
- Execute action
How to debug!
- Open your WebIntelligence report in design mode
- Hold your left SHIFT key down
- Go with your mouse to the left corner of the browser screen (see picture below)
- The debug screen will be opened! Refresh you report and see what’s happening inside the debugscreen.
- DebugTime 
I’ll thank my colleague Markus Edelmann who find this feature together with me.
Recent Comments