Matrix Designer Interface
Opening a Matrix gives you access to the Matrix Designer. This workspace has several tabs which change depending on the type of Matrix and the starting point selected. The table shows which tabs each Matrix uses.
The general tab contains a summary of the Matrix information alongside a list of steps required to create a usable Matrix. Clicking on the links sends you to the correct place to complete each task.
Edit Row Query
This option takes you to the Row Query tab, where you can construct and test a Query
This link lets you reset the row data source to a query chosen from a selection of basic queries listed in a Select Query dialogue box.
This option lets you select a dependency from a Select Content dialogue box. Your selection will appear next to the highlighted "Use a Dependency" button.
The matrix tab has four subheadings; Matrix, Rows, Columns, and Cells. Each of these sections allow you to alter the general properties for that area.
The Designer tab allows you to add dimensions and levels to an Aggregation Matrix. For more information on this tab and Aggregation Matrices see Aggregation Matrices - Aggregation Matrix.
The various Query tabs all use the standard Query Builder to create the Queries. For more information on Queries and the Query Builder see Queries and Query Reference Guide.
Row Query Tab
The Row Query tab is used to define a query that finds the rows for your Matrix.
Source Query Tab
The general functionality is the same as the Row Query tab except the Elements generated by the Source Query may not be the Elements in the row headers. For further information on the Source Query tab see Aggregation Matrices - Source Queries.
Column Query Tab
The Column Query tab is used to define a query that finds the columns for your Matrix.
Cell Query Tab
The Cell Query tab is used to define a Query that finds Elements to populate the cells of a Matrix. Additional Queries are used to group the cells.
The Cell-Row Query tab is used to define a Query that finds the rows for your Matrix. The Query Builder uses a fixed starting block to ensure the Query starts from a cell Element.
Cell-Column Query Tab
The Cell-Column Query tab is used to define a Query that finds the columns for your Matrix. The Query Builder uses a fixed starting block to ensure the Query starts from a cell Element.
Edit Columns Tab
This tab lets you select content that will appear as columns in your Matrix. The content can include Smart Columns, Pick Lists, memo fields, etc.
If your Matrix is uses any variables in its Queries or columns, you can enter default variables in this tab.
Please sign in to leave a comment.