v
Time state rollup
cannot be applied to a measure if the model has more than
one time dimension.
v
If you use
Time state rollup
but more than one record is associated with each
data point, values will be summarized using
Regular rollup
. For example, if
there are two inventory stock counts daily, the two records will be summed even
though you specified a
Time state rollup
function of
Last period
.
v
You can use calculated columns to consolidate multiple measurements. If you
do, you should also set the
Regular Timing
option to
Before Rollup
. Otherwise,
the measures are calculated after rollup (the default), which yields inaccurate
results.
v
If a record is missing, you may get zeros when you apply a rollup. For example,
if you select a time state rollup of
Last period
, but your source data does not
contain records for every day of every month, then whenever values are missing
for the last day of the month, the OLAP report will show a zero.
v
A time-state rollup of
Average
may also result in zeros, but you can specify that
any missing values display as
NA
(or
na
) in the OLAP reporting components.
v
If you select a time-state rollup of
Average
, the
Days in week
selection affects
the results. If the
Degree of detail
is
Day
, and your
Days in week
selection
excludes weekends, the records for each month are summed and then divided
by the number of categories (non-weekend days) in that month.
v
If you insert a measure into a model where other measures have different
settings for the
Degree of detail
property, the inserted measure displays =NA,
unless you initially set it to the lowest degree of detail. If all measures in the
model have the same setting for the
Degree of detail
property (for example, all
measures are set to
Month
), the inserted measure is displayed correctly.
Procedure
1.
Open the
Measure
property sheet and click the
Rollup
tab.
2.
In the
Time state rollup
box, select a rollup function.
If you select the
Average
function, you can weight the average by selecting a
measure from the
Time state weight
box. However, the measure associated
with the weighted values must have a
Rollup
function of
Default (Sum)
or
Sum
.
3.
Click
OK
.
Example - Setting a Last Period Time State Rollup for Inventory
Counts
Your source data contains warehouse inventory counts for the middle and end of
each month. You want an OLAP report that shows inventory at the end of each
quarter.
Your source data is as follows:
Date
Product
QTY
20060915
TR139SQ
500
20060930
TR139SQ
200
20061015
TR139SQ
300
20061031
TR139SQ
300
104
IBM Cognos Transformer Version 10.1.1: User Guide
Summary of Contents for Cognos
Page 1: ...IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 106: ...92 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 136: ...122 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 160: ...146 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 174: ...160 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 326: ...312 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 352: ...338 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 394: ...380 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 398: ...384 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 411: ...Y year function 362 years between function 362 Index 397 ...
