Webi query

building reports webintelligence
1

I need to create a report returning a graph which will show all items returned in the last 7 days. How can I do this in sql or webi ?

gogo (BOB member since 2005-06-03)

2

By creating either a predefined condition or a date object(having last 7 days expression) and then using the same in webI query panel to design a report
.

haider :es: (BOB member since 2005-07-18)

3

Sounds good what is the PL/SQL syntax to return the last 7 business days ?

gogo (BOB member since 2005-06-03)

4

For Oracle:

 EMP.HIREDATE BETWEEN SYSDATE AND SYSDATE -7

To specifically get last 7 business days use calendar table in your database while creating the above condition
.

haider :es: (BOB member since 2005-07-18)

5

Indeed but we only want business days .how do you do the same for only business days ?

gogo (BOB member since 2005-06-03)