How to load data from one cube To other cube by Automate process
Originally posted by Ashish Magar
Forum Discussion
- From Design & Reference Guide: "A Workflow Import can use a Data Management Export Sequence rather than a File or Connector. This can be comprised of multiple Data Management Steps. See Data Management in Chapter 11: Application Tools for more information." Once this is set up, assign it to a Data Source and run this through Workflow. See chapters on "Batch File Loading" and "Data Management Automation through PowerShell" for more information.
- Use an api.data.calculate rule on a Scenario to execute a copy from one Scenario (Cube) to another. Start with explanations of this function in Design & Reference Guide and OneStream API Overview Guide, both available under Software on XF MarketPlace. More on Scenario copies is available on OneStream Academy with examples also available under Snippets. This can be automated through Data Management and PowerShell as well.