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
Category: Technology
Articles relating to the technology used for BI soutions
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
SAP BI 4 Checking Database Connectivity
A common issue found when starting SAP Business Objects BI4 is that the system cannot logon to the CMS database repository. Troubleshooting this can be tricky but the following command can be used on a Linux deployment to check connectivity to an Oracle database and capture error messages in a log file, /opt/sapboe/sap_bobj/ccm.sh -isdbempty -dbdriver… Continue reading SAP BI 4 Checking Database Connectivity
Correlation Analysis and SAP Web Intelligence
Correlation Analysis is a well-known analytical technique used to test if there is a relation between two quantities, for example did a marketing campaign lead to an increase in sales or as the price of one stock rises and falls does the price of another stock also rise or fall in synch. Determining if there… Continue reading Correlation Analysis and SAP Web Intelligence
Automated Unit Testing in SAP Data Services. Part II
The previous article provided an introduction to unit testing in general covering the purpose and benefits of unit testing. This article now looks at a method of unit testing that can be utilised in a SAP DataServices project. First we’ll discuss what objects are candidates for unit testing and then look at how we implement… Continue reading Automated Unit Testing in SAP Data Services. Part II
Al Gulland 
You must be logged in to post a comment.