Creating Dynamic Filter in Universe

[sachin_v_joshi]

Hi Experts,

I 'm trying to achieve a filter at Universe level where in it can take dynamic dates such as

1. CurrentYear-CurrentMonth
2. CurrentYear-PreviousMonth,etc..

When I try to create filter .. what would be used in the Where clause ?

We are on BO 4.1SP3 and MS Sql Server 2005

For CurrentYear-CurrentMonth, Formula is [convert(varchar(6),getdate(),112)]

and for CurrentYear-PreviousMonth, formula is [convert(varchar(6),dateadd(mm,-1,getdate()),112)]

Can some one help me out here.....

[sachin_v_joshi]

Appreciate any responses on the above..