Filter on Week

building semantic layer
1

How to create a filter to get only last five firday’s from current date.

I tried in SQL iam getting but when I am trying to implement in Universe object is not getting parsed.

select Lastbusinessday from (
select distinct TO_CHAR(R.DATE-5,‘DD-MM-YYYY’) as Lastbusinessday
from PRODUCT R ORDER BY TO_CHAR(R.DATE-5,‘DD-MM-YYYY’) asc
)where rownum <=6

Mike12 :uk: (BOB member since 2009-12-23)

2

try this sql.

select day_code from DIM_TIME 
where day_code > sysdate - 35
and day_code <= sysdate
and trim(TO_CHAR(day_code, 'DAY')) = 'FRIDAY'

Rakesh_K :india: (BOB member since 2007-12-11)

3

If you are sorting the output as a character column, it won’t sort chronologically. If you span the end of a month, the dates will come out in the wrong order.

It may not be parsing because your table name PRODUCT R contains a space? Just an idea.

debbie

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

4

Here R is alias. 8)

Rakesh_K :india: (BOB member since 2007-12-11)

5

So it is! I should read the SQL more closely… :oops:

debbie

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