Databases Reference
In-Depth Information
Let us talk about the
Global Properties
and
Data Load Properties
as
Dimension
Build
Properties
were already covered in an earlier chapter.
Global properties
As the term global applies to everything, in this context, global means both
the Dimension Build Properties and Data Load Properties.
These are the settings that can be used in the
Global Properties
tab:
1.
Case
: There are three types of
Case
present:
Original
,
Lowercase,
and
UpperCase
. While updating the dimensions, you sometimes want all
of the members to be upper case or lower case, or it can be left as originally
sent in the data file.
Original
is selected by default. This is particularly
important when you are working with Essbase installed on a Unix platform
as it is case sensitive by default.
2.
Preix
or
Sufix
: This is to add a prefix or suffix to the member so that
the member name is unique. You can add your own prefix or suffix.
3.
Drop leading/trailing spaces
: This is used to trim the member before it
gets loaded into database outline. This is selected by default.
4.
Convert spaces to underscores:
In the earlier versions of Essbase, spaces
were not allowed. Therefore, this property was used to convert spaces to
underscores. This is no longer a problem in newer versions of Essbase, but
this property setting is carried over to allow upgraded systems to continue
operation without major rework.
Data Load Properties
In the previous section, you learned how to set the global properties for your data
load or dimension build. In this section, you will learn how to add only the data load
field properties. Each field in the rule file can be an outline member, data member, or
data that can be ignored. In the
Data Load Properties
, we will define each field and
how it is related to the Essbase outline.
