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
Author: Al Gulland
I am a Data Architect specialising in delivery data and analytical platforms.
SAP BusinessObjects Enterprise XI3 Deployment Patterns
When deploying an SAP BusinessObjects Enterprise system there are a lot of choices for where you can deploy all the services that make up the system. It is then necessary to make sure that you choose the right deployment in order to meet your requirements, for example, is it easily maintained, is it resilient, is… Continue reading SAP BusinessObjects Enterprise XI3 Deployment Patterns
SAP Business Objects Data Services, SQL Server Express and Java 6
This articles looks at configuring the following components, SAP Business Objects Data Services XI3.2 SQL Server Express 2005 Tomcat 5.5 JDK 1.6 The JDK 1.6 is not supported and indeed when trying to configure the Management Console to connect to a repository created in SQL Server Express 2005 we get the following error, Java Runtime… Continue reading SAP Business Objects Data Services, SQL Server Express and Java 6
Calculating Geometric Mean in Web Intelligence
A geometric mean is an average that is useful for sets of numbers that are interpreted according to their product and not their sum as is the case with the more commonly known arithmetic mean. An example of where you would use a geometric mean is in financial reporting when you want to calculate the… Continue reading Calculating Geometric Mean in Web Intelligence
Filtering for Latest Data in a Universe
Summary This article looks at a reporting requirement where we need to restrict data to the latest data, for example, to only show the latest account balance or the latest action item for work streams in a project. Our solution is to implement a series of predefined conditions one for each dimension that we need… Continue reading Filtering for Latest Data in a Universe
Al Gulland 
You must be logged in to post a comment.