Abstract: In one form, the disclosure relates to data analysis, namely (but not exclusively) analysis of data in an analytical database. The disclosure may also relate to analysis of complex coded data, in particular hierarchical data. A number of aspects of invention are disclosed, including, without limitation, the Storage of hierarchic data, a GUI representation of hierarchic data, hierarchic data convolution and devolution, cross tabulation of complex data, including a segment method, an offset method, a one-level method, and a segment matching method, and a grid construction generator for making hierarchic variables.