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
Category: Universe Design
Best practices, hints and tips of Universe Design
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
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
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
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
Al Gulland 
You must be logged in to post a comment.