Creating a Query Group - Teradata Viewpoint

Teradata Viewpoint User Guide

Product
Teradata Viewpoint
Release Number
16.00
Published
October 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
fey1467302953244.ditamap
dita:ditavalPath
2206_User_vp_1600_NEW.ditaval.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
Create a query group in the Query Group Setup portlet to allow users to view their most relevant queries in the Query Groups. You create a query group to filter the queries that are displayed and limit the users that have access to the group.

Enabling the Dictionary data collector in the Monitored Systems portlet ensures that the lists of usernames in the Access tab is current.

  1. Select a system from the Systems list. A system cannot be changed after you create a query group.
  2. Click the Add Group button.
  3. Enter a Query group name, up to 30 characters.
  4. [Optional] Enter a Description, up to 256 characters.
  5. For the This group contains queries with attributes that match at least one value in field on the Criteria tab, do one of the following:
    • Select Every criteria below to match at least one value in each defined sub-tab. Criteria on each sub-tab are joined by AND.
    • Select Any criteria below to match at least one value in one or more of the defined sub-tabs. Criteria on each sub-tab are joined by OR.


  6. Select a criterion from the Add Criteria list.
  7. Select values for whichever criteria you chose:
    Criteria Select values by doing any of the following:

    Account String

    Username

    Workload Name

    • In the Match string box, enter a value to reduce the number of available values.
    • Select a value from the Available box and click to move it to the Selected box.
    • In the Match string box, enter a value to create custom criteria, and click to move it to the Selected box. The value can contain ? to match exactly one character in the position it occupies, * to match zero or more characters, or = at the beginning of the string to match alpha and numeric characters literally.
    Query Band
    • Select a Query band name from the list and a value from the Available Values box, and click to move them to the Selected box.
    • Enter a Custom Query band name and value pair, and then click to move them to the Selected box.
  8. In the Access tab, designate the users who can view the group by doing any of the following:
    • In the User List Filter box, enter a value to reduce the list of available users. The value can contain ? to match exactly one character in the position it occupies, * to match zero or more characters, or = at the beginning of the string to match alpha and numeric characters literally.
    • In the Available Users box, select one or more Viewpoint users and click to move them to the Selected Users box.
    • In the Available Roles box, select one or more Viewpoint roles and click to move them to the Selected Roles box.
  9. [Optional] Click Reset to clear the query group name, description, and the selections on the Criteria and Access tabs.
  10. Click Apply.