.When building expressions in the expression editor, you can browse the data of a data item. This is useful when you do not know how a particular value is stored in the database. For example, you want to filter a report so that it shows data for only China. The actual value in the database for China is The People's Republic of China, and this is what you must insert in the filter expression to obtain the correct results.
You can also browse the data of a data item when creating
conditional styles .
In the source, data items, or query tab, right-click the data item you want to browse.
If you want to insert a single value, click Select Value.
If you want to insert multiple values, click Select
Multiple Values 
.
In the Values box, click the value you want to insert in the expression.
Tip: Use the Words box to search for specific values. If the data source is case sensitive and you want to perform a case insensitive search, click the Search arrow and then click Case Insensitive.
If you clicked multiple values, click the right arrow button 
to
add them to the Selected values box.
Click Insert.
Tip: To control where values appear in the Expression
Definition box, you can click the copy button if you
selected a single value 
or the copy
all button if you selected multiple values instead. The values are
copied to the clipboard, and you can then paste them where you want.
In the expression editor, when searching for values for a data item, the results you obtain may contain unexpected results if the data item is not a string data type. Because users can edit the expression for a data item, IBM Cognos 8 cannot determine with certainty what the data type is.
Therefore, IBM Cognos 8 guesses the data type of the data item by looking at its aggregate and rollup aggregate set.
