iWD Views

iWD Data Mart provides a number of read-only views of iWD Data Mart tables, including views of:

• Dimensions
• Intraday fact tables
• Historical fact tables
• Blended fact tables (union of intraday and historical facts)
• Intraday aggregates (hour level)
• Historical aggregates (hour, week, month, quarter, year levels)
• Blended aggregate (union of intraday and historical hour aggregates)

Business users and reporting analysts who create reports by using iWD Data Mart data are isolated by the views in iWD Data Mart from changes that might occur in the underlying iWD Data Mart tables.

The following views are created when the iWD Data Mart is initialized:

iWD Data Mart Views

View Name	Based on ...
DATE_INTERVAL_WEEK	EVENT_DATE
DATE_INTERVAL_MONTH	EVENT_DATE
DATE_INTERVAL_QUARTER	EVENT_DATE
DATE_INTERVAL_YEAR	EVENT_DATE
TIME_INTERVAL_15MIN	EVENT_TIME
TIME_INTERVAL_30MIN	TIME_INTERVAL_15MIN
TIME_INTERVAL_60MIN	TIME_INTERVAL_15MIN
PROCESS_CURRENT_VERSION	PROCESS, DEPARTMENT, SOLUTION, TENANT
PROCESS_CURRENT	PROCESS, DEPARTMENT, SOLUTION, TENANT, PROCESS_CURRENT_VERSION
TASK_EVENT_FACT	H_TASK_EVENT_FACT and I_TASK_EVENT_FACT
TASK_FACT	H_TASK_FACT and I_TASK_FACT
TASK_WORK_FACT	H_TASK_WORK_FACT and I_TASK_WORK_FACT

Refer also to the aggregate views that are created for each subject area.