2.2.5 Common Data Structures
This section describes the hierarchy of metadata objects that can be discovered, defined, and administered by using the APIs in this specification. This section defines the metadata objects and their properties for a Tabular database at compatibility level 1200 or higher.
The root object of a Tabular database is Model. All other metadata objects are descendants of the Model object.
The following table illustrates the hierarchy structure of the metadata objects. With the exception of AttributeHierarchy, KPI, DetailRowsDefinition, CalculationGroup, FormatStringDefinition, and LinguisticMetadata, each child object can be a collection of child objects. For example, the Model object can contain a child object named Tables, which is a collection of Table objects; and each of those Table objects can contain a child object named Columns, which is a collection of Column objects; and so on. The following table also describes whether the lowest-level descendant of a particular parent object in this hierarchy can be an Annotation or ExtendedProperty object.
|
Root Object |
Descendant |
Descendant |
Descendant |
Descendant |
|
|---|---|---|---|---|---|
|
Model |
|
||||
|
DataSource |
|
||||
|
Annotation |
|
||||
|
ExtendedProperty |
|
||||
|
Table |
|
||||
|
Column |
|
||||
|
AttributeHierarchy |
|
||||
|
Annotation |
|||||
|
ExtendedProperty |
|||||
|
Variation |
|
||||
|
Annotation |
|||||
|
ExtendedProperty |
|||||
|
Annotation |
|
||||
|
ExtendedProperty |
|
||||
|
Partition |
|
||||
|
Annotation |
|
||||
|
ExtendedProperty |
|
||||
|
Measure |
|
||||
|
KPI |
|
||||
|
Annotation |
|||||
|
ExtendedProperty |
|||||
|
DetailRowsDefinition |
|
||||
|
FormatStringDefinition |
|
||||
|
Annotation |
|
||||
|
ExtendedProperty |
|
||||
|
Hierarchy |
|
||||
|
Level |
|
||||
|
Annotation |
|||||
|
ExtendedProperty |
|||||
|
Annotation |
|
||||
|
ExtendedProperty |
|
||||
|
DetailRowsDefinition |
|
||||
|
CalculationGroup |
|
||||
|
CalculationItem |
|
||||
|
FormatStringDefinition |
|||||
|
Annotation |
|
||||
|
Annotation |
|
||||
|
ExtendedProperty |
|
||||
|
Relationship |
|
||||
|
Annotation |
|
||||
|
ExtendedProperty |
|
||||
|
Perspective |
|
||||
|
PerspectiveTable |
|
||||
|
PerspectiveColumn |
|
||||
|
Annotation |
|||||
|
ExtendedProperty |
|||||
|
PerspectiveHierarchy |
|
||||
|
Annotation |
|||||
|
ExtendedProperty |
|||||
|
PerspectiveMeasure |
|
||||
|
Annotation |
|||||
|
ExtendedProperty |
|||||
|
Annotation |
|
||||
|
ExtendedProperty |
|
||||
|
Annotation |
|
||||
|
ExtendedProperty |
|
||||
|
Culture |
|
||||
|
ObjectTranslation |
|
||||
|
LinguisticMetadata |
|
||||
|
Annotation |
|
||||
|
ExtendedProperty |
|
||||
|
Annotation |
|
||||
|
ExtendedProperty |
|
||||
|
Role |
|
||||
|
RoleMembership |
|
||||
|
Annotation |
|
||||
|
ExtendedProperty |
|
||||
|
TablePermission |
|
||||
|
ColumnPermission |
|
||||
|
Annotation |
|||||
|
ExtendedProperty |
|||||
|
Annotation |
|
||||
|
ExtendedProperty |
|
||||
|
Annotation |
|
||||
|
ExtendedProperty |
|
||||
|
Expression |
|
||||
|
Annotation |
|
||||
|
ExtendedProperty |
|
||||
|
QueryGroup |
|
||||
|
Annotation |
|
||||
|
Annotation |
|
||||
|
ExtendedProperty |
|
||||