Post date: 24-Apr-2014 03:26:23
Workbook Script using Procedure BuildRangeFromScript – Cartesian List
Method: BuildRangeFromScript (Build a range on a worksheet from the results of a script.)
Overload: CartesianList (Build a range on the sheet based on the cartesian product of values from two or more delimited string lists.)
Expected Result:
Expand two “row dimensions” to its children. (Product and Product POV)
NOTE: There are two selectors In the view, Market and Product (multi-select enabled)
Workbook Script:
Workbook Script below is an example from sample application.
The ScriptText argument value, @REPLTOKENS([T.Market]|[T.Product]), represents the token values delimited in this case by a pipe character (as defined by the ListDelimiter argument). Dodeca will cycle through each member combination of items selected in the Market and Product dimensions and build rows based on the combination.