Databases Reference
In-Depth Information
Next, we're going to create a calculated column, which will indicate that the data in this
projection is
REAL
data.
Right-click on
Calculated Columns
in the
Output
pane, and select
New
. The
Calculated Column
dialog (identical to the
Calculated Attribute
dialog and the
Calculated Measure
dialog) will
appear, as shown in the following screenshot:
Our calculated column should be created as specified in this screenshot. It's a text-type field,
which contains the value
REAL
.
The expression used to indicate the value
REAL
just contains
the word
REAL
, in single quotes, as shown in the screenshot.
Click
Add
to complete creation of the calculated column.
Now we need to add a second projection; join it to the
PROJECTED
view, and define our
output columns. For the
REAL
data in the projection we just created, we used the
ORDER_
YEAR
field from the underlying analytic view. For our
PROJECTED
data, we will use the
NEXT_YEAR
field, instead of
ORDER_YEAR
, since
NEXT_YEAR
contains the projected year
value. Likewise,
ORDER_AMT
will be replaced with
PROJECTED_SALES
. Please add these
fields to the
Output
pane.
In this projection too, we will create a calculated column, just like in the first projection, only this
time it will take the value
PROJ
. Please do this now, using the instructions given to create the
REAL
calculated column in the first projection.
Our projections are now ready—one containing the current real data, the other containing the
projected data for the value
2012
—we can now merge the data from them into one unified view,
ready for consumption.