The source tree for the package that you select can contain large amounts of data. To find the items that you need in the source tree, you can
expand a dimension to see successive levels and details
specify a greater or lesser number of items to show in the source tree
search for more items
The source tree shows 20 items for any one dimension at a time. You can change this value in the session to a maximum of 50.
If there are more than 20 items in the dimension, a More icon appears at the bottom of the list. Every time you click the More icon, an additional 20 items appears until you reach the maximum. Now the More icon is replaced by a Search icon. If you click this icon, you can enter your search criteria to find the items that interest you.
By default, the maximum number of items shown in any single dimension in the source tree is 50. Your administrator may set a different value for optimum performance, depending on the size of the data source. For more information, see the Cognos 8 Administration and Security Guide.
If a level has more than 50 items, you can search for the items that you need.
Note: You cannot search in the source tree for items that are enclosed in brackets, for example Drinks (Colas), when using Microsoft SQL Server Analysis Services 2000 or earlier versions.Do not include brackets in the search string when using these versions of Microsoft SQL Server Analysis Services 2000.
In the source tree, click the item that you want to search.
Click the search button on
the toolbar.
Tip: You can also right-click the selected icon, and then click Search.
Specify the search keywords.
If necessary, specify a search option. The Case insensitive check box is unavailable if the data provider does not support case insensitive searching.
Click Search.
Tip: To stop a search, click the Stop button.
Drag the items from the Results box to the crosstab.
Tip: To use the results as a context filter, drag them to the context section of the overview area.
You can specify the number of items to show in the source tree for the current session to make it easier to use. The number of items retrieved is shown next to the name of the parent item.
In the source tree, the Search icon appears at the end of the list if more items exist than can be shown at once.
By default, the maximum number of items shown in the source tree is 50. Your administrator may set a different value for optimum performance, depending on the size of the data source. For more information, see the Cognos 8 Administration and Security Guide.
Right-click an item in the source tree.
Click Set Number of Items to Show.
Specify the number to show and the scope options.
Click OK.
Tip: To restore the maximum number of items to the default, repeat steps 1 to 2 and click Reset to default limit to show.