11 Tables

This section provides details of Oracle Utilities Data Intelligence analytics tables, such as key columns, data types, and table descriptions. Use the Referred Table and Referred Column information to decide on the join condition between fact and dimension tables.

Download this ZIP file that contains available analytics tables for Oracle Utilities Data Intelligence. After the file downloads, extract the file, open the folder, and then open the release-specific HTML file.

Note:

Most Oracle Utilities Data Intelligence analytics tables include the W$_INSERT_DT and W$_UPDATE_DT system date columns, which identify when a record was inserted or updated in the table. Do not use these columns for reporting purposes. Use these columns with caution for downstream custom ETL because historical records may be truncated and reloaded as required. Some objects in the analytics table reference may not include these columns.