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

Delivery Methodology

BI Project Responsibility Assignment Matrix (RACI)

A RACI is a matrix that summarises who is responsible for what on a project. It also defines who approves a deliverable, who is involved in the production and who is the target audience of the deliverable. The matrix is constructed by placing the project roles in columns and the tasks and deliverables in rows… Continue reading BI Project Responsibility Assignment Matrix (RACI)

Business Intelligence, Delivery Methodology

BI Project Roles and Responsibilities

Having worked on and delivered many BI projects I have realised that one of the factors of a successful project is to have clearly defined roles and responsibilities for the project team members. This ensures that everyone knows what they and everyone else is responsible for and are required to do – no more "that's… Continue reading BI Project Roles and Responsibilities

Business Intelligence, Delivery Methodology

BI Project Deliverables

Introduction This article lists some of the deliverables that are produced as part of a BI project. It is not a fully comprehensive list and the descriptions of the deliverables are brief but the aim is to give an overview the main deliverables so that you have a starting point for your BI project. This… Continue reading BI Project Deliverables

Business Intelligence, Statistical Analysis

Are You A Data Scientist?

FICO, company that provides analytics and decision making services—including credit scoring, have published a new infographic summarising the key skills and attributes required by a Data Scientist. Of course there are skills in statistics, data analysis and application to real world business problems but what other skills should a Data Scientist have? Check out the… Continue reading Are You A Data Scientist?

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, SAP Business Objects Enterprise

SAP BI 4 Checking Database Connectivity

A common issue found when starting SAP Business Objects BI4 is that the system cannot logon to the CMS database repository. Troubleshooting this can be tricky but the following command can be used on a Linux deployment to check connectivity to an Oracle database and capture error messages in a log file, /opt/sapboe/sap_bobj/ccm.sh -isdbempty -dbdriver… Continue reading SAP BI 4 Checking Database Connectivity