Jump to: navigation, search

BUSINESS_VALUE Dimension

BUSINESS_VALUE is a static dimension that contains ranges to define the business value assigned to a task. You can query this dimension to determine how many tasks fall within a particular range—for example:

SELECT 
    COUNT(INTERACTION_ID) CNT, 
    BUSINESS_VALUE_RANGE_100 RNG
FROM BUSINESS_VALUE BV
    LEFT JOIN I_TASK_FACT I ON
        I.BUSINESS_VALUE_KEY = BV.BUSINESS_VALUE_KEY
WHERE BV.BUSINESS_VALUE_KEY < 1000
GROUP BY BUSINESS_VALUE_RANGE_100
ORDER BY BV.BUSINESS_VALUE_KEY
The BUSINESS_VALUE Dimension
Field Data Type Description
BUSINESS_VALUE_KEY int Primary key of this table.
BUSINESS_VALUE_RANGE_5 nvarchar(32) Values in the business value granularity of 5—that is, “1–5”, “6–10”, and so on.
BUSINESS_VALUE_RANGE_10 nvarchar(32) Values in the business value granularity of 10—that is, “1–10”, “11–20”, and so on.
BUSINESS_VALUE_RANGE_50 nvarchar(32) Values in the business value granularity of 50—that is, “1–50”, “51–100”, and so on.
BUSINESS_VALUE_RANGE_100 nvarchar(32) Values in the business value granularity of 100—that is, “1–100”, “101–200”, and so on.
BUSINESS_VALUE_RANGE_500 nvarchar(32) Values in the business value granularity of 500—that is, “1–500”, “501–1000”, and so on.
BUSINESS_VALUE_RANGE_1000 nvarchar(32) Values in the business value granularity of 1000—that is, “1–1000”, “1001–2000”, and so on, with a maximum value of 50000.
BUSINESS_VALUE_RANGE_5_STA int Values that mark the start of each BUSINESS_VALUE_RANGE_5 range. Values step by 5—for example, 1, 6, 11, and so forth.
BUSINESS_VALUE_RANGE_5_END int Values that mark the end of each BUSINESS_VALUE_RANGE_5 range. Values step by 5—for example, 5, 10, 15, and so forth.
BUSINESS_VALUE_RANGE_10_STA int Values that mark the start of each BUSINESS_VALUE_RANGE_10 range. Values step by 10—for example, 1, 11, 21, and so forth.
BUSINESS_VALUE_RANGE_10_END int Values that mark the end of each BUSINESS_VALUE_RANGE_10 range. Values step by 10—for example, 10, 20, 30, and so forth.
BUSINESS_VALUE_RANGE_50_STA int Values that mark the start of each BUSINESS_VALUE_RANGE_50 range. Values step by 50—for example, 1, 51, 101, and so forth.
BUSINESS_VALUE_RANGE_50_END int Values that mark the end of each BUSINESS_VALUE_RANGE_50 range. Values step by 50—for example, 50, 100, 150, and so forth.
BUSINESS_VALUE_RANGE_100_STA int Values that mark the start of each BUSINESS_VALUE_RANGE_100 range. Values step by 100—for example, 1, 101, 201, and so forth.
BUSINESS_VALUE_RANGE_100_END int Values that mark the end of each BUSINESS_VALUE_RANGE_100 range. Values step by 100—for example, 100, 200, 300, and so forth.
BUSINESS_VALUE_RANGE_500_STA int Values that mark the start of each BUSINESS_VALUE_RANGE_500 range. Values step by 500—for example, 1, 501, 1001, and so forth.
BUSINESS_VALUE_RANGE_500_END int Values that mark the end of each BUSINESS_VALUE_RANGE_500 range. Values step by 500—for example, 500, 1000, 1500, and so forth.
BUSINESS_VALUE_RANGE_1000_STA int Values that mark the start of each BUSINESS_VALUE_RANGE_1000 range. Values step by 1000—for example, 1, 1001, 2001, and so forth.
BUSINESS_VALUE_RANGE_1000_END int Values that mark the end of each BUSINESS_VALUE_RANGE_1000 range. Values step by 1000—for example, 1000, 2000, 3000, and so forth.

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on December 19, 2017, at 02:26.