Usage Example

The purpose of Data Warehouse is to simplify the queries that must be run by your reporting tools. Shown below are two queries that fetch the same data—the project type, main assignee, and default category for a specific Dispute project.

To fetch this information from the operational TeamConnect database:

SELECT
    Y_OBJECT_DEFINITION.OBJECT_TITLE
    T_PROJECT.NUMBER_STRING
    T_PROJECT.NAME
    T_CONTACT.NAME
    T_CONTACT.FIRST_NAME
    Y_OBJ_CATEGORY.NAME

FROM
    Y_OBJECT_DEFINITION
    T_PROJECT
    J_PROJ_ASSIGNEE
    Y_USER
    T_CONTACT
    Y_OBJ_CATEGORY

WHERE     
    T_PROJECT.NUMBER_STRING='123'
    AND Y_OBJECT_DEFINITION.OBJECT_TITLE = 'Dispute'
    AND Y_OBJECT_DEFINITION.ENTITY_CODE ='PROJ'
    AND Y_OBJECT_DEFINITION.APPLICATION_ID = T_PROJECT.APPLICATION_ID
    AND Y_OBJ_CATEGORY.PRIMARY_KEY=T_PROJECT.DEFAULT_CATEGORY_ID
    AND T_PROJECT.MAIN_ASSIGNEE_ID=J_PROJ_ASSIGNEE.PRIMARY_KEY
    AND J_PROJ_ASSIGNEE.USER_ID=Y_USER.PRIMARY_KEY
    AND Y_USER.CONTACT_ID=T_CONTACT.PRIMARY_KEY

To fetch this information from Data Warehouse:

SELECT
    WH_PROJECT_DISP.OBJECT_TITLE
    WH_PROJECT_DISP.PROJECT_NUMBER
    WH_PROJECT_DISP.PROJECT_NAME
    WH_PROJECT_DISP.MAIN_ASSIGNEE_NAME
    WH_PROJECT_DISP.MAIN_ASSIGNEE_FIRST_NAME
    WH_PROJECT_DISP.DEFAULT_CATEGORY
FROM
    WH_PROJECT_DISP
    WHERE WH_PROJECT_DISP.PROJECT_NUMBER ='123'

As you can see, Data Warehouse makes querying simpler and more intuitive.