How To, SAP Business Objects Enterprise, SAP Data Services, Technology

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

How To, SAP Business Objects Enterprise

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

Business Intelligence, How To, Statistical Analysis, Web Intelligence

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

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

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