How To, Statistical Analysis, Web Intelligence

When analysis is better using Web Intelligence than Excel

This article compares data analysis using Web Intelligence to the same workflow using Microsoft Excel and for the given scenario demonstrates why using Web Intelligence is quicker, easier and less error prone. The objective here is not to show that in all cases Web Intelligence is better than Excel rather to highlight that there are… Continue reading When analysis is better using Web Intelligence than Excel

How To, Information Delivery, SAP Business Objects

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

How To, Statistical Analysis, Web Intelligence

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

How To, SAP Business Objects, Universe Design, 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