| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
After a Simplified model is first created, it contains no tables.
...
Created table is opened (with no content) and indicated in the list of tables in the left hand side navigation pane.
...
...
Setting up data type definition on Rows/Columns
In the first step user shall decide if the information on the requested data type shall be indicated On rows or On columns of the created table (i.e. if the entire row or column will require values of a selected data type: Monetary, Text, Date, etc.
...
Please note that this setting of the placement of data type constraints can be also changed laterat any point of time.
Fixed and Dynamic structure of headers
...
and start typing:
...
Codes of Headers on Fixed axes Rows and Columns are set up automatically upon creation of a header, starting with R0100 for Rows, C0100 for Columns and S0100 for Sheets and increasing by 10.
...
There are two options for recalculation:
...
Both will start by setting the most left Column to C0100 and top Row to R0100 and increase by 10 moving from header to header (to the right for Columns, and down for Rows). Depth first method will increase the code increases codes first for child nodes and then for siblings while Breadth first will start starts will sibling headers first.
...
Adding and rearranging structure of
...
Fixed Rows/Columns
To add a Column header next to the exiting one, use the + button on the right:
...
To add a parent Column header, use the click on the Code of a header and select + button in the context menu:
...
To add a Row header below the exiting one, use the + button on the bottom:
...
Note that in the following situation the sibling (i.e. Row header on the same level) of R0120 Current will be created:
...
While while in this the below case sibling (i.e. Row header on the same level) a sibling of R0100 Assets will be created:
...
To add a child Row header use the + button on the right:
...
To add a parent Row header, click on the Code of a header and select the indentation icon in the context menu:
...
Note that rows indentation can be used to nest a Row header under its upper sibling or to move it up to the level of its parent:
...
Headers of Rows and Columns can be rearranged with drag and drop.
...
Similarly for Columns, it is possible to drag a drop a header next to another one (as a sibling on the left or right hand side or as a child).
...
Grouping headers
Fixed Columns or Rows can be marked as grouping by clicking on their code and deselecting them as Reportable:
...
Not reportable cells
Cells can be grayed-out/cross-crossed by clicking on their content and deselecting Reportable:
...
Dynamic structure Rows or Columns
Typical open table has unlimited number of rows.
...
To add more Dynamic structure Rows (or Columns) click on the + icon.
...
Labels of a Dynamic structure Row and Column can be change by placing the cursor on its title and editing the text:
...
Note that a table can have Dynamic structure on Rows or Columns but not on both (in case it is on Rows, Columns can only be Fixed):
...
Keys to each row are constrained by data type where user can select from the list of predefined basic types:
...
or select one of the existing/create a new drop-down list with available options:
Creating and editing lists
Content of Rows/Columns in table can be constrained to a set of enumerated items, which in reporting tools is typically visualized as a drop-down.
These lists can be set up for Dynamic structures
...
of Fixed Rows or Columns:
...
Creating of a new list requires providing its name and enumerating its items (to save an entry press Enter):
...
and when completed, clicking on Create:
...