Getting Started

Tasks

Additional Information

• Access To Data Import

• Introduction to Data Import

• Excel Import File Types: Transactions or Time Series

• Data Import Requirements Checklist

• Data Import Initial Setup Checklist

Video

• How It Works

Setting Up Data Import For Users

• Make Categories Available For Use With Data Import

• Enable Data Steward Features For Security Administrators

• Enter Connection Details for Stratum Cloud Import Locations

• Specify Upload File Location For Data Imports

Using Data Import

• Add A Data Import - Excel, CSV, Text Data Source

• Add A Data Import - SQL Server DB Data Source

• Add A Data Import - Azure Cloud Data Source

• Add A Data Import Template

• Adjust Data Mapping And Import Configuration

• Delete a Data Import

• Delete a Data Import Template

• Edit a Data Import Template

• Process a Data Import

Import File Examples & Setup

• Excel Imports With Time in Every Row of Import File (Transactions Import Type)

• Excel Imports With Time in a Header Row of Import File (Time Series Import Type)

• Tips For Setting Up Your Excel Imports

• Tips For Using Other Types Of Import Sources

Windows

• Category Window

• Choose The Source Of Data For This Import Menu

• Data Import Information Window

• Data Import List Window

• Data Import Templates List Window

• Data Import Templates Maintenance Window

• Data Import Template Selection Window

• Data Mapping - Data Import Window

• Import Configuration Window

• Open Window

• System Configuration Window

Advanced Concepts

• Automatic Data Mapping And Import Configuration

• Choose A Different Template For Your Import

• Data Import Templates

• Imports Where Stratum Master Data Doesn’t Exist

• Review Dimension Details For A Target Category

• Review Processing Details For A Data Import

• Send Automatic Email Notifications About The Processing of Data Imports

• Specify An Email From Address For System Generated Emails

• Understanding Your Imported Data

• Using Stratum Cloud Import API For Data Imports

FAQ's

• Can I Import Data Into More Than One Measure At a Time?

• How Many Rows From My Import File Got Imported?

• What Does a “Measure Can Be Only Selected as the Target of One Column” Message Mean?

• What Does “The Measure and Transaction Date for Each Measure Column Must Be a Unique Combination” Message Mean?

• What Does an “Import Calendar Not Defined” Processing Error Mean?

• What Does an “OLAP Storage Engine Attribute Key Cannot Be Found” Processing Error Mean?

• What Happens If I Change A Category From Enhanced/User Controlled To Standard/Corporate Controlled?

• What Happens If I Delete A Data Import That’s Been Processed?

• What Should I Do If An Import File Size Exceeds Maximum Allowed Size?

• Why Can’t I Delete A Data Import?

• Why Are Dates or Times Not Showing in the Expected Format in a Data Mapping Preview?

• Why Aren’t Some Measures Showing as Options When I Map Data for an Import?

• Why Did Import Data Get Added To A Dimension’s Default Value ‘?’ Member?

• Why Did Less Data Than Expected Get Imported?

• Why Did Less Data Than Expected Show In My Import Preview?

• Why Did More Data Than Expected Get Imported?

• Why Did More Data Than Expected Show up in My Import Preview?

• Why Didn’t I Get an Email About a Data Import After it Finished Processing?

• Why Didn’t The Import Configuration Window Show When I Uploaded An Import File Or Table?

• Why Isn’t A Stratum Category Displaying In The Category Window?

• Why Were Negative Numbers Treated as Positive Numbers?

• Why Were Some Mapping Selections Made For Me Automatically & Can I Change Selections?

Definitions

• Data Steward

• Enhanced Category: Data Steward Or User Controlled

• Measure

• Regular Measure Item

• Standard Corporate Controlled Category

• Target Category For Data Import