Searching for Columns in Datasets

Datasets can contain a very large number of columns. If you a looking for one or more particular columns in a dataset on the Cube Designer canvas, however, you can find them quickly by using one or more search criteria in the search field at the top of the dataset. Columns not matching the criteria are filtered out, so that the dataset lists only those that match.

To start a search, start typing in the Filter columns field at the top of the dataset.

You can search by specifying all or part of a column name, how the columns are used, and the data type of the columns. If you refresh your browser window while search results are displayed, the results and the search criteria that you used continue to appear after the refresh.

Searching by column use

Type the keyword used: followed by one of these uses:

Calculated column

used:calculated_column

Calculated measure

used:calculated_measure

Degenerate dimension

used:degenerate_dimension

Level

used:level

Measure

used:measure

Relationship

used:relationship

Secondary attribute

used:secondary-attribute

Any of the criteria listed above

used:any

None of the criteria listed above

used:none

Searching by column data type

Type the keyword type: followed by one of these types:

bigint

type:bigint

datetime

type:datetime

int

type:int

long

type:long

string

type:string

Searching by column name

Type one or more letters that are in the column name, whether those letters appear at the beginning, in the middle, or at the end of the name. The search tool assumes that any letters not preceded by used: or type: are part of the name of the column that you are searching for.

Searching by two or more citeria

To narrow your search, you can chain criteria together by using commas, as in this example:

type:datetime, used:level, date

The last criterion "date" searches for all columns with "date" in their names.