Data Model > Available DSCs > Quanvert DSC > Special types of Quanvert projects > Quanvert levels projects
 
Quanvert levels projects
Quanvert DSC provides full support for Quanvert levels projects.
In Quanvert levels projects, the data is hierarchical. A typical example would be a project that stores the responses to a household survey in which information was collected about the household as a whole (such as the area of residence, type of residence, and so on) and about each person in the household (such as age, gender, occupation, and so on). This project would contain two levels: a top household level and a lower person level. For each household, there would be one case at the household level and the number of cases at the person level would correspond to the number of people in the household. In some levels projects there may be several levels, for example, additional levels representing the pets and vehicles in the household.
Quanvert DSC represents each level (apart from the top level) as an unbounded loop (Array object of type mlLevel) in the metadata. When a hierarchical view of the case data is being used, the top level corresponds to the HDATA virtual table and each lower level corresponds to a child table. Grids are also represented as child tables. This means that in a project that contains grids, the structure of the HDATA tables will not exactly match the structure of the Quanvert levels. When the VDATA virtual table is being used to represent a flat view of the data, only the top level data is accessible.
The UNICOM Intelligence Developer Documentation Library includes a sample of a Quanvert levels project, called Household. For more information, see The Household sample.
See also
Hierarchical data in the MDM
Virtual tables
Understanding hierarchical data
Special types of Quanvert projects