Using database-level search in a modeling workbench

Use the search feature in the modeling workbench to search for data items in a database, and search the database processes and rules code.

Search names

Use the search feature in the modeling workbench to search for different data items (cubes, dimensions, views, sets, processes, chores, rules, and control objects) in a database.

  1. Click the Search button in the workbench.
  2. In the panel that opens, select the database in which you want to search.
    Search dialog box
  3. Enter the name of the data item you are searching for in the Search field.

    To search for a control object, prefix the name with }. For example, }Attributes. The search looks for items that contain the string that follows }. A search for }att displays the results }CubeAttributes and }DimensionAttributes.

    Search dialog box
    Tip: Click the Filter icon to narrow down the search results to specific data items. For example, if might want to see search results only for dimensions.

    To search for the same data item in a different database or with different filter options, simply change your selections, which triggers a new search.

  4. Click any search result to open the item in the content panel.

    You can also click the context menu icon Edit menu next to the data item to edit it or delete it from the database.

    You can make the following changes to each data item from within the search panel:
    • Cubes
      • Add new view
      • Import data
      • Delete cube
      • Edit cell security (not available for control cubes)
    • Rules
      • Edit business rules
      • Delete business rules
    • Dimensions
      • Edit dimension
      • Create set
      • Delete dimensions
      • Create hierarchy (not available for control dimensions)
    • Sets
      • Edit set
      • Delete set
    • Views
      • Add view
      • Delete
    • Processes
      • Edit process
      • Run process
      • Delete process
      • Display chores involved
    • Chores
      • Edit chore
      • Run chore
      • Delete chore
      • Enable chore schedule

Search code

Use the Search code tab to search the process or rule code in the TM1 database.

Note: The control processes code is not searched in this release.
  1. In a workbench, click the Search button in the vertical toolbar, and then click the Search code tab.
  2. In the panel that opens, select the database in which you want to search.
    Search code dialog box
  3. In the Search field, enter the keywords that you are searching for, and press Enter.
    Search code dialog box
    Tip: Click the Filter icon to narrow down the search results to either processes or rules.

    The search results include the processes and rules that contain the specified keywords.

  4. Click any of the results.

    The rule or process editor is opened with the first instance of the keyword highlighted in the code. Use the buttons in the bottom panel of the editor to locate other instances of the keyword in the code.

    Search code tab in a workbench