Business Intelligence, How To, Information Management, SAP Data Services

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

Business Intelligence, Delivery Methodology, Information Management, SAP Data Services

Automated Unit Testing in SAP Data Services. Part I

Introduction One of the key drivers of this article is that although there are many articles on unit testing in general on internet there are hardly any on unit testing with SAP DataServices. Unit testing has been accepted as a key part of the software development lifecycle for projects building applications in languages such as… Continue reading Automated Unit Testing in SAP Data Services. Part I

Business Intelligence, Statistical Analysis

Getting Started with Statistics – a key part of Business Intelligence

A key part of our work in Business Intelligence is the analysis of data and the branch of mathematics that we employ for this is statistics. We analyse data to understand our business better and when analysing the data our main objective is to pick out the reality from the background noise. For example when… Continue reading Getting Started with Statistics – a key part of Business Intelligence

Delivery Methodology, Information Management, SAP Data Services

SAP Data Services: 10 Reasons for never using Global Variables (and one where you can)

In software programming it is widely held that using global variables or other constructs to maintain global state is a poor programming practice[1] and many of those reasons can also be applied to development of jobs in SAP Data Services. The following is my list of 10 reasons for why you should never use global… Continue reading SAP Data Services: 10 Reasons for never using Global Variables (and one where you can)

How To, Statistical Analysis, Web Intelligence

Calculating Moving Averages in Web Intelligence

Introduction The previous article looked at what moving averages are and how to calculate them. This article now looks at how to implement these in Web Intelligence. The formula used here are compatible with the XIr3 version of SAP BOE however some formula may work in previous versions if available. We'll begin by looking at… Continue reading Calculating Moving Averages in Web Intelligence

How To, Statistical Analysis, Web Intelligence

Creating Histograms in Web Intelligence with Adjustable Bucket Sizes

Introduction This article looks at how to create a histogram in Web Intelligence and makes use of input controls to allow the user to automatically adjust the histogram's bucket size. Histograms is a charting technique used to analyse the distribution of a set of data for example a business analyst may use a histogram to… Continue reading Creating Histograms in Web Intelligence with Adjustable Bucket Sizes

How To, SQL Server, Statistical Analysis, Web Intelligence

Analysis of Joiners and Leavers

Introduction This article looks at different techniques to analyse joiners and leavers using Web Intelligence. Analysing joiners and leavers is where you need to understand the change in membership of a set, for example, products moving in and out of your top 10 sales. If you are able to identify which key products that are… Continue reading Analysis of Joiners and Leavers