Overview

Metadata Builder 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.