Hi Team,
We are forecasting the sales for multiple departments for a retailer. I have created a ARIMA model with different p d q for each department. So there is one workflow for each department.
Now the requirement is to have one workflow and pass the p d q for each department and generate forecast automatically using one workflow.
It will be a great help if someone can help me achieve this.
Regards,
Ritika
Hi @ritikat ,
I think that is doable with a batch macro. You can use a control parameter to change each one of the p,d,q coefficients and the department and the batch macro will run for each combination of them.
Then you can save the output of each model in a yxdb file and use the department as a prefix to tell which output corresponds to which department.
Hope that helps,
Angelos
You can also consider using the TS Factory tools, free for download on the Gallery. Here's a sample workflow using the TS Factory tools, and here's an article describing the two approaches.