Databases Reference
In-Depth Information
Notice in the
Field Properties
screen how we replace the wrongly formatted date
column with the correct format. There are other options as well depending on your
specific needs.
Finally, looking at the data in the first column, we see that what were once two
separate columns with the wrong date format is now one column of correctly
formatted data which will successfully load into our Esscar database. Total
development time for this column was about 15 minutes. This is how you make
your data Essbase-friendly!
Types of data sources
A typical data source for your Essbase database can contain many bits of
information. Unlike traditional relational databases, Essbase data sources can be
actual data values or they can be metadata. Because you can update your database
outline dynamically with the same data that you ultimately load, data sources in
Essbase take on a completely different meaning than in other types of systems.
When talking about data sources in Essbase, any of the following can be considered.
Type of data
The data loaded into Essbase can be of two types, one is to load the data into
the cube and the other is to update the outline of the cube:
•
Data loads
: These are the actual data values. This would be the numeric
value of one of the existing measures in the database. This type of Essbase
data source is usually the only usable type of data source in a traditional
relational database.
