Preface
Using the Designer
Working with Sources
Working with Flat Files
Working with Targets
Mappings
Mapplets
Mapping Parameters and Variables
Working with User-Defined Functions
Using the Debugger
Viewing Data Lineage
Comparing Objects
Managing Business Components
- Managing Business Components Overview
  - Business Component Locking
  - Creating Links to Business Component Documentation
- Managing Business Components and Directories
Creating Cubes and Dimensions
Using the Mapping Wizards
Appendix A: Datatype Reference
Appendix B: Configure the Web Browser
- Configure the Web Browser

Designer Guide

10.5
- 10.4.1
- 10.4.0

Back Next

Defining Ranges

The Designer creates source definitions based on ranges you define in Microsoft Excel. You can define one or more ranges in a Microsoft Excel sheet. If you have multiple sheets, define at least one range for each sheet. When you import sources in the Designer, each range displays as a relational source.

You must define a range in the Designer to import the Excel source definition.

To define a range:

Open the Microsoft Excel file.

Highlight the column or group of columns of data to import.

Click Insert > Name > Define.

Enter a name for the selected range and click OK.

If you have multiple sheets, select each sheet and repeat steps 2 to 4 to define ranges for each set of data.

Rename Saved Search

Table of Contents

Designer Guide

Designer Guide

Defining Ranges

Defining Ranges