System Date

building semantic layer
1

Is there a way to determine the system date.

I want to create an object which has the date difference between DueDate - ReportRunDate

Arun

Listserv Archives (BOB member since 2002-06-25)

2

Try inserting a cell, right click, and go to Edit Formula. Under Date Functions, select Days Between, then Due Date (from the left column), and then Current Date. It will calculate the difference between the Due Date and today’s date.

George Baranowski
QuadraMed

Listserv Archives (BOB member since 2002-06-25)

3

There is a LastExecutionDate and CurrentDate functions available. Which of them would help you ?

Regards,

Unni

Is there a way to determine the system date.

I want to create an object which has the date difference between DueDate - ReportRunDate

Arun

Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
Web archives (24 hrs. a day now!):
listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
====================================

Listserv Archives (BOB member since 2002-06-25)

4

Use whatever your backend supports - we use Teradata and our developers will have objects like (teradata’s date object is just Date)

Yesterday = date - 1

In oracle I think that would be sysdate -1

Good luck,
Brent

Is there a way to determine the system date.

I want to create an object which has the date difference between DueDate - ReportRunDate

Listserv Archives (BOB member since 2002-06-25)

5

Thanx , it’s working…

Listserv Archives (BOB member since 2002-06-25)

6

Hi,

I have a Business Objects related Query. We are currently using BO 4.1.5

I need to create a new object within the existing data Warehouse universes to return the system date.
This will help new Business Object users to the Warehouse and give existing end users greater flexiblity to run
date orintated queries i.e… count objects over the last 90 days or count objects within the next 3 months etc.

The user should be asked to enter the no. of days +/- the System Date for which he/she wants the data.
I can’t use sysdate in BO as BO does not recognise the “DUAL” table.

Can anyone pleaes let me know how to go about doing this ?

TIA
Ratan

Listserv Archives (BOB member since 2002-06-25)

7

Just have sysdate object point to any table in the universe that you know will be used.

It actually doesn’t need to point to a table at all. It won’t parse correctly, but it will work fine if you use it along with other objects.

Listserv Archives (BOB member since 2002-06-25)

8

Steve

I know you know this but I want to make sure the newer users be careful associating an object with a table. If you create an object with the sql of SYSDATE (Oracle reference) and you associate it with a table say ‘CustomerTable’ you run the risk of inadvertently creating a cartesian product if you use this object with other objects that do not reference the CustomerTable.

Associating an Object with a Table on the “Table” tab will always force that table to be included any time that object is selected. This is a feature that is mostly commonly used to “enforce” security!

In this case my advice to the novice developer is to understand the fact that although an object may not PARSE correctly does not mean the Object will not work when selected for a query. This is a more of a “soft” error or just a warning that the object does not reference a specific table.

My $0.02 …

Mike McErlain

Listserv Archives (BOB member since 2002-06-25)