Having resolved my DB2 client issue I now have an issue with the Import Wizard of BusinesObjects XIr2. When importing a BIAR file to BOE the Import Wizard crashes right at then end when I clicked on Finish. To fix this was simple enough. The Import Wizard creates a log file when it performs an… Continue reading BusinessObjects XIr2 Import Wizard Crashing
Category: Technology
Articles relating to the technology used for BI soutions
Date Maths – IBM DB2
This article continues the Date Maths series, this time with DB2 syntax. DB2 Reference can be found at IBM and details of SQL functions are found in the section Database Reference > SQL > Functions Please refer to the other articles in this series on SQL Server and Oracle. IBM DB2 Date Functions System Date… Continue reading Date Maths – IBM DB2
DB2 Client Configuration Issues
Recently I had trouble running and configuring a DB2 client installed on Windows XP and thought I'd share what went wrong and how to resolve the issue as it wasn't immediately obvious. The IT centre installed DB2 client on a remotely accessed Windows desktop but when I logged in I couldn't use the client. The first… Continue reading DB2 Client Configuration Issues
Date Maths – SQL Server
This article is the first in a series that lists date functions and date manipulation calculations for leading database systems and this article looks at the first of those - Microsoft SQL Server. Please refer to the other articles in this series on DB2 and Oracle. Rather than providing a list of all possible calculations… Continue reading Date Maths – SQL Server
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
Al Gulland 
You must be logged in to post a comment.