Databases Reference
In-Depth Information
Tuples and Sets
A
Tuple
is a collection of members from different dimensions that represent a slice
of data from the database. A tuple can contain one member from each dimension.
A tuple should be wrapped in parentheses when written. In theory, each cell in the
Essbase cube is defined by a tuple with one member from each dimension. A single
member is also considered a tuple.
A tuple is an easy way to describe a slice of data from an Essbase database.
A correctly written tuple can contain very few actual words, but can describe
a large amount of data.
Here is an example of a tuple:
(Total Market. United States)
The tuple above will return all data at the Total Market level for the United States.
Null Dimensions or Null member
references are not valid tuples.
Sets
are an ordered collection of tuples. A set can be empty, have one tuple,
or it can have more than one tuple. Duplicates of tuples are allowed. Sets
are enclosed in curly brackets.
Here is an example of a set:
{C
ALENDER PERIOD.2008}—
deines one Tuple
{CALENDER PERIOD.2008, CALENDER PERIOD.2007}—
deines sets of two Tuples
Pros and cons of ASO and BSO
As you have seen earlier in the chapter, there are some differences between the ASO
and the BSO. Even though there are differences, we would like the reporting output
to be the same and the analyst who is running the report should not even know to
which type of database he is connected. Let us take some time to look at a few of
the pros and cons between these two types of databases.
