Finding Data

If the data in the selected column is a text string, the Find tool opens the Find String in <column_name> dialog box.

1. In the Find box, enter a string of text that you want to search for.

2. In the Action on Find box:

   • Focus is selected by default. When the Find command runs, rows that contain the string that you are searching for are visible, and all other rows are hidden.

     TIP: When Focus is selected, the label in the first row is Subtotals to indicate that a subset of the data is displayed.

     

   • Optionally, select Group or Group with Others.

     NOTE: If the display is a MultiTab created from a classic model, Group options are not available.

     If Group is selected, when the Find command runs, rows that contain the string that you are searching for are visible. The label in the first row is Group and this row can be dived on.

     

     If Group with Others is selected, when the Find command runs, rows that contain the string that you are searching for are visible and grouped together. The remaining rows are grouped together and summarized. This second group appears on the bottom of the display in a row labeled Others. The label in the first row is Group. The Group and Others rows can be dived on.

     

3. If the Find by box is not visible, click Options.

4. In the Find by box:

   • Select Expression to use the search criteria entered in the Find box.
   • Select Non-Empty to hide rows that contain an empty cell in the selected column.
   • Select First and enter a number (n) to view only the first n rows in the dive window.
   • Select Last and enter a number (n) to view only the last n rows in the dive window.

   NOTE: First n Items and Last n Items do not use any search criteria other than row position. These options are typically used after the column has been sorted.

5. If you selected Expression to search for the text string specified in the Find box, you can specify if you want to Match case, Match exactly, or Match beginning of the string entered.
6. Optionally, select Find others to find items that do not meet the specified criteria. Items that match the criteria indicated in the Find by box are hidden, and rows that do not meet the criteria are displayed.
7. Click Find All.

If the data in the selected column is numeric, the Find tool opens the Find Numbers in <column_name> dialog box.

1. In the Find box, enter a starting point and ending point of the number range that you want to search for.

   • To the left of the number range numbers, select an arithmetic operator (>=, >, =, <, <=).
   • To the left of the ending arithmetic operator, select a logical operator (None, And, Or).

2. In the Action on Find box:

   • Focus is selected by default. When the Find command runs, columns that contain the number range that you are searching for are selected, and all other rows are hidden.

     TIP: When Focus is selected, the label in the first row is Subtotals to indicate that a subset of the data is displayed.

     

   • Optionally, select Group or Group with Others.

     If Group is selected, when the Find command runs, rows that contain the string that you are searching for are visible. The label in the first row is Group and this row can be dived on.

     

     If Group with Others is selected, when the Find command runs, rows that contain the string that you are searching for are visible and grouped together. The remaining rows are grouped together and summarized. This second group appears on the bottom of the display in a row labeled Others. The label in the first row is Group. The Group and Others rows can be dived on.

     

3. If the Find by box is not visible, click Options.

4. In the Find by box:

   • Select Expression to use the search criteria entered in the Find box.
   • Select Non-Empty to hide rows that contain an empty cell in the selected column.
   • Select First n Items, and enter a number (n) to view only the first n rows in the dive window.
   • Select Last n Items, and enter a number (n) to view only the last n rows in the dive window.
   • Select First n %, and enter a number (n) to view rows accounting for n% of the column total starting with the first row.
   • Select Last n %, and enter a number (n) to view rows accounting for n% of the column total starting with the last row.

   NOTE: First n and Last n Items or % options do not use any search criteria other than row position. These options are typically used after the column has been sorted.

5. Optionally, select Find others to find items that do not meet the specified criteria. Items that match the criteria indicated in the Find by box are hidden, and rows that do not meet the criteria are displayed.
6. Click Find All.

If the data in the selected column is dates, the Find tool opens the Find Date Range in <column_name> dialog box.

• You can search for a specific date or a range of dates.
• You can base your search on an offset of today's date.
• The Today check box uses the date on the client computer.

1. In the Find box, enter a single date or the range of dates that you want to search for.

   Alternatively, select Today and enter an Offset value (for example, -1 to specify yesterday and today).

   • To the left of the date range entries, select an arithmetic operator (>=, >, =, <, <=).
   • If you are searching a date range, to the left of the ending arithmetic operator, select a logical operator (None, And, Or).

2. In the Action on Find box:

   • Focus is selected by default. When the Find command runs, columns that contain the date or date range that you are searching for are selected, and all other rows are hidden.

   • Optionally, select Group or Group with Others.

3. If the Find by box is not visible, click Options.

4. In the Find by box:

   • Select Expression to use the search criteria entered in the Find section.
   • Select Non-Empty to hide rows that contain an empty cell in the selected column.
   • Select First and enter a number (n) to view only the first n rows in the dive window.
   • Select Last and enter a number (n) to view only the first n rows in the dive window.

   NOTE: First n Items and Last n Items do not use any search criteria other than row position. These options are typically used after the column has been sorted.

5. Optionally, select Find others to find items that do not meet the specified criteria. Items that match the criteria indicated in the Find by box are hidden, and rows that do not meet the criteria are displayed.
6. Click Find All.

If the data in the selected column is a time period (such as Month or Quarter), the Find tool opens the Find Period Range in <column_name> dialog box.

1. In the Find box, select a period of time or range of time periods that you want to search for.

2. In the Action on Find box:

   • Focus is selected by default. When the Find command runs, columns that contain the time period or time period range that you are searching for are selected, and all other rows are hidden.

   • Optionally, select Group or Group with Others.

3. If the Find by box is not visible, click Options.

4. In the Find by box:

   • Select Expression to use the search criteria entered in the Find box.
   • Select Non-Empty to hide rows that contain an empty cell in the selected column.
   • Select First and enter a number (n) to view only the first n rows in the dive window.
   • Select Last and enter a number (n) to view only the first n rows in the dive window.

   NOTE: First n Items and Last n Items do not use any search criteria other than row position. These options are typically used after the column has been sorted.

5. Optionally, select Find others to find items that do not meet the specified criteria. Items that match the criteria indicated in the Find by box are hidden, and rows that do not meet the criteria are displayed.
6. Click Find All.

You can search and find dimension values before performing a dive. This is an efficient way to reduce the amount of data that passes over the network, especially when working with very large dimensions.

NOTE: The Find dialog box that opens is similar to the dialog box that opens when you use the Find command to search a dive window column. However, you might notice some minor differences. For example, Focus is not optional.

To use Find Before Dive:

1. On the Console, right-click the dimension that you want to search, and select Find Before Dive.

   A Find dialog box opens (which one depends on the dimension values data type).

2. Enter the search criteria.
3. Click Find All.

The Advanced Find option allows you to perform complex searches on an active dive window using combinations of search criteria on multiple columns. You can access the Advanced Find dialog box from any of the Find dialog boxes by clicking Advanced Find.

The Advanced Find dialog box has a Find box that contains the advanced find criteria. It is automatically populated with the search criteria defined in the Find dialog box from which it was opened. You can manually enter criteria in the Find box, or define the criteria by clicking column names and functions.

TIP: If you use the Functions buttons, ProDiver assists you with syntax.

A pull-down list shows a history of recent searches.

A Columns box lists the column headers on the active dive window. You can select columns that you want to include in the search criteria.

The following advanced Functions are available:

• Brackets [ ]: Use to identify a column or dimension.
• Paste String: Use to paste values from the clipboard or from another application such as Microsoft Excel into the Find box with the proper syntax (Or logical operators are automatically inserted between values).
• QVVal: Use to specify a QuickView value.
• Syntax: ColumnName ArithmeticOperator QVVal(QV_Name) — Example: Units > QVVal(Threshold)
• In this example, ProDiver finds the Units values that are greater than the current value in the Threshold QuickView. For example, if the current value in the Threshold QuickView is 1000, ProDiver displays all values in the Units column that are greater than 1000 and omits the Units that do not meet this criteria.

The following Functions operate as described in the basic Find dialog boxes:

• Arithmetic operators: =, <, >, <=, >=
• Syntax: ColumnName operator n — Example: Quantity>=300
• Logical operators: And, Or, Not
• Alphabetic operators: Contains, Begins with
• Syntax: ColumnName operator "value" — Example: CustomerContact contains "Ann"
• Other operators: NotEmpty, First N Items, Last N Items, First N %, Last N %, Today, Date, Period

• Syntax examples:

  • Syntax: NotEmpty(ColumnName) — Example: NotEmpty(UnitsInStock)
  • Syntax: Today(offset) — Example: Today(0)
  • Syntax: ColumnName=Date (date) — Example: ShipDate=Date(2016/05/04)
  • Date range example: OrderDate>=Date(2015/12/02) And OrderDate<Date(2016/05/02)