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, Delivery Methodology, Information Management, SAP Data Services

Automated Unit Testing in SAP Data Services. Part I

Introduction One of the key drivers of this article is that although there are many articles on unit testing in general on internet there are hardly any on unit testing with SAP DataServices. Unit testing has been accepted as a key part of the software development lifecycle for projects building applications in languages such as… Continue reading Automated Unit Testing in SAP Data Services. Part I

Delivery Methodology, Information Management, SAP Data Services

SAP Data Services: 10 Reasons for never using Global Variables (and one where you can)

In software programming it is widely held that using global variables or other constructs to maintain global state is a poor programming practice[1] and many of those reasons can also be applied to development of jobs in SAP Data Services. The following is my list of 10 reasons for why you should never use global… Continue reading SAP Data Services: 10 Reasons for never using Global Variables (and one where you can)

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