A performance gain of 3 hours down to 30 seconds is impressive and what's even more remarkable is that it was only one minor change to an existing dataflow that was responsible for the gain. Recently I had built a Job that was to do the historical data load for a data warehouse. The Job… Continue reading SAP Data Services performance gain from 3 hours to 30 seconds
Tag: BusinessObjects
Building a SAP BI 4 Demo System
This article provides a summary of the high level steps involved with building a SAP BI 4 Demo System and provides guidance on hardware and software requirements and links to where software can be downloaded from. The Demo System will host SAP Business Objects 4.0 and SAP Data Services 4.0 Overview The demo server consists… Continue reading Building a SAP BI 4 Demo System
Using Local Data Sources in Web Intelligence
This article looks at how to use a local data source in a Web Intelligence report and then combine that data with data retrieved from a data warehouse. Business Scenario The worked example described here is to create a simple dashboard style report of sales data. We then highlight the sales figures using a typical… Continue reading Using Local Data Sources in Web Intelligence
Developing BI Applications
This article looks at an approach to developing SAP BusinessObjects solutions where rather than just writing reports and universes we instead build a BI Application. The main benefit of this approach is a more efficient, streamlined and organised delivery process. A BI Application is viewed as a complete project where the components of the BI… Continue reading Developing BI Applications
Calculating Geometric Mean in Web Intelligence
A geometric mean is an average that is useful for sets of numbers that are interpreted according to their product and not their sum as is the case with the more commonly known arithmetic mean. An example of where you would use a geometric mean is in financial reporting when you want to calculate the… Continue reading Calculating Geometric Mean in Web Intelligence
Al Gulland 
You must be logged in to post a comment.