What Rows Are
Rows represent hierarchical lines in the sheet. Each row may be:
Linked to a variable
Linked to a dimension member
Generated from a full dimension table
Plain text (no link to model structure)
Rows define how data is organized and displayed.
Creating a Row
Use the "+ Row" button to choose:
Variable: Adds one variable as a row
Dimension Member: Adds a single member as a row
Dimension Table: Creates a row for every member
Plain Text Row: Type a name directly
Generated Rows
If you select a dimension table, Farseer:
Generates one row per member
Highlights generated rows in blue
Applies the same configuration to all generated rows
Drag & Drop Creation
Opening the "Database Objects & Properties" sidebar
Under Database Objects & Properties, drag:
Variables
Dimension members
Dimension tables
…directly into your sheet.
Templates
Templates in Farseer let you add new members directly into connected dimension tables using the sheet as the input interface.
By using the “Edit template” option from the toolbar you can easily create multiple members at once, set names and descriptions, set member connections, and even add the template to your toolbar for quick access. This simplifies and speeds up new member entry across your model.
The "Edit template" button
When creating a new template, you can configure the following options:
Allow creating multiple items at once: Create several members in one action. Members created together will share the same name prefix, with numbers added automatically (e.g., Brand 1, Brand 2, Brand 3).
Set name, description, and connections on create: Define the member’s name, description, and connections. If connections already exist through sheet filters, they’ll be prefilled in the new member window.
Set properties on create: Fill in the defined properties of the selected dimension table during creation.
Add to toolbar: Add the template to your toolbar for quick, repeated use.
Templates can be edited, duplicated, removed from toolbar, or deleted.
📹 Feature Spotlight: Templates
Want a visual walkthrough?
See how Templates let you create new dimension members directly from a sheet — with predefined properties, connections, and customizable toolbar buttons for fast, structured data entry.