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:
| 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.
This page was last edited on October 1, 2014, at 11:24.
Comments or questions about this documentation? Contact us for support!