BusinessObjects Board

Universe - userResponse date and calculated date using that

building semantic layer
#1

Hi
I need to create a derived table with a prompt and based on user entered date, i need to get first date of the same month and previous month last day.

example

8/18/2017 – user enters

I need 8/1/2017 and 7/31/2017

I need to create a derived table using these 3 dates. Please let me know

Thanks

lallir (BOB member since 2007-07-02)

#2

Why do you need a derived table to hold one row? You can find formulae for pretty much all date calculations for most databases in the sticky here: DB-specific Relative Dates SQL Server, Oracle, Netezza, DB2

Depending on your database, use the correct ones and create two new objects for first date of current month and last day of last month.

Debbie

Debbie :uk: (BOB member since 2005-03-01)