Hello all,
Is there a way of having a dynamic output filename for scheduled BIP reports going to an email destination?
I have managed to do this using a bursting definition, however bursting does not support filetype xlsx.
I have tried to_char(sysdate,'YYYYMMDD'), %y%m%d etc, but not had any luck - is there some secret syntax/tips anyone has? or is this not possible?
Many thanks,
Ian