Data staging

Data models of the domains Financial data and Administrative data are provided with the add-on. It means that the creation of data spaces and data sets are managed by core EBX® features.

The user can then import data into a data set in a data space, then create an inherited data space to allow users to query and update dimensions and hierarchies. Comparisons between initial data values and modification can be performed with EBX®. Export procedures can be performed based on a specific data set in a data space depending on how workflows need to be organized.

Below is an example using data sets to define several applications in different Hyperion products and a quick overview of a comparison of an account from the Essbase ASO and Essbase BSO applications.

Many uses cases can be built depending on a company's needs. For example, when a hierarchy for a same dimension has differences between two applications, it is possible to create a parent data set and two child data set. Each data set inherits from hierarchy relationships defined in the parent, and each child data set can occult irrelevant relationships or created new ones unknown from the other application. When exporting data, occulted relationships are ignored.