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

How To, SQL Server, Universe Design

Migrate SAP BusinessObjects sample databases to Microsoft SQL Server

Introduction Two sample Microsoft Access databases come with SAP BusinessObjects Enterprise: eFashion and Club. This article describes the steps involved in migrating the eFashion database to Microsoft SQL Server. The Club database can be migrated in a similar manner. Overview To migrate the database we use Microsoft's SQL Server Migration Assistant, a tool that creates… Continue reading Migrate SAP BusinessObjects sample databases to Microsoft SQL Server

How To, Statistical Analysis, Web Intelligence

Linear Regression Analysis and Web Intelligence

This article looks at how to do linear regression analysis in Web Intelligence. Linear regression is a statistical technique for analysing data in order to obtain a measure of correlation between two variables where the relationship between the variables is expected to be linear. Web Intelligence does not contain a full set of formula for… Continue reading Linear Regression Analysis and Web Intelligence

Applications, SAP Business Objects Enterprise, Software

Boest – the BOE Stress Testing Application

For a while I have been saying to everyone I know that Crystal Reports is more efficient at processing reports than Web Intelligence but I have never had any concrete proof. So I decided to set myself a small project that compares Web Intelligence document to the same report created in Crystal Reports. And the… Continue reading Boest – the BOE Stress Testing Application

How To, Web Intelligence

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