Tabs for Data Load
1. When performing an Essbase Data Load, you have three data loading (mathematical) operations. For sake of an example, a specified intersection of data equals $10 and your new data is $3. You can “Overwrite existing values” which will turn $10 into $3, you can “Add to existing values” which will turn $10 into $13 and you can “Subtract from existing values” which will turn $10 into $7. Depending on your environment, each one of those can be utilized for different purposes.
2. This section can be tricky. An example i like to use is from an application i built a couple years ago, we have an revenue account coming in from the source with a “-“. Its just the way the source worked, so I flagged all revenue accounts with a UDA of “RevFlip”. By doing this, any dollars that came in for any of these accounts, any negative dollars were flipped to positive and vise versa. So to make it work, you would specify the UDA and the dimension it is associated with.
Tab for Header Definition
3. As I mentioned in the Field Properties section, if a data feed does not have a specific dimension represented, a user could a new column with a given text string (“Misc”). This option will work for you, but it is not clean, instead, use the Header Definition identified here. Simply, add the default member name to the Name box at the top, or you can navigate to it in the and double click on it. When you have more than a couple dimensions not represented from the data source, this is a one stop shop for you to apply all your defaults.