Conceptual Data Model - Microsoft SQL Server 2008 Analysis Services - page 36

Catalog

Dimension

Attribute

Hierarchy

Level

Cube

CubeDimension

CubeAttribute

CubeHierarchy

Measure Group

MeasureGroupDimension

MeasureGroupAttribute

Measure

Perspective

PerspectiveDimension

PerspectiveAttribute

Perspective Hierarchy

PerspectiveMeasureGroup

PerspectiveMeasure

FIGURE 4.1

The major objects of the conceptual model are shown in dark gray.

The Translation property of an object enables you to define translation of the object's
Name into different languages. The Language property of the Translation defines to which
language Name is translated.

The ID property of the object, once it's specified, can't be changed. The name of the object
and the translation of that name can be easily changed, and because of that can't be used
for cross-references.

LISTING 4.2

Translating a Database Object Name to Russian

<Database xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine”>
<ID>FoodMart 2008</ID>
<Name>FoodMart 2008</Name>
<Translations>
<Translation>