You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/analysis-services/tabular-model-programming-compatibility-levels-1050-1103/representation/understanding-tabular-object-model-at-levels-1050-through-1103.md
+12-13Lines changed: 12 additions & 13 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -22,55 +22,54 @@ ms.workload: "Inactive"
22
22
---
23
23
# Understanding Tabular Object Model at Levels 1050 through 1103
A tabular model is a logical representation of tables, relationships, hierarchies, perspectives, measures, and Key Performance. This section introduces the internal implementation using AMO. See [Developing with Analysis Management Objects (AMO)](../../../analysis-services/multidimensional-models/analysis-management-objects/developing-with-analysis-management-objects-amo.md) if you haven't used AMO before.
28
27
29
28
The approach here is top-down, all relevant objects in the tabular model are logically mapped to AMO objects, and the required interaction or workflow explained. A source code sample to create a tabular model using AMO, AMO to Tabular sample is available from Codeplex. An important note about the code in the sample: it is provided only to support to the logical concepts explained here and should not be used in a production environment. The sample is provided without support or warranty.
30
29
31
30
## Database Representation
32
-
A database provides the container object for the tabular model. All objects in a tabular model are contained in the database. In terms of AMO objects, a database representation has a one-to-one mapping relationship with <xref:Microsoft.AnalysisServices.Database>, and no other main AMO objects are required. It is important to note that this doesn't mean that all contained objects in the AMO database object can be used when modeling.
31
+
A database provides the container object for the tabular model. All objects in a tabular model are contained in the database. In terms of AMO objects, a database representation has a one-to-one mapping relationship with `xref:Microsoft.AnalysisServices.Database`, and no other main AMO objects are required. It is important to note that this doesn't mean that all contained objects in the AMO database object can be used when modeling.
33
32
34
33
See [Database Representation(Tabular)](../../../analysis-services/tabular-model-programming-compatibility-levels-1050-1103/representation/database-representation-tabular.md) for a detailed explanation on how to create and manipulate the database representation.
35
34
36
35
## Connection Representation
37
-
A connection establishes the relationship between the data to be included in a tabular model solution and the model itself. In terms of AMO objects, a connection has a one-to-one mapping relationship with <xref:Microsoft.AnalysisServices.DataSource>, and no other main AMO objects are required. It is important to note that this doesn't mean that all contained objects in the AMO datasource object can be used when modeling.
36
+
A connection establishes the relationship between the data to be included in a tabular model solution and the model itself. In terms of AMO objects, a connection has a one-to-one mapping relationship with `xref:Microsoft.AnalysisServices.DataSource`, and no other main AMO objects are required. It is important to note that this doesn't mean that all contained objects in the AMO datasource object can be used when modeling.
38
37
39
38
See [Connection Representation (Tabular)](../../../analysis-services/tabular-model-programming-compatibility-levels-1050-1103/representation/connection-representation-tabular.md) for a detailed explanation on how to create and manipulate the data source representation.
40
39
41
40
## Table Representation
42
-
Tables are database objects that contain the data in the database. In terms of AMO objects, a table has a one-to-many mapping relationship. A table is represented by the usage of the following AMO objects: <xref:Microsoft.AnalysisServices.DataSourceView>, <xref:Microsoft.AnalysisServices.Dimension>, <xref:Microsoft.AnalysisServices.Cube>, <xref:Microsoft.AnalysisServices.CubeDimension>, <xref:Microsoft.AnalysisServices.MeasureGroup> and <xref:Microsoft.AnalysisServices.Partition> are the main required objects; however, it is important to note that this doesn't mean that all contained objects in the previously mentioned AMO objects can be used when modeling.
41
+
Tables are database objects that contain the data in the database. In terms of AMO objects, a table has a one-to-many mapping relationship. A table is represented by the usage of the following AMO objects: `xref:Microsoft.AnalysisServices.DataSourceView`, `xref:Microsoft.AnalysisServices.Dimension`, `xref:Microsoft.AnalysisServices.Cube`, `xref:Microsoft.AnalysisServices.CubeDimension`, `xref:Microsoft.AnalysisServices.MeasureGroup` and `xref:Microsoft.AnalysisServices.Partition` are the main required objects. However, it is important to note that this doesn't mean that all contained objects in the previously mentioned AMO objects can be used when modeling.
43
42
44
43
See [Tables Representation (Tabular)](../../../analysis-services/tabular-model-programming-compatibility-levels-1050-1103/representation/tables-representation-tabular.md) for a detailed explanation on how to create and manipulate the table representation.
45
44
46
45
### Calculated Column Representation
47
-
Calculated columns are evaluated expressions that generate a column in a table, where a new value is calculated and stored for each row in the table. In terms of AMO objects a calculated column has a one-to-many mapping relationship. A calculated column is represented by the usage of the following AMO objects: <xref:Microsoft.AnalysisServices.Dimension> and <xref:Microsoft.AnalysisServices.MeasureGroup> are the main required objects. It is important to note that this doesn't mean that all contained objects in the previously mentioned AMO objects can be used when modeling.
46
+
Calculated columns are evaluated expressions that generate a column in a table, where a new value is calculated and stored for each row in the table. In terms of AMO objects, a calculated column has a one-to-many mapping relationship. A calculated column is represented by the usage of the following AMO objects: `xref:Microsoft.AnalysisServices.Dimension` and `xref:Microsoft.AnalysisServices.MeasureGroup` are the main required objects. It is important to note that this doesn't mean that all contained objects in the previously mentioned AMO objects can be used when modeling.
48
47
49
48
See [Calculated Column Representation (Tabular)](../../../analysis-services/tabular-model-programming-compatibility-levels-1050-1103/representation/tables-calculated-column-representation.md) for a detailed explanation on how to create and manipulate the calculated column representation.
50
49
51
50
### Calculated Measure Representation
52
-
Calculated Measures are stored expressions that are evaluated upon request once the model is deployed. In terms of AMO objects, a calculated measure has a one-to-many mapping relationship. A calculated column is represented by the usage of the following AMO objects: <xref:Microsoft.AnalysisServices.MdxScript.Commands%2A> and <xref:Microsoft.AnalysisServices.MdxScript.CalculationProperties%2A> are the main required objects. It is important to note that this doesn't mean that all contained objects in the previously mentioned AMO objects can be used when modeling.
51
+
Calculated Measures are stored expressions that are evaluated upon request once the model is deployed. In terms of AMO objects, a calculated measure has a one-to-many mapping relationship. A calculated column is represented by the usage of the following AMO objects: `xref:Microsoft.AnalysisServices.MdxScript.Commands%2A` and `xref:Microsoft.AnalysisServices.MdxScript.CalculationProperties%2A` are the main required objects. It is important to note that this doesn't mean that all contained objects in the previously mentioned AMO objects can be used when modeling.
53
52
54
53
> [!NOTE]
55
-
> The <xref:Microsoft.AnalysisServices.Measure> objects have no relationship with the calculated measures in tabular models, and are not supported in tabular models.
54
+
> The `xref:Microsoft.AnalysisServices.Measure` objects have no relationship with the calculated measures in tabular models, and are not supported in tabular models.
56
55
57
56
See [Calculated Measure Representation (Tabular)](../../../analysis-services/tabular-model-programming-compatibility-levels-1050-1103/representation/tables-calculated-measure-representation.md) for a detailed explanation on how to create and manipulate the calculated measure representation.
58
57
59
58
### Hierarchy Representation
60
-
Hierarchies are a mechanism to provide a richer drill-up and drill-down experience to the end user. In terms of AMO objects, a hierarchy representation has a one-to-one mapping relationship with <xref:Microsoft.AnalysisServices.Hierarchy>, and no other main AMO objects are required. It is important to note that this doesn't mean that all contained objects in the AMO database object can be used when doing tabular modeling.
59
+
Hierarchies are a mechanism to provide a richer drill-up and drill-down experience to the end user. In terms of AMO objects, a hierarchy representation has a one-to-one mapping relationship with `xref:Microsoft.AnalysisServices.Hierarchy`, and no other main AMO objects are required. It is important to note that this doesn't mean that all contained objects in the AMO database object can be used when doing tabular modeling.
61
60
62
61
See [Hierarchy Representation (Tabular)](../../../analysis-services/tabular-model-programming-compatibility-levels-1050-1103/representation/tables-hierarchy-representation.md) for a detailed explanation on how to create and manipulate the hierarchy representation.
A KPI is used to gauge performance of a value, defined by a Base measure, against a Target value. In terms of AMO objects, a KPI representation has a one-to-many mapping relationship. A KPI is represented by the usage of the following AMO objects: <xref:Microsoft.AnalysisServices.MdxScript.Commands%2A>and <xref:Microsoft.AnalysisServices.MdxScript.CalculationProperties%2A> are the main required objects. It is important to note that this doesn't mean that all contained objects in the previously mentioned AMO objects can be used when modeling.
64
+
A KPI is used to gauge performance of a value, defined by a Base measure, against a Target value. In terms of AMO objects, a KPI representation has a one-to-many mapping relationship. A KPI is represented by the usage of the following AMO objects: `xref:Microsoft.AnalysisServices.MdxScript.Commands%2A`and `xref:Microsoft.AnalysisServices.MdxScript.CalculationProperties%2A` are the main required objects. It is important to note that this doesn't mean that all contained objects in the previously mentioned AMO objects can be used when modeling.
66
65
67
66
> [!NOTE]
68
-
> Also, important distinction, the <xref:Microsoft.AnalysisServices.Kpi> objects have no relationship with the KPIs in tabular models. And, they are not supported in tabular models.
67
+
> Also, important distinction, the `xref:Microsoft.AnalysisServices.Kpi` objects have no relationship with the KPIs in tabular models. And, they are not supported in tabular models.
69
68
70
69
See [Key Performance Indicator Representation (Tabular)](../../../analysis-services/tabular-model-programming-compatibility-levels-1050-1103/representation/tables-key-performance-indicator-representation.md) for a detailed explanation on how to create and manipulate the KPI representation.
71
70
72
71
### Partition Representation
73
-
For operational purposes, a table can be divided in different subsets of rows that when combined together form the table. Each of those subsets is a partition of the table. In terms of AMO objects, a partition representation has a one-to-one mapping relationship with <xref:Microsoft.AnalysisServices.Partition> and no other main AMO objects are required. It is important to note that this doesn't mean that all contained objects in the AMO database object can be used when modeling.
72
+
For operational purposes, a table can be divided in different subsets of rows that, when combined together, form the table. Each of those subsets is a partition of the table. In terms of AMO objects, a partition representation has a one-to-one mapping relationship with `xref:Microsoft.AnalysisServices.Partition` and no other main AMO objects are required. It is important to note that this doesn't mean that all contained objects in the AMO database object can be used when modeling.
74
73
75
74
See [Partition Representation (Tabular)](../../../analysis-services/tabular-model-programming-compatibility-levels-1050-1103/representation/tables-partition-representation.md) for a detailed explanation on how to create and manipulate the partition representation.
76
75
@@ -79,12 +78,12 @@ ms.workload: "Inactive"
79
78
80
79
In tabular models, multiple relationships can be defined between two tables. When multiple relationships between two tables are defined, only one can be defined as the default Active relationship. All other relationships are Inactive.
81
80
82
-
In terms of AMO objects, all inactive relationships have a representation of a one-to-one mapping relationship with <xref:Microsoft.AnalysisServices.Relationship>, and no other main AMO objects are required. For the active relationship, other requirements exist and a mapping to the <xref:Microsoft.AnalysisServices.ReferenceMeasureGroupDimension> is also required. It is important to note that this doesn't mean that all contained objects in the AMO relationship or referenceMeasureGroupDimension object can be used when modeling.
81
+
In terms of AMO objects, all inactive relationships have a representation of a one-to-one mapping relationship with `xref:Microsoft.AnalysisServices.Relationship`, and no other main AMO objects are required. For the active relationship, other requirements exist and a mapping to the `xref:Microsoft.AnalysisServices.ReferenceMeasureGroupDimension` is also required. It is important to note that this doesn't mean that all contained objects in the AMO relationship or referenceMeasureGroupDimension object can be used when modeling.
83
82
84
83
See [Relationship Representation (Tabular)](../../../analysis-services/tabular-model-programming-compatibility-levels-1050-1103/representation/relationship-representation-tabular.md) for a detailed explanation on how to create and manipulate the relationship representation.
85
84
86
85
## Perspective Representation
87
-
A perspective is a mechanism to simplify or focus the mode. In terms of AMO objects, a relationship representation has a one-to-one mapping relationship with <xref:Microsoft.AnalysisServices.Perspective> and no other main AMO objects are required. It is important to note that this doesn't mean that all contained objects in the AMO perspective ob0ject can be used when doing tabular modeling.
86
+
A perspective is a mechanism to simplify or focus the mode. In terms of AMO objects, a relationship representation has a one-to-one mapping relationship with `xref:Microsoft.AnalysisServices.Perspective` and no other main AMO objects are required. It is important to note that this doesn't mean that all contained objects in the AMO perspective object can be used when doing tabular modeling.
88
87
89
88
See [Perspective Representation (Tabular)](../../../analysis-services/tabular-model-programming-compatibility-levels-1050-1103/representation/perspective-representation-tabular.md) for a detailed explanation on how to create and manipulate the perspective representation.
0 commit comments