As of Friday October 16th, access to restricted content on this site now requires you to log in with your Genesys account. If you don't have an account, you can request one at these locations: Request MyPartner Portal Account or Request My Support Account.
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 varchar(32) Values in the business value granularity of 5—that is, “1–5”, “6–10”, and so on.
BUSINESS_VALUE_RANGE_10 varchar(32) Values in the business value granularity of 10—that is, “1–10”, “11–20”, and so on.
BUSINESS_VALUE_RANGE_50 varchar(32) Values in the business value granularity of 50—that is, “1–50”, “51–100”, and so on.
BUSINESS_VALUE_RANGE_100 varchar(32) Values in the business value granularity of 100—that is, “1–100”, “101–200”, and so on.
BUSINESS_VALUE_RANGE_500 varchar(32) Values in the business value granularity of 500—that is, “1–500”, “501–1000”, and so on.
BUSINESS_VALUE_RANGE_1000 varchar(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.
This page was last edited on February 24, 2015, at 17:50.

Feedback

Comment on this article:

blog comments powered by Disqus