Dynamic Period in Report Connected to ERP Data Source
Summary:
Unable to create a bursting definition in Narrative Reporting that can dynamically spit out monthly report, based on last closed month, when the report is connected to ERP data source.
Content (please ensure you mask any confidential information):
I'm testing a bursting definition in Narrative Reporting that can spit out monthly report (connected to ERP data source) based on last closed month. However, based on my understanding, there is no dynamic variables like “substitution variables” in ERP for us to set the period in the report to “CurrMnth” like in EPM.
In the Bursting Definition, I have AccountingPeriod as Global Dimension. Then in the AccountingPeriod Member Selector dialogue, I see two options: Members or Substitution Variables.