Usage Example
In this section gives the outline of usage examples in Data Warehouse.
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.