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.