Databases Reference
In-Depth Information
•
Create Using Join
: This function is used to join two or more fields to
create a new field.
In this example, we have joined the field containing the value of
United
States of America
and the field containing the value
USA
, into a new
field which looks like:
United States of AmericaUSA
, as shown in the
following screenshot:
•
Create Using Text
: Creates a new field based on the text you have entered.
This is particularly helpful when you need to make Essbase-friendly data
that is repeatedly sent from the same source.
As shown in the following example, a field is added between
Field 6
and
Field 7
called
US
: