Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Creating Dynamic Filter in Universe

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.....

Not what you were looking for? View more on this topic or Ask a question