DSO uses hierarchically arranged groups of objects to define basic elements of Analysis Services data storage, as implemented by the Analysis server.
The following table lists the mappings between the objects contained within the DSO and PowerDesigner PDM metamodels:
DSO Object |
PowerDesigner PDM Object |
---|---|
clsDatabase |
Model (Each model corresponds to a DSO Database.) |
clsDataSource |
Data source |
ClsDatabaseDimension |
Dimension (As in the DSO model, PowerDesigner dimensions are shared among cubes.) |
clsCube |
Cube (Cubes managed by PowerDesigner are only local cubes.) |
clsCube |
Fact (A Fact corresponds to a DSO cube in order to store measures.) |
clsCubeMeasure |
Measure |
clsDatabaseDimension |
Dimension hierarchy (Each dimension hierarchy is generated as a DSO Database Dimension. Attributes of a dimension hierarchy define levels of the corresponding DatabaseDimension.) |
clsDatabaseLevel clsCubeLevel |
Dimension attribute (Attributes of a dimension or dimension hierarchy define levels in a database dimension.) |
clsCubeDimension |
Cube dimension association (In DSO, when the name of a Cube Dimension corresponds to the name of a Database Dimension, the Cube Dimension is automatically associated with the Database Dimension to be shared between cubes.) |