Querying symbols

You can use the Longview Add-In for Office to query symbol data such as the balance type, weight, and priority of a specified symbol or symbols from the data server repository.

In this chapter, you can find information on symbol query tasks, including the following:

• “Understanding symbol query output”
• “Querying symbol information”
• “Rerunning a symbol query”
• “Saving and loading symbol query selections”

Understanding symbol query output

A symbol is a plane of data within the database. Symbols identify specific cells within a hierarchy and are used to store information in the Longview database. When you run a symbol query, the results of the query are output to a Microsoft Excel workbook. The symbol query results appear in the following layout:

The following colors and character formats are applied to symbols in the Hierarchy column in the symbol query results:

Symbol queries display the following columns in the query results:

Querying symbol information

You can query a list of symbols into a Microsoft Excel worksheet that shows the details for each of those symbols.

Longview recommends that you place one query per worksheet in Microsoft Excel. However, if you have to run multiple queries and place them in a single Microsoft Excel worksheet, ensure that the query results do not overlap.

To query symbols:

1. Click the Longview tab.
2. In the Insert group, click Symbol Query. The Symbol Query dialog opens.
3. Complete the following fields:

   Field	Description
   Dimension	Select the dimension containing the symbol or symbols that you want to query.
   Hierarchy	Select the symbol data to display in the query results, using one of the following options: Name and Description—To display the symbol name and description. Name—To display the symbol name only. Description—To display the symbol description only. The default value for this field is Name and Description.
   Include Alternate Description	Select this field to include the alternate language description of the symbol in the symbol query results.
   Cell Location	Type the location of the top left cell of the query results. Keep in mind that the query results overwrite any data in the worksheet cells.

4. To select the symbol data to appear in your Microsoft Excel worksheet, complete these fields:

   Field	Description
   Symbols	Type the name of a symbol that you want to query or click the symbol selector button to search the hierarchy for the selected dimension. For information, see “Using the Symbol Selector”.
   Spec	Select the type of symbol to query, using one of the following options: All—To query all symbol types. Leaf—To query only leaf symbols. Parent—To query only parent symbols. Root and Parent—To query only root and parent symbols. The default value for this field is All.
   From Level	Type a number that specifies the start of the list of symbols to appear in the query results. The number refers to a number of levels of descendants below the symbol selected for Symbols in the hierarchy. For example, if you type 0, the list of symbols in the query results starts from the selected symbol. If you type 1, the list of symbols in the query results starts one level below the selected symbol.
   To Level	Type a number that specifies the end of the list of symbols to appear in the query results. The number refers to a number of levels of descendants below the symbol selected for Symbols in the hierarchy. For example, if you type 3, the list of symbols in the query results ends three levels below the selected symbol. Note: The number specified for To Level must be equal to or higher than the number specified for From Level. If you specify 99 levels for To Level, all levels below the level specified for From Level are included in the results.

5. To add all root symbols for the specified dimension to the symbol query, click Add Roots.

   Note: Root symbols are added to the symbol query in alphabetical order.

6. If you want to query data for additional symbols, complete the following steps:
   1. Click Symbol. A new row appears.
   2. For the new symbol, complete the following fields:

      Field	Description
      Symbols	Type the name of a symbol that you want to query or click the symbol selector button to search the hierarchy for the selected dimension. For information, see “Using the Symbol Selector”.
      Spec	Select the type of symbol to query, using one of the following options: All—To query all symbol types. Leaf—To query only leaf symbols. Parent—To query only parent symbols. Root and Parent—To query only root and parent symbols. The default value for this field is All
      From Level	Type a number that specifies the start of the list of symbols to appear in the query results. The number refers to a number of levels of descendants below the symbol selected for Symbols in the hierarchy. For example, if you type 0, the list of symbols in the query results starts from the selected symbol. If you type 1, the list of symbols in the query results starts one level below the selected symbol.
      To   Level	Type a number that specifies the end of the list of symbols to appear in the query results. The number refers to the number of levels of descendants below the symbol selected for Symbols in the hierarchy. For example, if you type 3, the list of symbols in the query results ends three levels below the selected symbol. Note: The number specified for To Level must be equal to or higher than the number specified for From Level. If you specify 99 levels for To Level, all levels below the level specified for From Level are included in the results.

   3. Repeat step a and step b for each additional symbol that you want to include in your symbol query.

      Note: To delete additional symbols that you have added, select the row containing the symbol, and click Delete. You can also change the order in which the symbols appear in the query results by selecting the row containing the symbol and clicking Move Up or Move Down.

7. Click Run Query. The results of the symbol query appear in the worksheet.
8. Click the File tab.
9. Click Save.
10. If you are saving the workbook for the first time, the Save As dialog opens. Enter a name for the workbook and click Save.

Rerunning a symbol query

You can use the Longview Add-In for Office to rerun an existing symbol query. Rerunning a symbol query refreshes data values in the query and also allows you to modify the query as necessary.

When you open a workbook containing symbol queries, the associated values are not updated to show the latest values in the Longview data server repository. The data will be exactly the same as when you last saved and closed the workbook. To see the most up-to-date data from the data server repository, you must rerun your symbol queries.

To rerun a symbol query:

1. Right-click any cell in the results of the symbol query that you want to rerun and select Rerun Query. The Symbol Query dialog opens.
2. Make any changes to the symbol query as necessary.
3. Click Run Query. The results of the symbol query appear in Microsoft Excel, with refreshed data values and any specified changes.

   Note: Any formatting (font, borders, or alignment for example) in the worksheet is retained when you rerun a symbol query. This includes any colors and character formats automatically applied to existing symbol query results.

Saving and loading symbol query selections

You may save the query selections that you have selected in the Symbol Query dialog. This will enable you to quickly pre-populate the Symbol Query dialog in the existing session or within a future session.

The query selections are saved to a file. You can name and save the file in a local or network drive. This enables you to give the query a meaningful name and the ability to share your query with others.

Saving symbol query selections

To save your query selections, you must first specify the selections you wish to save in the Symbol Query dialog. For more information, see “Querying symbol information”.

To save symbol query selections:

1. Complete the fields in the Symbol Query dialog.
2. Click Save Query.
3. The Save As dialog opens.
4. Enter a name for the query and click Save.

Loading symbol query selections

You may quickly pre-populate the Symbol Query dialog with selections from a saved query.

To load data query selections:

1. Click the Longview tab.
2. In the Insert group, click Symbol Query. The Symbol Query dialog opens.

   Note: You must be connected to the data server to run a symbol query.

3. Click Load Query.
4. The Open dialog appears.
5. Select the query file that you wish to load and click Open.
6. The fields of the Symbol Query dialog are populated with the query selections from the selected file.

You may modify these selections before running the query.