Data Item
|
Icon
|
Description
|
---|---|---|
Aggregated Measure or Time Period Calculation
|
|
A data item that represents special predefined operations, like distinct count, percentage of totals, percentage of subtotals, or frequency percent. Or, users can
define their own aggregated measure calculations.
Aggregate measures can be used in only some report objects. They cannot be used in
filters, controls, spark lines, or time series graphs. Percentage of subtotal items (including row total, row subtotal, column total,
and column subtotal) can be used only in crosstabs. Some aggregated measure calculations cannot be used in a detail rank.
|
Calculated
|
, , or
|
A data item that is calculated from existing data items by using an expression. For
example, you could create a calculated data item called Profit,
which is created by using this expression:
[Revenue]
— [Cost] , where Revenue and Cost are measures in a data source.
Calculated dates and times are treated as categories with distinct values being governed by the date or time format that you have chosen. Numeric calculated
items can be treated as measures (with an
aggregation type such as Sum, which is applied to each distinct category combination).
Or, you can change numeric calculated items into category data items with distinct values being governed by the number of decimal places in the numeric format.
|
Category
|
|
A data item whose distinct values are used to group and aggregate measures. There are five types of categories: alphanumeric, date, datetime, time,
and numeric. Alphanumeric categories can be made up of all letters, all digits, or
a combination of the two. Categories that have values that are all digits might be
physically stored as character or numeric data. The data type affects how values are handled in relation to some functionality, such as filtering,
sorting, and formatting.
Examples of alphanumeric categories include data items such as Product ID, Country, Employee
Number, and Employee Name.
Alphanumeric categories sort lexically.
Date, datetime, time, and numeric categories are sorted by their underlying numeric values.
Category data items can also be numeric. A category data item sorts differently than an alphanumeric data item. Numeric category data items sort
by number.
Note: If you change a measure to
a category, then it uses this category icon.
The icon indicates a user-defined format category data item. User-defined format categories
can be based on underlying numeric or character data.
|
Date
and Time
|
|
A category data item whose distinct values are used to group and aggregate measures.
There are three types of date categories: date, datetime, and time.
Examples of date, datetime,
and time categories are Order Year, Date
and Time of Sale, and Customer
Wait Time.
|
Geography
|
|
A category data item whose values are mapped to geographical locations or regions.
Geography data items can be used in reports to show your data on a geographic map.
For example, a geography
data item can identify geographic information that is specific to your organization
(for example,
sales regions, warehouse locations, oil platforms, and so on). For more information,
see Working with Geography Data Items.
The geography icon can also indicate that all data items in a hierarchy are based
on geography.
|
Hierarchy
|
|
A data item whose values are arranged with more general information at the top and
more specific
information at the bottom. The first level in the hierarchy is the root level. For example, you might have a Date hierarchy,
which includes the Year (the
root level), the Quarter, and
then the Month. You can also
have geographic hierarchies.
|
Measure
|
|
A data item whose values can be used in computations. These values are numeric. Examples
of measures
include Sales Revenue, Units
Sold, and Salary.
The designer assigns
a default aggregation method to every measure. Almost all measures
are assigned Sum. You can change the aggregation method.
|
<ReportObject>
is
the name of the report object in the report. (For example, List
Table 1, Bar Chart 1,
and so on.)