Skip to Content

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

How to create Current Year Filter at Universe Level ?

Hi,

I want to create a Current Year, Next Year and Last Year filters at Universe Level.

Can anyone help me with this.

I am using Netezza database and not able to find the appropriate date function in Netezza to accomplish this.

Any suggestions ?

Thanks

Former Member
Former Member replied

Hi,

You would somehow need to extract the Year part from the system date..

then

Current Year = Year

Next Year would be i.e Current Year + 1

Last Year would be i.e Current Year - 1

I guess this is the simple part... but you would need to find those functions on your RDBMS..

Hope this helps

Jacques

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