Table of Contents

 

Data Integration Utility Overview

Application Overview

Web Application Overview

Process Overview

Other Functions

Upload CSV's to Staging Environment

Overview

Instructions

Login to The Web Application

Upload a CSV File

Overview

Stage Table Statuses

Avoiding CSV Errors

Generate Data Integration Layer

Overview

Instructions

Log In to The Web Application

Generate DIL -- No Errors

Rebuild Cubes on proCube

Overview

Instructions

Navigate to proCube Functions

Loading Data in Logical Units of Work

Scenario Example: New Dimensional Data / New Fact and Dimensional Data

Scenario Example: New Fact Data

Scenario Example: New Hierarchical Data (Stage_GL_Rollups)

Data Loading Tips

Consistent Approach

Data Loading Considerations in Production

Monitor Service

Overview

Large File Processing

Straight-Through Automated Upload

Overview

Prerequisites

Process Explanation

Usage

Common Scenarios

'''CSV Files Uploaded, But A Required CSV File Failed Upload'''[[BR]]

'''CSV Files Uploaded, But Stage Environment Invalid'''[[BR]]

'''CSV Files Uploaded, Stage Environment Validated, But DIL and proCube Rebuild Step Failed'''

Notification Service

Prerequisites

Usage

Troubleshooting

CSV Error Handling

Generate Data Integration Layer -- Errors