How To, Information Delivery, SAP Business Objects

SAP Business Objects Data Services, SQL Server Express and Java 6

This articles looks at configuring the following components, SAP Business Objects Data Services XI3.2 SQL Server Express 2005 Tomcat 5.5 JDK 1.6 The JDK 1.6 is not supported and indeed when trying to configure the Management Console to connect to a repository created in SQL Server Express 2005 we get the following error, Java Runtime… Continue reading SAP Business Objects Data Services, SQL Server Express and Java 6

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