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

Oracle

Date Maths – Oracle

This article continues the Date Maths series and here we are using Oracle. Please refer to the previous articles on SQL Server and DB2 for similar calculations for those database systems. Please refer to the Oracle 11g SQL Reference for more information on the date functions used in this article. Oracle Date Functions To add… Continue reading Date Maths – Oracle

Database Technology, IBM DB2

Date Maths – IBM DB2

This article continues the Date Maths series, this time with DB2 syntax. DB2 Reference can be found at IBM and details of SQL functions are found in the section Database Reference > SQL > Functions Please refer to the other articles in this series on SQL Server and Oracle. IBM DB2 Date Functions System Date… Continue reading Date Maths – IBM DB2

Database Technology

DB2 Client Configuration Issues

Recently I had trouble running and configuring a DB2 client installed on Windows XP and thought I'd share what went wrong and how to resolve the issue as it wasn't immediately obvious. The IT centre installed DB2 client on a remotely accessed Windows desktop but when I logged in I couldn't use the client. The first… Continue reading DB2 Client Configuration Issues

Database Technology, SQL Server

Date Maths – SQL Server

This article is the first in a series that lists date functions and date manipulation calculations for leading database systems and this article looks at the first of those - Microsoft SQL Server. Please refer to the other articles in this series on DB2 and Oracle. Rather than providing a list of all possible calculations… Continue reading Date Maths – SQL Server