Understand the Cube.Textlists Worksheet

In application workbooks, the Cube.Textlists worksheet defines text lists. Text lists are used to work with text measures, which extend the analytical capabilities of Essbase Cloud.

In addition to numeric values, measures can be associated with text-typed values. Storage and analysis of textual content can be useful when a cell needs to have one of a finite list of textual values; for example, a product may be sold in 5 different colors. The color is a text measure whose value must be one of the 5 colors. The colors are a set of text strings mapped to corresponding numeric IDs. These mappings are contained in tables in the Cube.Textlists worksheet.

You can add multiple text list tables to the same sheet and they can be associated with multiple measures.

The following image shows the Cube.Textlists worksheet in a sample application workbook.


Image of the Cube.Textlists worksheet in an application workbook.

Table A-6 Cube.Textlists Worksheet Fields and Values

Property or Field Valid Values Description

List Name

Must not exceed 80 characters.

A text list must start with a list name followed by its value in the adjacent cell.

Associated Members

Existing member names.

Member names added in adjacent cells. Multiple members can be added in adjacent cells to the right.

ID

The first two values under ID are #Missing and #OutOfRange. These two values must exist in every text list table. The other IDs must be integers.

Each ID, including the #Missing, #OUTOFRANGE and numeric values, must map to a text value.

The first two IDs, #Missing and #OUTOFRANGE, are for handling cases where the textual data is invalid or empty. For example, if you try to load an unmapped value such as “Average” to a text measure, the cell value would not be updated, and would display as #Missing in a subsequent query. If you load a numeric cell value that is unmapped, the subsequent query would return N/A.

Text

Up to 80 characters.

The text column contains the text values for each text measure.

Each text value must map to an integer in the ID column. Any text value that does not map to an integer in the text list is considered by Essbase Cloud to be invalid.

In Designing and Maintaining Essbase Cubes, see: