Getting Started

Tasks

Additional Information

• Access To Data Import

• Introduction to Data Import

• 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 User Controlled & Available For Use With Data Import

• Specify Upload File Location For Data Imports

Using Data Import

• Add a Data Import

• Adjust Data Mapping And Import Configuration

• Delete a Data Import

• Process a Data Import

Import File Examples & Setup

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

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

• Tips For Setting Up Your Imports

Windows

• Application Window

• Category Information Window

• Category Window

• Data Import List Window

• Data Mapping - Data Import Window

• Import Configuration Window

Advanced Concepts

• Automatic Data Mapping And Import Configuration

• Imports Where Stratum Master Data Doesn’t Exist

• Review Dimension Details For A Target Category

• Review Processing Details For A Data Import

• Understanding Your Imported Data

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 User Controlled To 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?

• 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

• Corporate Controlled Category

• Measure

• Regular Measure Item

• Target Category For Data Import

• User Controlled Category