Jump to: navigation, search

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.

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on December 19, 2017, at 02:26.