|
You can now specify a matrix layout for a vector of vectors. When
adding a child node to the UDM, check " Yes" against the option
" Node is a Vector node". Select Database as the dataport and save
it. Add another vector node similarly. Click on the Regenerate HTML
button. The generate HTML page opens up. Select the check box "Vector
Node Pair". The page further asks you for values to be entered for
the following:
- Row labeling node
- Column labeling node
- Cell value node
The values for the above can be provided from the respective dropdown
lists. You can thus specify a matrix layout for such a node pair.
Click on the Generate Button. If you save the HTML and view it in
the browser the table retrieved will have the following features
:
The Row will contain the values specified at the Row labeling node.
The Column will contain the values specified in the column labeling
node. Each cell will fetch the values specified under the Cell value
Node.
When you perform database tasks, such as sorting, subtotaling or
filtering data, the Matrix automatically recognizes the list as
a database and uses the following list elements to organize the
data.
- The columns in the list are the fields in the database
- The column labels in the list are the field names in the database
- Each row in the list is a record in the database
It functions like a pivot table. The matrix provide you an interactive
worksheet table that quickly summarizes large amounts of data using
calculation methods you choose. You can rotate its row and column
headings around the core data area to give you different views of
the source data. As the source data changes, you can update a table.
If you change data in the source list or table, by adding new rows
(records) or columns (fields), there are ways to update the table.
However, the safest way is to delete the sheet which contains your
table and start over by creating a new table, which usually takes
only a few seconds.
The matrix allows you to have:
- A friendly report making format
- A summary of data
|