Sysdate in ESSBASE Substitution Variable
Hi,
I need to create a substitution variable in essbase that will store the value of the sysdate. This value has to dynamic as we use in the query - select sysdate from dual and it should not be a constant.
Please help in creating this substitution variable which will store the sysdate dynamically.
Thanks in advance.