Creating Bucketed Measures
Important: Bucketed measures are not supported
for Live Access sources. Although a bucketed measure can be defined in
a Live Access space and it will appear in Designer, it will not work.
Normally, attributes are values that are provided directly in the source
data. Attributes in general can be used to group measures. Sometimes,
however, it is useful to define groups based on measures. Infor provides bucketed measures
for this purpose. Bucketed measures allow a designer to take a given measure
and define ranges of values, or buckets. These buckets can then be used
like any other attribute to group other measures.
As an example, suppose you wanted to compare discounting behavior of
large versus small customers. If there is no data field assigned to a
customer to indicate large versus small, you could create a bucketed measure
to measure each customer and determine their category. If you decided
that the difference between large and small customers are those that have
an order volume of over 1,000 units vs. under 1,000 units, you could
create a bucketed measure attribute that makes this distinction and name
it Customer Size Category. You would specify a category called Large with
the minimum value set to 1,000 and the maximum value set to 10,000 and
a Small category with a minimum value of 0 and a maximum value of 1000.
For snapshot-based measures (defined on sources with Rows
in Data Source are Transactions unchecked in the Properties tab of
Manage Sources), you should use the Analyze By Date versions of the measures,
as Infor will automatically
query the buckets from the most recent snapshot of the measure table,
rather than potentially double count the measure value across snapshots.
For measures from transactional sources, you can use either the load date
version (no time prefix) or one of the Analyze by Date versions.
To create a bucketed measure
|
1.
|
Go to Admin - Customize Space - Bucketed Measures. |
|
2.
|
Click Create.
The Add Bucketed Measure dialog box opens. |
|
3.
|
Type a name
for the new bucketed measure. |
|
4.
|
Select a Measure
Prefix, the Measure to Bucket, the Dimension and the Level. |
|
5.
|
Click Add
under the Buckets table to add a bucket. Add as many buckets as you need. |
|
6.
|
Optionally,
specify a default category name and a null category name. |
|
7.
|
Click OK.
The new bucketed measure will be listed on the Bucketed Measures page. |
Tip: To modify or delete a bucketed measure,
select the bucketed measure and click either Modify or Delete.
See Also
Creating Custom Attributes
Creating Custom Attributes
Expressions Reference
Infor
Logical Query Language Functions Reference