Data Model/Functions

The Data Model/Functions page allows user to

  • manage functions and function level

List functions

  1. In browser, log in to AgilePoint NX as a user with Data Model permission.

  2. Click Settings, then Data Setup then Data Model in the left menu.

  3. Select the Setting Level: either System or a specific tenant.

  4. Click Functions in the Middle Panel.

    ../_images/Data_Model_Functions_Location.png

    Fig. 44 Data Model - Functions

  5. Visible functions from all connections will be displayed.

  6. By default, only the first page with 10 items are displayed. To see more, either use the next page icon

    ../_images/Data_Model_Next_Page_Icon.png

    Fig. 45 Data Model - Next Page

    or select a larger number in Items per page box.

    ../_images/Data_Model_Items_per_page.png

    Fig. 46 Data Model - Items per page

Search for functions

The Search box at the top allows user to search for specific functions.

  1. ../_images/Data_Model_Functions_Search_by_Elements.png

    Fig. 47 Data Model - Search Functions by element

    Select a specific element to search for in the dropdown on the left of the Search box. Default is All.

  2. Type a partial name and click the search icon (🔍).

  3. Only the matching functions will be displayed.

Set function level

There are 2 types of function level:

  • Field Level means whether the function is allowed to be used in field level in Report Designer Module.

    ../_images/Data_Model_Functions_Field_Level_is_disabled.png

    Fig. 48 Data Model - Function Field Level is disabled

    When a function requires more than one input parameter, it cannot be used in field level and this option will be disabled.

  • Expression Level means whether the function is allowed to be used in calculated columns.

  1. Tick the respective checkbox to allow or untick to reject.

  2. Continue to set for other functions in the same page.

  3. Click Save button at the top, then click OK in the confirmation pop-up.