Hi,

Here is the query auto generated in

select distinct T460193.Expiry as c1,

  T155106.X_MEMBER_NUM as c2,

  T155106.X_PROGRAM_NAME as c3

from

  W_LOY_MEMBER_D T155106 /* Dim_W_LOY_MEMBER_D */ ,

  (select

a.member_wid as ROW_WID,

a.expiration_dt as ExpirationDate,

sum(a.accrualed_value) as AccruedValue,

sum(a.x_used_value) as UsedValue,

sum(a.accrualed_value - a.x_used_value) as Expiry,

p.point_type_name as PointType,

extract(month from a.expiration_dt) as ExpirationMonth,

extract(year from a.expiration_dt) as ExpirationYear,

to_char(a.expiration_dt,'MM-YYYY') as ExpirationMMYY

from w_loy_accrual_item_f a,

w_loy_point_type_d p

where

a.pointtype_wid = p.row_wid

group by

a.member_wid,

p.point_type_name,

a.expiration_dt) T460193

where ( T155106.ROW_WID = T460193.ROW_WID and T155106.X_PROGRAM_NAME = 'TAPPMe' and T460193.PointType = 'TAPPMe' and T460193.ExpirationDate between TO_DATE('2017-12-02' , 'YYYY-MM-DD') and TO_DATE('2017-12-31' , 'YYYY-MM-DD') ) )

select D1.c1 as c1, D1.c2 as c2, D1.c3 as c3, D1.c4 as c4 from ( select distinct 0 as c1,

  D1.c1 as c2,

  D1.c2 as c3,

  D1.c3 as c4

from

  SAWITH0 D1

order by c3, c4, c2 ) D1 where rownum <= 5000001

yeah

the filter is as you mentioned