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

Business Intelligence, Delivery Methodology, SAP Business Objects

SAP BOE Security Model Patterns

Security Modelling is concerned with two areas: authentication - establishing who the user is, essentially the logon process and authorisation - controlling user access to different areas of the system. This article discusses four different design patterns for authorisation security models that can be used in SAP BusinessObjects Enterprise. In SAP BusinessObjects Enterprise (BOE) we… Continue reading SAP BOE Security Model Patterns

Delivery Methodology, SAP Business Objects

Developing BI Applications

This article looks at an approach to developing SAP BusinessObjects solutions where rather than just writing reports and universes we instead build a BI Application. The main benefit of this approach is a more efficient, streamlined and organised delivery process. A BI Application is viewed as a complete project where the components of the BI… Continue reading Developing BI Applications

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

Business Intelligence, Delivery Methodology, SAP Business Objects, SAP Business Objects Enterprise

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

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