Information Management, SAP Data Services

SAP Data Services performance gain from 3 hours to 30 seconds

A performance gain of 3 hours down to 30 seconds is impressive and what's even more remarkable is that it was only one minor change to an existing dataflow that was responsible for the gain. Recently I had built a Job that was to do the historical data load for a data warehouse. The Job… Continue reading SAP Data Services performance gain from 3 hours to 30 seconds

How To, SAP Business Objects Enterprise, SAP Data Services, Technology

Building a SAP BI 4 Demo System

This article provides a summary of the high level steps involved with building a SAP BI 4 Demo System and provides guidance on hardware and software requirements and links to where software can be downloaded from. The Demo System will host SAP Business Objects 4.0 and SAP Data Services 4.0 Overview The demo server consists… Continue reading Building a SAP BI 4 Demo System

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

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

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

Developer Suite, SAP Business Objects Enterprise

Part 2. Developing BOE Java Web Applications using Eclipse

In the previous article we looked at setting up Eclipse for developing Java web applications. In this article we'll look at the additional configuration required for the development of Java web applications that use the BusinessObjects SDK. Contents Part One Prerequisite Software Resources Install Eclipse Install the Eclipse Plugins for Web Application Development Configuring Eclipse… Continue reading Part 2. Developing BOE Java Web Applications using Eclipse