BusinessObjects Board

How to add Days in BO 4.2 Query Builder

Hi,
Some reason below query is not working in BO 4.2 query builder. It is throwing an error message saying the it is not a valid query. Any idea?

Select * from CI_INFOOBJECTS WHERE SI_ENDTIME>DATEADD(DAY,1,SI_STARTTIME)

Basically I am adding 1 day on SI_STARTTIME and I am using SQL server.


Philip (BOB member since 2006-03-02)

The Query Builder does not use the syntax of the underlying database. It is very simplistic, and there is no support for any type of date function.


joepeters :us: (BOB member since 2002-08-29)

Thank you so much for info.
Then what is the alternative solution to get this? Basically I am running a query where SI_ENDTIME >SI_STARTTIME+1 Day.
Appreciate your thought on it.


Philip (BOB member since 2006-03-02)

All you can do is select both properties, then compare them afterwards.


joepeters :us: (BOB member since 2002-08-29)

Selecting both properties and compare is a MANUAL steps. I do not want that since I have thousands of schedules. I only need those schedules which ran Start time + 60 secs.


Philip (BOB member since 2006-03-02)

Philip,

You can use a more export-friendly tool like this:

And then take the results in Excel and perform your date calculations in the Excel worksheet.


Atul Chowdhury (BOB member since 2003-07-07)

The new BI-on-BI universe in BI4.2 SP03 might make it a little easier: https://wiki.scn.sap.com/wiki/display/BOBJ/Unlock+the+CMS+database+with+new+data+access+driver+for+BI+4.2


joepeters :us: (BOB member since 2002-08-29)