Catalog with cube with different member identifiers
In some cases, all data are stored in one table, the fact as well as multiple levels. This Tutorial shows how to handle this case with diferent casses of data.
Database Schema
The cube defined in this example is based on only one tables with diferent casses of data space, space first, space last, separate line, long with over 100 12345678.... , äüö, some russian latter, some french letters, @€
<roma:DatabaseSchema id="_dbschema">
<tables xsi:type="roma:PhysicalTable" id="_tab_fact" name="Fact">
<columns xsi:type="roma:PhysicalColumn" id="_col_fact_key1" name="KEY1"/>
<columns xsi:type="roma:PhysicalColumn" id="_col_fact_key2" name="KEY2"/>
<columns xsi:type="roma:PhysicalColumn" id="_col_fact_value" name="VALUE" type="Integer"/>
</tables>
</roma:DatabaseSchema>Note: This is only a symbolic example. For the exact definition, see the Definition section.
Query Fact
The TableQuery for the Levels and the Measure.
<roma:TableQuery id="_query" table="_tab_fact"/>Note: This is only a symbolic example. For the exact definition, see the Definition section.
Level1
The level of the level1 used the column attribute to define the column that holds the name, wich is also the key Column.
<roma:Level id="_level1" name="level1" column="_col_fact_key1"/>Note: This is only a symbolic example. For the exact definition, see the Definition section.
Level2
The level of the level2 used the column attribute to define the column that holds the name, wich is also the key Column.
<roma:Level id="_level2" name="level2" column="_col_fact_key2"/>Note: This is only a symbolic example. For the exact definition, see the Definition section.
Hierarchy
This Hierarchy contains both defined levels. The primaryKey attribute defines the column that contains the primary key of the hierarchy. The query attribute references to the query that will be used to retrieve the data for the hierarchy.
The order of the Levels in the hierarchy is important, as it determines the drill-down path for the hierarchy.
<roma:ExplicitHierarchy id="_hierarchy" name="Hierarchy" primaryKey="_col_fact_key1" query="_query" levels="_level1 _level2"/>Note: This is only a symbolic example. For the exact definition, see the Definition section.
Dimension
The Dimension has only one hierarchy.
<roma:StandardDimension id="_dim_dimension" name="Dimension" hierarchies="roma:ExplicitHierarchy _hierarchy"/>Note: This is only a symbolic example. For the exact definition, see the Definition section.
Cube with different member identifiers
The cube contains only one Measure in a unnamed MeasureGroup and references to the Dimension.
To connect the dimension to the cube, a DimensionConnector is used.
<roma:PhysicalCube id="_cube" name="Cube" query="_query">
<dimensionConnectors foreignKey="roma:PhysicalColumn _col_fact_key1" dimension="roma:StandardDimension _dim_dimension"/>
<measureGroups>
<measures xsi:type="roma:SumMeasure" id="_measure" name="theMeasure" column="_col_fact_value"/>
</measureGroups>
</roma:PhysicalCube>Note: This is only a symbolic example. For the exact definition, see the Definition section.
Definition
This files represent the complete definition of the catalog.
<?xml version="1.0" encoding="UTF-8"?>
<xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:roma="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping">
<roma:ExplicitHierarchy id="_hierarchy" name="Hierarchy" primaryKey="_col_fact_key1" query="_query" levels="_level1 _level2"/>
<roma:Catalog name="Catalog with cube with different member identifiers" cubes="_cube" dbschemas="_dbschema"/>
<roma:DatabaseSchema id="_dbschema">
<tables xsi:type="roma:PhysicalTable" id="_tab_fact" name="Fact">
<columns xsi:type="roma:PhysicalColumn" id="_col_fact_key1" name="KEY1"/>
<columns xsi:type="roma:PhysicalColumn" id="_col_fact_key2" name="KEY2"/>
<columns xsi:type="roma:PhysicalColumn" id="_col_fact_value" name="VALUE" type="Integer"/>
</tables>
</roma:DatabaseSchema>
<roma:TableQuery id="_query" table="_tab_fact"/>
<roma:Level id="_level2" name="level2" column="_col_fact_key2"/>
<roma:Level id="_level1" name="level1" column="_col_fact_key1"/>
<roma:StandardDimension id="_dim_dimension" name="Dimension" hierarchies="_hierarchy"/>
<roma:PhysicalCube id="_cube" name="Cube" query="_query">
<dimensionConnectors foreignKey="_col_fact_key1" dimension="_dim_dimension"/>
<measureGroups>
<measures xsi:type="roma:SumMeasure" id="_measure" name="theMeasure" column="_col_fact_value"/>
</measureGroups>
</roma:PhysicalCube>
</xmi:XMI>Turorial Zip
This files contaisn the data-tables as csv and the mapping as xmi file.