Skip to content

Commit 3fbb3e9

Browse files
authored
Merge pull request MicrosoftDocs#4555 from CarlRabeler/patch-70
Update understanding-tabular-object-model-at-levels-1050-through-1103.md
2 parents d598620 + daecb2e commit 3fbb3e9

1 file changed

Lines changed: 12 additions & 13 deletions

File tree

docs/analysis-services/tabular-model-programming-compatibility-levels-1050-1103/representation/understanding-tabular-object-model-at-levels-1050-through-1103.md

Lines changed: 12 additions & 13 deletions
Original file line numberDiff line numberDiff line change
@@ -22,55 +22,54 @@ ms.workload: "Inactive"
2222
---
2323
# Understanding Tabular Object Model at Levels 1050 through 1103
2424
[!INCLUDE[ssas-appliesto-sqlas](../../../includes/ssas-appliesto-sqlas.md)]
25-
[!INCLUDE[ssas-appliesto-sqlas-all](../../../includes/ssas-appliesto-sqlas-all.md)]
2625

2726
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.
2827

2928
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.
3029

3130
## 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.
3332

3433
See [Database Representation&#40;Tabular&#41;](../../../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.
3534

3635
## 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.
3837

3938
See [Connection Representation &#40;Tabular&#41;](../../../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.
4039

4140
## 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.
4342

4443
See [Tables Representation &#40;Tabular&#41;](../../../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.
4544

4645
### 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.
4847

4948
See [Calculated Column Representation &#40;Tabular&#41;](../../../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.
5049

5150
### 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.
5352

5453
> [!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.
5655
5756
See [Calculated Measure Representation &#40;Tabular&#41;](../../../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.
5857

5958
### 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.
6160

6261
See [Hierarchy Representation &#40;Tabular&#41;](../../../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.
6362

6463
### Key Performance Indicator –KPI- Representation
65-
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.
6665

6766
> [!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.
6968
7069
See [Key Performance Indicator Representation &#40;Tabular&#41;](../../../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.
7170

7271
### 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.
7473

7574
See [Partition Representation &#40;Tabular&#41;](../../../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.
7675

@@ -79,12 +78,12 @@ ms.workload: "Inactive"
7978

8079
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.
8180

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.
8382

8483
See [Relationship Representation &#40;Tabular&#41;](../../../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.
8584

8685
## 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.
8887

8988
See [Perspective Representation &#40;Tabular&#41;](../../../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.
9089

0 commit comments

Comments
 (0)