Iterate Name Value Map Matrix - WorkView - Foundation 24.1 - Foundation 24.1 - Ready - OnBase - Premier - external - Premier

WorkView

Platform
OnBase
Product
WorkView
Release
Foundation 24.1
License
Premier

A name value map matrix is simple a collection of name value maps that are determined base on objects that have specific attribute values that are common across all of the objects. For example, perhaps you have iterated over a set of invoices and created a name value map based on status, accumulating amount and you have created one name value map for each quarter of the report year (4 name value maps in all, based on status). You can use the <<IterateNameValueMapMatrix>> tag to produce a single table with all of the results. Here is an example:

<<RP-2.0>>
<<CreateNameValueMap: FirstQuarter>>
<<CreateNameValueMap: SecondQuarter>>
<<CreateNameValueMap: ThirdQuarter>>
<<CreateNameValueMap: FourthQuarter>>

        
<<Filter: ProductSalesQ1>>
<<ConstrainToParent: No>>
<<AddToNameValueMap: FirstQuarter, ProductName, TotalSales>>
<<End>>

        
<<Filter: ProductSalesQ2>>
<<ConstrainToParent: No>>
<<AddToNameValueMap: SecondQuarter, ProductName, TotalSales>>
<<End>>

        
<<Filter: ProductSalesQ3>>
<<ConstrainToParent: No>>
<<AddToNameValueMap: ThirdQuarter, ProductName, TotalSales>>
<<End>>

        
<<Filter: ProductSalesQ4>>
<<ConstrainToParent: No>>
<<AddToNameValueMap: FourthQuarter, ProductName, TotalSales>>
<<End>>

        
<table>
<<IterateNameValueMapMatrix: FirstQuarter, SecondQuarter, ThirdQuarter, ForthQuarter >>
<tr>

        
<td style="width:75px;"><<@Name>></td>
<td style="text-align:right;width:120px;"><<@Value1, Currency>>
(<<@ColumnPercentage1, "0.">>)</td>
<td style="text-align:right;width:120px;"><<@Value2, Currency>>
(<<@ColumnPercentage2, "0.">>)</td>
<td style="text-align:right;width:120px;"><<@Value3, Currency>>
(<<@ColumnPercentage3, "0.">>)</td>
<td style="text-align:right;width:120px;"><<@Value4, Currency>>
(<<@ColumnPercentage4, "0.">>)</td>
<td style="text-align:right;width:120px;"><<@RowTotal, Currency>></td>
</tr>
<<Totals>>
<tr>
<td style="width:75px;"><<@Name>></td>
<td style="text-align:right;width:120px;"><<@Value1, Currency>></td>
<td style="text-align:right;width:120px;"><<@Value2, Currency>></td>
<td style="text-align:right;width:120px;"><<@Value3, Currency>></td>
<td style="text-align:right;width:120px;"><<@Value4, Currency>></td>
<td style="text-align:right;width:120px;"><<@RowTotal, Currency>></td>
</tr>
<<End>>
<<End>>
</table>

        
<<End>>