The reason this subject is something worth discussing here in Essbase is because unlike traditional relational database packages, Oracle Essbase includes many easy to use tools to quickly transform, alter, modify, or otherwise turn questionable data into good, usable data that can be fully and correctly loaded into your Essbase database. Creating Essbase-friendly data can be accomplished with a minimum amount of effort and expense, both on the Essbase side and the data source side, which is sure to please even the toughest business customer who no doubt is aware of how creating an extract of data from a traditional system sometimes means a lot of effort and even the writing of a complex program or two.
First, to make sure you understand, when loading data in Essbase the data must contain a representative element of data for each dimension in the target Essbase database's outline. For example, our Esscar database outline contains seven dimensions, so the data...