Creating Dynamic Filter in Universe
I 'm trying to achieve a filter at Universe level where in it can take dynamic dates such as
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.....