Introduction to Modeler

Modeler is where you view, edit, and configure models.

The following illustration of the Modeler list screen gives an overview of some of the main functional areas:

Explore Models – List screen and toolbar
  1. Models – Existing models are listed here. You can open a model by clicking the link text or by selecting one or more models using the checkboxes.
  2. Public Dimensions – The individual public dimensions that are used in models are saved independently and listed on a separate tab page.
  3. Currency Conversion – If you are using multiple currencies in your data, exchange rates are maintained in separate tables. These are saved independently of any model and are listed on a separate tab page.
  4. Points of Interest – Data for geographic locations which are displayed and used in your data analysis is maintained here in Modeler.
  5. Toolbar – Common operations for managing models are available from the toolbar, this includes options to Delete a model and to Clear (remove all data) from a model.
  6. Import / export data – The list of data import options that are supported is available from a menu beneath the Data import icon on the toolbar.
  7. Data Resources – You can set up permanent scheduled links to the model from external data sources so that data can be refreshed on a scheduled basis.
Model types
Model
Model based on a live data connection
Sample model
Modeler grid

When you select a model, the model contents are shown in the Modeler grid:

The data objects shown in the grid are:

  • Dimensions: Time, Account, and so on.
  • Dimension attributes: ID, Description, and so on.
  • Technical Properties (available only for account dimensions): Units & Currencies, Aggregation Type, and so on.
  • Dimension members: Discount, Gross_Margin, and so on.
Datasources

From the Datasources tab of the Modeler page, you can refresh, delete, and schedule data refreshes for specific datasources. You can also import data into a model or start a refresh job from the modeler page.

Using the grid

These are some of the helpful features available in the Modeler grid:

  • Keyboard navigation: You can use these keys while working in the grid:

    Keys Action
    Space Opens a cell for editing (same as double-clicking a cell)
    Enter Move down 1 cell
    Shift + Enter Move up 1 cell
    Tab Move right 1 cell
    Shift + Tab Move left 1 cell
    Page Down Move down 1 page
    Page Up Move up 1 page
    Alt + Page Down Move right 1 page
    Alt + Page Up Move left 1 page
    Ctrl + Shift + Space Select all
  • Context-sensitive copy: If you have cells containing the values Cell1 and Cell2, when you select both cells and copy to the cells below, the cells will be populated with the values Cell3, Cell4, and so on.

  • Account labels: For account dimensions, you can type custom labels for the Units & Currencies column:

  • Error highlighting: when cells contain errors, hover over the column header for information about the error:

  • Formula bar: when entering formulas in the Formula bar, press Ctrl + Space to see the available formulas, and then highlight a formula in the list to see a detailed description of the formula: