calculate previous Month

building semantic layer
1

I need a calculate previous month data only previous month

ie 1 april to 31st April when i am in mAy even when the user refreshes the report on any date in may he has 2 see April data ie previous months data

In June he will se may data

is it possible to create such filter at universe level

I managed to get previous month filter but that goes 30 days back from sysdate

am using oracle i have made a filter like mydate between (add_months?(sysdate-1 and sysdate

but that gives 30 days from today

i need only previous month

amruta (BOB member since 2007-04-24)

2

hi

See the post on Dave’s blog at http://www.dagira.com/2007/09/12/dynamic-dates-part-iii-monthly-date-ranges/
regarding the dynamic dates.
This will help you get the tools to get your data.

Thanks

siddhartha.dubey :india: (BOB member since 2006-09-13)