Example - Specifying a Named Range for a Spreadsheet Database
You have a simple spreadsheet database that
has a single named range.
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | EMP_NO | NAME | DEPT | SALARY |
| 2 | 0256 | Wilson | TECHW | 50,000 |
| 3 | 0141 | Barnes | DESIGN | 60,000 |
| 4 | 0724 | Paul | DESIGN | 70,000 |
| 5 | 1290 | Power | DESIGN | 80,000 |
The named range for cells A1 .. D5 is DataTable.
Cognos® Transformer reads rows 1 to 5 in the range DataTable. The Data Sources list shows the Human Resources columns EMP_NO, NAME, DEPT, and SALARY.