Constants Date table in BusinessObjects

[system]

I am creating a date constant table in Business Object 6.0, I had created from Microsoft SQL server, but users want it created as a dimension, tried the same syntax but it does not work …

Some of the constants are as follows:
Today’s Date
Start of Last Month
End Of Last Month
A Week Ago
Start of Current Month
End Of Current Month
A Year Ago Today
Year Before End of Previous Month
3 Months Before Start of This Month
Two Years Ago Previous Month
Yesterday
13 months Before Month End

Any help will be appreciated as I am new to Business Objects

---

pespes (BOB member since 2012-05-18)

[system]

Welcome to B:bob:B!

This sticky topic might help you:

DB-specific Relative Dates SQL Server, Oracle, Netezza, DB2

As per this topic on Oracle relative dates, here’s the same set of dates in SQL Server. Please note that some may not work on SQL Server 2000, but all definitely work in 2005/8. Yesterday cast(convert(char(10),dateadd(d,-1,getdate()),23) as datetime) Today cast(convert(char(10),getdate(),23) as datetime) The following also works for today: dateadd(dd, datediff(dd,0,getdate()), 0) Start of Current Month cast(convert(char(7),getdate(),23)+'-01' as datetime) End of Current Month dateadd(d,-1…

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Many thanks Marek,

How do i set this up in Business Objects as a dimension? The users want this done as a dimension and not on the database level…Inorder to allow the dates to be dynamic…

Many Thanks…

---

pespes (BOB member since 2012-05-18)

[system]

What would they do with such dimension?

---

Marek Chladny (BOB member since 2003-11-27)

[system]

I created the constants table on the SQL Server 2000 db used, but the business wants the datetime codes written as a dimension within universe…

Regards,

---

pespes (BOB member since 2012-05-18)

[system]

Use the codes in the link Marek gave you and create an object for each of them. They won’t parse but will work with other objects in queries. I have a “universe” of just date objects which I link in to other universes so I don’t have to keep recreating them.

Debbie

---

Debbie (BOB member since 2005-03-01)