Overview

The Metadata Builder Solution provides a set of functions that turn Excel cell values into OneStream xml strings by using a combination of an Excel Add-In tool and an Excel template file.  The standard templates provide an example of how to use Excel to create tabular layouts referenced in a formula which then produces an xml equivalent string.  Copy and paste the combination of xml strings into a text file with the extension .xml and then load through the standard OneStream Load/Extract feature.