How To, SQL Server, Universe Design

Migrate SAP BusinessObjects sample databases to Microsoft SQL Server

Introduction Two sample Microsoft Access databases come with SAP BusinessObjects Enterprise: eFashion and Club. This article describes the steps involved in migrating the eFashion database to Microsoft SQL Server. The Club database can be migrated in a similar manner. Overview To migrate the database we use Microsoft's SQL Server Migration Assistant, a tool that creates… Continue reading Migrate SAP BusinessObjects sample databases to Microsoft SQL Server

How To, Statistical Analysis, Web Intelligence

Linear Regression Analysis and Web Intelligence

This article looks at how to do linear regression analysis in Web Intelligence. Linear regression is a statistical technique for analysing data in order to obtain a measure of correlation between two variables where the relationship between the variables is expected to be linear. Web Intelligence does not contain a full set of formula for… Continue reading Linear Regression Analysis and Web Intelligence

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

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

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