Can we create a action that updates current month in time dimension of both hub and spoke.
Hi @MaithriK ,
You can achieve this easily through cloud works. Just create 2 line items in one line line item manually select current month and next line item put it as current month line item+1. Import from Current Month +1 to Current month every month (That you can schedule through cloud works).
Can you create them in each model independently and then schedule them together in an integration flow using Cloudworks?
There is no other native way to create an import/process that has a target in two separate models. Other integration tools could also work, depending on what you have available.
Can we create a action that updates current month in time dimension for each month in the DH?