I read in the SQL Reference that Global Variables are not allowed in MQT's. CURRENT DATE is also not allowed in MQT's.
A lot of my views useing the actual year in their sql-code.
How can I create MQT's without hard-coded the actual year in the select statements of the views?
is there any other way to use a global variables in MQT's? or any idea how can I solve this?