We are going to look at another feature in MMM.
MMM can be used to update OneStream metadata using a SQL query making automation much more easier
The important feature of MMM is its capability to perform a “Replace” load instead of a “Merge.”
This video shows how to update OneStream metadata using a SQL query and MindStream toolbox (MMM).
You can upload varying member properties (slowly changing dimension) using SQL (UNPIVOT).