This format is still under investigation.
The design of the detail XML format is not what one would end up with for describing pivot tables. This is because it is a special case of a much more general format (“visualization XML” or “VizML”) that can describe a wide range of visualizations. Most of this generality is overkill for tables, and so we end up with a funny subset of a general-purpose format.
The important elements of the detail XML format are:
The bulk of variables are defined with
The data for these variables comes from the associated
tableData.bin member. Some variables are defined, with
derivedVariable elements, as a constant or in terms of a
mapping function from a source variable.
facetingelement and its sub-elements describe this assignment.
All elements have an optional
id attribute. In practice many
elements are assigned
id attributes that are never referenced.
|• SPV Detail visualization Element:|
|• SPV Detail userSource Element:|
|• SPV Detail sourceVariable Element:|
|• SPV Detail derivedVariable Element:|
|• SPV Detail extension Element:|
|• SPV Detail graph Element:|
|• SPV Detail location Element:|
|• SPV Detail coordinates Element:|
|• SPV Detail faceting Element:|
|• SPV Detail facetLayout Element:|
|• SPV Detail style Element:|