Searching for elements

You can search for elements in Structure Selection and in the Preview pane. You can search within element captions, element unique names or attributes. To search within an attribute, the attribute must be selected in the Attributes pane of the List Designer.

See Attributes..

The search function is the similar in the Structure Selection and Preview panes but the format is different.

To search in Structure Selection, click Find Element. The Find Element dialog is displayed. The dialog has three options which are not available in the Preview pane: Select All, Deselect All and Suppress Empty Elements.

See Structure Selection.

To search in the Preview pane, click Search. A search field is displayed.

To search for an element in either pane:

  1. Click Find Element or Search as appropriate.
  2. In the search field, specify the text to search for.
    You can specify a partial text. The wildcard character * can be used but is not required. For example, in the Product dimension of the Best Practices Templates database, searches for Comm and Comm* both return Commercial (van tires).
  3. Select Element Caption, Element Unique Name or an attribute in which to search.
  4. Click Find All.
    The found elements are added to the list definition. They are displayed in the bottom half of the Structure Selection pane. The results of any subsequent searches are also added to the list definition. To remove elements from the list definition, select them and click Delete. Three further search options are enabled: Find in Previous Result, Find Next and Find Previous.
    Note: 

    To use Find Elements with Analysis Services data sources, you must install an assembly on the Analysis Services server.

    The assembly file is called Mis.Reporting.ServerExtension.dll and is installed to C:\Program Files\Infor BI\OLAP\bin by the Office Plus setup.

    Use SQL Management Studio to connect to the Analysis Services database and add an assembly to the Assemblies folder.

    The assembly must have these parameters:

    • Path: ..\OLAP\bin\Mis.Reporting.ServerExtension.dll.
    • Name: MisOlapYukonExtension
    • Permissions: Safe
    • Impersonation: Default
Parent topic: Lists