We have a requirement to add filters to the universe to be available for reporting. Could anyone help with the syntax of the filters? I would really, really appreciate. I know the list is long, and I have done something like this before, but cannot remember, so seeking help from you all These are all date related filters, and I assume we would use sysdate?
o Current Year
o Previous Year
o Current Quarter
o Previous Quarter
o Current Month
o Previous Month
o Last 7 Days
o Today
o Yesterday
Thank you very much, Marek! I will take a look at the link. I also wanted to know if it would be best to create a derived table and create the necessary objects to be made available from the sql in your link, or if I should create universe filters. Are both cases possible? The requirement was to have objects available in a “Date Class.” Usually, in the past, I have seen this in practice with the use of filters only. Thanks!