Groovy to Set Substitution Variables for BSO Cube
Summary:
I am looking for some assistance with Groovy rule to Set Substitution Variables for BSO daily cube:
ReportDate for BSO cube should be Today minus 1 in the format Sep 04
DOR_BSO_Date for BSO cube should be Today minus 1 in the format "Sep 04"
Content (please ensure you mask any confidential information):
ReportDate for BSO cube should be Today minus 1 in the format Sep 04
DOR_BSO_Date for BSO cube should be Today minus 1 in the format "Sep 04"
These are variables for daily cube. BI Publisher report is using date without the quotes. Clear rule and data push need the quotes for the rule.