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, 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

SAP Business Objects, Universe Design

Date Objects Every Universe Should Have

A large amount of data analysis will use dates to filter or group results. This article looks at what objects and predefined conditions we should include in your universe that provide rich functionality to report authors that are querying with dates. The code examples below mainly use SQL Server syntax and apologies to those of… Continue reading Date Objects Every Universe Should Have

Information Delivery, SAP Business Objects, Universe Design, Web Intelligence

Limitations with using System Date part 1

Often in a reporting or data analysis scenario the analyst or business user wants to view data that is current, for example, sales for the current week or employee turnover for the current month etc. The analyst could create the report and then just enter whatever the current date is or in a operational report… Continue reading Limitations with using System Date part 1

Information Delivery, SAP Business Objects, Universe Design, Web Intelligence

Limitations with using System Date part 2

In the previous article we looked at why using System Date functions in a BI solution can lead to difficulties in development and testing. In this article we are going to look at several alternatives to using system date functions. Contents Problem Overview Creating a Query that Returns Current Data The Easiest Method The Max… Continue reading Limitations with using System Date part 2

Information Delivery, SAP Business Objects, Universe Design, Web Intelligence

Limitations with using System Date part 3

In the last article we looked at alternatives to returning the system date in the report queries. This article looks at the report and alternatives to using system date functions in report calculations Contents Problem Overview Creating a Query that Returns Current Data The Easiest Method The Max Date Method Flagging Today‚Äôs Date in the… Continue reading Limitations with using System Date part 3