Retain Detail Values Generated for Master Selector Tables

When using master selector tables and trees to specify ChartField combination values, the build process for static master selector tables stores only the range of values described by the tree nodes. The build process does not store the detail values encompassed by the nodes. It is when transactions are edited during combination editing batch processing that the range of values for each ChartField is exploded and stored in temporary tables for each editing request. Because the process deletes the temporary tables when the edits are complete, the temporary tables must be rebuilt for each separate edit request.

However, if you select the Retain Detail Values option for master selector tables on the ChartField Combination Editing Group page, combinations for the detail values are retained in a permanent table, PS_COMB_EXPLODED, after the values are generated during the build process. This precluding the repeated generation of combination detail values that were previously generated.

The Retain Detail Values option is of particularly value if the tree nodes encompass large numbers of ChartField values. When you use this option, the build process might take longer but batch combination editing performance is greatly improved because repeated exploding of values is eliminated.

However, if a new value is added within a ChartField range that is setup for a tree node, it does not cause the new value to be automatically included in the permanent ChartField value combination table even if the Increment option is selected on the ChartField Combination Editing Group setup page. Addition of a new value to a range does not in itself cause a rebuild of the detail values for the master selector table because the tree version is not changed.

If you add a new ChartField value within a range of values in a tree node and if you have selected the Retain Detail Values option and have already built the combination data, you must run the combination build process again to include the newly added values in the PS_COMB_EXPLODED table.

Note:

The Review Combination Selector table inquiry displays the result from the selector tables and not the detail values even if a Combination Group has the Retain Detail Values check box selected.