Dear Gurus, I wish possible workaround on an issue of $ replacement. To make the logic change easy, I have made all the replacement in the initial loading script with SET statement. Single change in the business logic, many graph/grids changed simultaneously.
replacement without input values works. However; if the replacement statement included the input variable, the initialised value seems resident. (See below)
SET CONDITION= [GoodsReceivingDate] <= MonthEnd(Today(0),-$(X));
In this case, X is input value, initialised as '1'. Users may input '5' to have month shift of 5 months.
When loading script run, then '1' is initialised. However, no matter user change X value, the $(CONDITION) remains fixed. *$(=CONDITION) has same result.
Should we refrain using input value in the text replacement?
[Background not using Set Analyses for month field]
I refrained from using Set Analyses due to the report containing various different dates. Order Date, Purchase Date, Goods Receive Date (101), Goods Issue Date (601), .... in fact SAP situation, wname movement type is abundant, I rely on month-shift to combine all of them into the report.
Very interesting to have your feedback: when I see in the variable overview in the original state, it is giving as '1' instead of $(X). Indeed the script inserts the value and automatically calculated it. Somehow LET statement gives straightaway 0 without any expression. I am delving into this matter and I will post a feedback soon.