Parcel Database

Parcel delivery service database for analyzing package logistics and delivery operations. Contains parcel data with dimensional analysis for delivery performance optimization and logistics management insights.

Parcel Cube

The Parcel cube contains delivery metrics with dimensional breakdowns for packages. Enables analysis by dimensions, addresses, parcel types, and delivery characteristics.

<xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"  xmlns:relational="http://www.omg.org/spec/CWM/1.1/resource/relational" xmlns:rolapcube="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/cube" xmlns:rolapsrc="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/database/source">
  <rolapcube:PhysicalCube xmi:id="_physicalcube_parcels" name="Parcels" source="_tablesource_parcels"/>
  <relational:Table xmi:id="_table_parcels" name="parcels">
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_parcel_id" name="parcel_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_width" name="width"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_depth" name="depth"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_height" name="height"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_type_id" name="type_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_defect_id" name="defect_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_deliverable" name="deliverable"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_customs" name="customs"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_return_status" name="return_status"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_sender_id" name="sender_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_receiver_id" name="receiver_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_drop_off_id" name="drop_off_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_delivery_id" name="delivery_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_postage" name="postage"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_insurance_value" name="insurance_value"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_weight" name="weight"/>
  </relational:Table>
  <rolapsrc:TableSource xmi:id="_tablesource_parcels" table="_table_parcels"/>
</xmi:XMI>

Note: This is only a symbolic example. For the exact definition, see the Definition section.

Width Dimension

Physical dimensions enable analysis of package sizes and space utilization for logistics optimization and capacity planning.

<xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"  xmlns:relational="http://www.omg.org/spec/CWM/1.1/resource/relational" xmlns:rolapdim="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension" xmlns:rolaphier="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy" xmlns:rolaplev="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy/level" xmlns:rolapsrc="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/database/source">
  <rolapdim:StandardDimension xmi:id="_standarddimension_width" name="Width" hierarchies="_explicithierarchy_width"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_width" name="Width" allMemberName="All Widths" primaryKey="_column_parcels_width" source="_tablesource_parcels" levels="_level_width"/>
  <rolaplev:Level xmi:id="_level_width" name="Width" column="_column_parcels_width"/>
  <relational:Table xmi:id="_table_parcels" name="parcels">
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_parcel_id" name="parcel_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_width" name="width"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_depth" name="depth"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_height" name="height"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_type_id" name="type_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_defect_id" name="defect_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_deliverable" name="deliverable"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_customs" name="customs"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_return_status" name="return_status"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_sender_id" name="sender_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_receiver_id" name="receiver_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_drop_off_id" name="drop_off_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_delivery_id" name="delivery_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_postage" name="postage"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_insurance_value" name="insurance_value"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_weight" name="weight"/>
  </relational:Table>
  <rolapsrc:TableSource xmi:id="_tablesource_parcels" table="_table_parcels"/>
</xmi:XMI>

Note: This is only a symbolic example. For the exact definition, see the Definition section.

Depth Dimension

Physical dimensions enable analysis of package sizes and space utilization for logistics optimization and capacity planning.

<xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"  xmlns:relational="http://www.omg.org/spec/CWM/1.1/resource/relational" xmlns:rolapdim="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension" xmlns:rolaphier="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy" xmlns:rolaplev="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy/level" xmlns:rolapsrc="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/database/source">
  <rolapdim:StandardDimension xmi:id="_standarddimension_depth" name="Depth" hierarchies="_explicithierarchy_depth"/>
  <rolaplev:Level xmi:id="_level_depth" name="Depth" column="_column_parcels_depth"/>
  <relational:Table xmi:id="_table_parcels" name="parcels">
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_parcel_id" name="parcel_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_width" name="width"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_depth" name="depth"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_height" name="height"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_type_id" name="type_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_defect_id" name="defect_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_deliverable" name="deliverable"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_customs" name="customs"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_return_status" name="return_status"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_sender_id" name="sender_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_receiver_id" name="receiver_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_drop_off_id" name="drop_off_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_delivery_id" name="delivery_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_postage" name="postage"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_insurance_value" name="insurance_value"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_weight" name="weight"/>
  </relational:Table>
  <rolapsrc:TableSource xmi:id="_tablesource_parcels" table="_table_parcels"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_depth" name="Depth" allMemberName="All Depths" primaryKey="_column_parcels_depth" source="_tablesource_parcels" levels="_level_depth"/>
</xmi:XMI>

Note: This is only a symbolic example. For the exact definition, see the Definition section.

Height Dimension

Physical dimensions enable analysis of package sizes and space utilization for logistics optimization and capacity planning.

<xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"  xmlns:relational="http://www.omg.org/spec/CWM/1.1/resource/relational" xmlns:rolapdim="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension" xmlns:rolaphier="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy" xmlns:rolaplev="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy/level" xmlns:rolapsrc="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/database/source">
  <rolapdim:StandardDimension xmi:id="_standarddimension_height" name="Height" hierarchies="_explicithierarchy_height"/>
  <rolaplev:Level xmi:id="_level_height" name="Height" column="_column_parcels_height"/>
  <relational:Table xmi:id="_table_parcels" name="parcels">
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_parcel_id" name="parcel_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_width" name="width"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_depth" name="depth"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_height" name="height"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_type_id" name="type_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_defect_id" name="defect_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_deliverable" name="deliverable"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_customs" name="customs"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_return_status" name="return_status"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_sender_id" name="sender_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_receiver_id" name="receiver_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_drop_off_id" name="drop_off_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_delivery_id" name="delivery_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_postage" name="postage"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_insurance_value" name="insurance_value"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_weight" name="weight"/>
  </relational:Table>
  <rolapsrc:TableSource xmi:id="_tablesource_parcels" table="_table_parcels"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_height" name="Height" allMemberName="All Heights" primaryKey="_column_parcels_height" source="_tablesource_parcels" levels="_level_height"/>
</xmi:XMI>

Note: This is only a symbolic example. For the exact definition, see the Definition section.

Parcel Type Dimension

Parcel type dimension categorizes packages by delivery service type for service-specific performance analysis.

<xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"  xmlns:relational="http://www.omg.org/spec/CWM/1.1/resource/relational" xmlns:rolapdim="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension" xmlns:rolaphier="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy" xmlns:rolaplev="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy/level" xmlns:rolapsrc="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/database/source">
  <rolapdim:StandardDimension xmi:id="_standarddimension_parcel_type" name="Parcel Type" hierarchies="_explicithierarchy_parcel_type"/>
  <rolaplev:Level xmi:id="_level_parcel_type" name="Parcel Type" column="_column_parcel_types_type_id" nameColumn="_column_parcel_types_type_name"/>
  <relational:Table xmi:id="_table_parcel_types" name="parcel_types">
    <feature xsi:type="relational:Column" xmi:id="_column_parcel_types_type_id" name="type_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcel_types_type_name" name="type_name"/>
  </relational:Table>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_parcel_type" name="Parcel Type" allMemberName="All Types" primaryKey="_column_parcel_types_type_id" source="_tablesource_parcel_types" levels="_level_parcel_type"/>
  <rolapsrc:TableSource xmi:id="_tablesource_parcel_types" table="_table_parcel_types"/>
</xmi:XMI>

Note: This is only a symbolic example. For the exact definition, see the Definition section.

Defect Dimension

Defect dimension tracks package condition and damage levels for quality control and insurance claim analysis.

<xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"  xmlns:relational="http://www.omg.org/spec/CWM/1.1/resource/relational" xmlns:rolapdim="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension" xmlns:rolaphier="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy" xmlns:rolaplev="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy/level" xmlns:rolapsrc="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/database/source">
  <rolapdim:StandardDimension xmi:id="_standarddimension_defect" name="Defect" hierarchies="_explicithierarchy_defect"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_defect" name="Defect" allMemberName="All Defects" primaryKey="_column_defects_defect_id" source="_tablesource_defects" levels="_level_defect"/>
  <relational:Table xmi:id="_table_defects" name="defects">
    <feature xsi:type="relational:Column" xmi:id="_column_defects_defect_id" name="defect_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_defects_defect_name" name="defect_name"/>
  </relational:Table>
  <rolapsrc:TableSource xmi:id="_tablesource_defects" table="_table_defects"/>
  <rolaplev:Level xmi:id="_level_defect" name="Defect" column="_column_defects_defect_id" nameColumn="_column_defects_defect_name"/>
</xmi:XMI>

Note: This is only a symbolic example. For the exact definition, see the Definition section.

Deliverable Dimension

Status dimensions track delivery characteristics like deliverability, customs requirements, and return status for operational insights.

<xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"  xmlns:relational="http://www.omg.org/spec/CWM/1.1/resource/relational" xmlns:rolapdim="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension" xmlns:rolaphier="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy" xmlns:rolaplev="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy/level" xmlns:rolapsrc="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/database/source">
  <rolapdim:StandardDimension xmi:id="_standarddimension_deliverable" name="Deliverable" hierarchies="_explicithierarchy_deliverable"/>
  <rolaplev:Level xmi:id="_level_deliverable" name="Deliverable" column="_column_parcels_deliverable"/>
  <relational:Table xmi:id="_table_parcels" name="parcels">
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_parcel_id" name="parcel_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_width" name="width"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_depth" name="depth"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_height" name="height"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_type_id" name="type_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_defect_id" name="defect_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_deliverable" name="deliverable"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_customs" name="customs"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_return_status" name="return_status"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_sender_id" name="sender_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_receiver_id" name="receiver_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_drop_off_id" name="drop_off_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_delivery_id" name="delivery_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_postage" name="postage"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_insurance_value" name="insurance_value"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_weight" name="weight"/>
  </relational:Table>
  <rolapsrc:TableSource xmi:id="_tablesource_parcels" table="_table_parcels"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_deliverable" name="Deliverable" allMemberName="All Deliverable" primaryKey="_column_parcels_deliverable" source="_tablesource_parcels" levels="_level_deliverable"/>
</xmi:XMI>

Note: This is only a symbolic example. For the exact definition, see the Definition section.

Customs Dimension

Status dimensions track delivery characteristics like deliverability, customs requirements, and return status for operational insights.

<xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"  xmlns:relational="http://www.omg.org/spec/CWM/1.1/resource/relational" xmlns:rolapdim="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension" xmlns:rolaphier="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy" xmlns:rolaplev="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy/level" xmlns:rolapsrc="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/database/source">
  <rolapdim:StandardDimension xmi:id="_standarddimension_customs" name="Customs" hierarchies="_explicithierarchy_customs"/>
  <rolaplev:Level xmi:id="_level_customs" name="Customs" column="_column_parcels_customs"/>
  <relational:Table xmi:id="_table_parcels" name="parcels">
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_parcel_id" name="parcel_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_width" name="width"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_depth" name="depth"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_height" name="height"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_type_id" name="type_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_defect_id" name="defect_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_deliverable" name="deliverable"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_customs" name="customs"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_return_status" name="return_status"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_sender_id" name="sender_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_receiver_id" name="receiver_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_drop_off_id" name="drop_off_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_delivery_id" name="delivery_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_postage" name="postage"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_insurance_value" name="insurance_value"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_weight" name="weight"/>
  </relational:Table>
  <rolapsrc:TableSource xmi:id="_tablesource_parcels" table="_table_parcels"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_customs" name="Customs" allMemberName="All Customs" primaryKey="_column_parcels_customs" source="_tablesource_parcels" levels="_level_customs"/>
</xmi:XMI>

Note: This is only a symbolic example. For the exact definition, see the Definition section.

Return Dimension

Status dimensions track delivery characteristics like deliverability, customs requirements, and return status for operational insights.

<xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"  xmlns:relational="http://www.omg.org/spec/CWM/1.1/resource/relational" xmlns:rolapdim="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension" xmlns:rolaphier="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy" xmlns:rolaplev="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy/level" xmlns:rolapsrc="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/database/source">
  <rolapdim:StandardDimension xmi:id="_standarddimension_return" name="Return" hierarchies="_explicithierarchy_return"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_return" name="Return" allMemberName="All Return" primaryKey="_column_parcels_return_status" source="_tablesource_parcels" levels="_level_return"/>
  <relational:Table xmi:id="_table_parcels" name="parcels">
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_parcel_id" name="parcel_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_width" name="width"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_depth" name="depth"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_height" name="height"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_type_id" name="type_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_defect_id" name="defect_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_deliverable" name="deliverable"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_customs" name="customs"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_return_status" name="return_status"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_sender_id" name="sender_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_receiver_id" name="receiver_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_drop_off_id" name="drop_off_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_delivery_id" name="delivery_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_postage" name="postage"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_insurance_value" name="insurance_value"/>
    <feature xsi:type="relational:Column" xmi:id="_column_parcels_weight" name="weight"/>
  </relational:Table>
  <rolapsrc:TableSource xmi:id="_tablesource_parcels" table="_table_parcels"/>
  <rolaplev:Level xmi:id="_level_return" name="Return" column="_column_parcels_return_status"/>
</xmi:XMI>

Note: This is only a symbolic example. For the exact definition, see the Definition section.

Sender Address Dimension

Address dimension provides geographic hierarchy analysis from continent to street level for delivery routing and regional performance tracking.

<xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"  xmlns:relational="http://www.omg.org/spec/CWM/1.1/resource/relational" xmlns:rolapdim="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension" xmlns:rolaphier="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy" xmlns:rolaplev="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy/level" xmlns:rolapsrc="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/database/source">
  <rolapdim:StandardDimension xmi:id="_standarddimension_sender_address" name="Sender Address" hierarchies="_explicithierarchy_geographic_address"/>
  <rolaplev:Level xmi:id="_level_country" name="Country" column="_column_addresses_country"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_geographic_address" name="Geographic Address" allMemberName="All Addresses" primaryKey="_column_addresses_address_id" source="_tablesource_addresses" levels="_level_continent _level_country _level_city _level_postal_code _level_street"/>
  <relational:Table xmi:id="_table_addresses" name="addresses">
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_address_id" name="address_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_continent" name="continent"/>
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_country" name="country"/>
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_city" name="city"/>
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_postal_code" name="postal_code"/>
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_street" name="street"/>
  </relational:Table>
  <rolapsrc:TableSource xmi:id="_tablesource_addresses" table="_table_addresses"/>
  <rolaplev:Level xmi:id="_level_postal_code" name="Postal Code" column="_column_addresses_postal_code"/>
  <rolaplev:Level xmi:id="_level_city" name="City" column="_column_addresses_city"/>
  <rolaplev:Level xmi:id="_level_street" name="Street" column="_column_addresses_street"/>
  <rolaplev:Level xmi:id="_level_continent" name="Continent" column="_column_addresses_continent"/>
</xmi:XMI>

Note: This is only a symbolic example. For the exact definition, see the Definition section.

Receiver Address Dimension

Address dimension provides geographic hierarchy analysis from continent to street level for delivery routing and regional performance tracking.

<xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"  xmlns:relational="http://www.omg.org/spec/CWM/1.1/resource/relational" xmlns:rolapdim="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension" xmlns:rolaphier="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy" xmlns:rolaplev="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy/level" xmlns:rolapsrc="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/database/source">
  <rolapdim:StandardDimension xmi:id="_standarddimension_receiver_address" name="Receiver Address" hierarchies="_explicithierarchy_geographic_address"/>
  <rolaplev:Level xmi:id="_level_country" name="Country" column="_column_addresses_country"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_geographic_address" name="Geographic Address" allMemberName="All Addresses" primaryKey="_column_addresses_address_id" source="_tablesource_addresses" levels="_level_continent _level_country _level_city _level_postal_code _level_street"/>
  <relational:Table xmi:id="_table_addresses" name="addresses">
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_address_id" name="address_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_continent" name="continent"/>
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_country" name="country"/>
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_city" name="city"/>
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_postal_code" name="postal_code"/>
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_street" name="street"/>
  </relational:Table>
  <rolapsrc:TableSource xmi:id="_tablesource_addresses" table="_table_addresses"/>
  <rolaplev:Level xmi:id="_level_postal_code" name="Postal Code" column="_column_addresses_postal_code"/>
  <rolaplev:Level xmi:id="_level_city" name="City" column="_column_addresses_city"/>
  <rolaplev:Level xmi:id="_level_street" name="Street" column="_column_addresses_street"/>
  <rolaplev:Level xmi:id="_level_continent" name="Continent" column="_column_addresses_continent"/>
</xmi:XMI>

Note: This is only a symbolic example. For the exact definition, see the Definition section.

Drop Off Address Dimension

Address dimension provides geographic hierarchy analysis from continent to street level for delivery routing and regional performance tracking.

<xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"  xmlns:relational="http://www.omg.org/spec/CWM/1.1/resource/relational" xmlns:rolapdim="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension" xmlns:rolaphier="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy" xmlns:rolaplev="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy/level" xmlns:rolapsrc="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/database/source">
  <rolapdim:StandardDimension xmi:id="_standarddimension_drop_off_address" name="Drop Off Address" hierarchies="_explicithierarchy_geographic_address"/>
  <rolaplev:Level xmi:id="_level_country" name="Country" column="_column_addresses_country"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_geographic_address" name="Geographic Address" allMemberName="All Addresses" primaryKey="_column_addresses_address_id" source="_tablesource_addresses" levels="_level_continent _level_country _level_city _level_postal_code _level_street"/>
  <relational:Table xmi:id="_table_addresses" name="addresses">
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_address_id" name="address_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_continent" name="continent"/>
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_country" name="country"/>
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_city" name="city"/>
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_postal_code" name="postal_code"/>
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_street" name="street"/>
  </relational:Table>
  <rolapsrc:TableSource xmi:id="_tablesource_addresses" table="_table_addresses"/>
  <rolaplev:Level xmi:id="_level_postal_code" name="Postal Code" column="_column_addresses_postal_code"/>
  <rolaplev:Level xmi:id="_level_city" name="City" column="_column_addresses_city"/>
  <rolaplev:Level xmi:id="_level_street" name="Street" column="_column_addresses_street"/>
  <rolaplev:Level xmi:id="_level_continent" name="Continent" column="_column_addresses_continent"/>
</xmi:XMI>

Note: This is only a symbolic example. For the exact definition, see the Definition section.

Delivery Address Dimension

Address dimension provides geographic hierarchy analysis from continent to street level for delivery routing and regional performance tracking.

<xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"  xmlns:relational="http://www.omg.org/spec/CWM/1.1/resource/relational" xmlns:rolapdim="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension" xmlns:rolaphier="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy" xmlns:rolaplev="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy/level" xmlns:rolapsrc="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/database/source">
  <rolapdim:StandardDimension xmi:id="_standarddimension_delivery_address" name="Delivery Address" hierarchies="_explicithierarchy_geographic_address"/>
  <rolaplev:Level xmi:id="_level_country" name="Country" column="_column_addresses_country"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_geographic_address" name="Geographic Address" allMemberName="All Addresses" primaryKey="_column_addresses_address_id" source="_tablesource_addresses" levels="_level_continent _level_country _level_city _level_postal_code _level_street"/>
  <relational:Table xmi:id="_table_addresses" name="addresses">
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_address_id" name="address_id"/>
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_continent" name="continent"/>
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_country" name="country"/>
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_city" name="city"/>
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_postal_code" name="postal_code"/>
    <feature xsi:type="relational:Column" xmi:id="_column_addresses_street" name="street"/>
  </relational:Table>
  <rolapsrc:TableSource xmi:id="_tablesource_addresses" table="_table_addresses"/>
  <rolaplev:Level xmi:id="_level_postal_code" name="Postal Code" column="_column_addresses_postal_code"/>
  <rolaplev:Level xmi:id="_level_city" name="City" column="_column_addresses_city"/>
  <rolaplev:Level xmi:id="_level_street" name="Street" column="_column_addresses_street"/>
  <rolaplev:Level xmi:id="_level_continent" name="Continent" column="_column_addresses_continent"/>
</xmi:XMI>

Note: This is only a symbolic example. For the exact definition, see the Definition section.

Definition

This file represents 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:relational="http://www.omg.org/spec/CWM/1.1/resource/relational" xmlns:rolapcat="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/catalog" xmlns:rolapcube="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/cube" xmlns:rolapdim="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension" xmlns:rolaphier="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy" xmlns:rolaplev="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy/level" xmlns:rolapmeas="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/cube/measure" xmlns:rolapsrc="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/database/source">
  <relational:SQLSimpleType xmi:id="_sqlsimpletype_character_varying" name="CHARACTER VARYING" structuralFeature="_column_addresses_city _column_addresses_continent _column_addresses_country _column_parcels_customs _column_defects_defect_name _column_parcels_deliverable _column_addresses_postal_code _column_parcels_return_status _column_addresses_street _column_parcel_types_type_name" typeNumber="12"/>
  <relational:SQLSimpleType xmi:id="_sqlsimpletype_decimal" name="DECIMAL" structuralFeature="_column_parcels_insurance_value _column_parcels_depth _column_parcels_height _column_parcels_postage _column_parcels_weight _column_parcels_width" typeNumber="3" numericPrecision="18" numericPrecisionRadix="10" numericScale="4"/>
  <relational:SQLSimpleType xmi:id="_sqlsimpletype_integer" name="INTEGER" structuralFeature="_column_parcels_drop_off_id _column_addresses_address_id _column_defects_defect_id _column_parcels_defect_id _column_parcels_delivery_id _column_parcels_parcel_id _column_parcels_receiver_id _column_parcels_sender_id _column_parcels_type_id _column_parcel_types_type_id" typeNumber="4"/>
  <rolapcat:Catalog xmi:id="_catalog_parcel_delivery_service" name="Parcel Delivery Service" cubes="_physicalcube_parcels" dbschemas="_schema"/>
  <relational:Schema xmi:id="_schema">
    <ownedElement xsi:type="relational:Table" xmi:id="_table_parcels" name="parcels">
      <feature xsi:type="relational:Column" xmi:id="_column_parcels_parcel_id" name="parcel_id" type="_sqlsimpletype_integer"/>
      <feature xsi:type="relational:Column" xmi:id="_column_parcels_width" name="width" type="_sqlsimpletype_decimal"/>
      <feature xsi:type="relational:Column" xmi:id="_column_parcels_depth" name="depth" type="_sqlsimpletype_decimal"/>
      <feature xsi:type="relational:Column" xmi:id="_column_parcels_height" name="height" type="_sqlsimpletype_decimal"/>
      <feature xsi:type="relational:Column" xmi:id="_column_parcels_type_id" name="type_id" type="_sqlsimpletype_integer"/>
      <feature xsi:type="relational:Column" xmi:id="_column_parcels_defect_id" name="defect_id" type="_sqlsimpletype_integer"/>
      <feature xsi:type="relational:Column" xmi:id="_column_parcels_deliverable" name="deliverable" type="_sqlsimpletype_character_varying"/>
      <feature xsi:type="relational:Column" xmi:id="_column_parcels_customs" name="customs" type="_sqlsimpletype_character_varying"/>
      <feature xsi:type="relational:Column" xmi:id="_column_parcels_return_status" name="return_status" type="_sqlsimpletype_character_varying"/>
      <feature xsi:type="relational:Column" xmi:id="_column_parcels_sender_id" name="sender_id" type="_sqlsimpletype_integer"/>
      <feature xsi:type="relational:Column" xmi:id="_column_parcels_receiver_id" name="receiver_id" type="_sqlsimpletype_integer"/>
      <feature xsi:type="relational:Column" xmi:id="_column_parcels_drop_off_id" name="drop_off_id" type="_sqlsimpletype_integer"/>
      <feature xsi:type="relational:Column" xmi:id="_column_parcels_delivery_id" name="delivery_id" type="_sqlsimpletype_integer"/>
      <feature xsi:type="relational:Column" xmi:id="_column_parcels_postage" name="postage" type="_sqlsimpletype_decimal"/>
      <feature xsi:type="relational:Column" xmi:id="_column_parcels_insurance_value" name="insurance_value" type="_sqlsimpletype_decimal"/>
      <feature xsi:type="relational:Column" xmi:id="_column_parcels_weight" name="weight" type="_sqlsimpletype_decimal"/>
    </ownedElement>
    <ownedElement xsi:type="relational:Table" xmi:id="_table_parcel_types" name="parcel_types">
      <feature xsi:type="relational:Column" xmi:id="_column_parcel_types_type_id" name="type_id" type="_sqlsimpletype_integer"/>
      <feature xsi:type="relational:Column" xmi:id="_column_parcel_types_type_name" name="type_name" type="_sqlsimpletype_character_varying"/>
    </ownedElement>
    <ownedElement xsi:type="relational:Table" xmi:id="_table_defects" name="defects">
      <feature xsi:type="relational:Column" xmi:id="_column_defects_defect_id" name="defect_id" type="_sqlsimpletype_integer"/>
      <feature xsi:type="relational:Column" xmi:id="_column_defects_defect_name" name="defect_name" type="_sqlsimpletype_character_varying"/>
    </ownedElement>
    <ownedElement xsi:type="relational:Table" xmi:id="_table_addresses" name="addresses">
      <feature xsi:type="relational:Column" xmi:id="_column_addresses_address_id" name="address_id" type="_sqlsimpletype_integer"/>
      <feature xsi:type="relational:Column" xmi:id="_column_addresses_continent" name="continent" type="_sqlsimpletype_character_varying"/>
      <feature xsi:type="relational:Column" xmi:id="_column_addresses_country" name="country" type="_sqlsimpletype_character_varying"/>
      <feature xsi:type="relational:Column" xmi:id="_column_addresses_city" name="city" type="_sqlsimpletype_character_varying"/>
      <feature xsi:type="relational:Column" xmi:id="_column_addresses_postal_code" name="postal_code" type="_sqlsimpletype_character_varying"/>
      <feature xsi:type="relational:Column" xmi:id="_column_addresses_street" name="street" type="_sqlsimpletype_character_varying"/>
    </ownedElement>
  </relational:Schema>
  <rolapsrc:TableSource xmi:id="_tablesource_addresses" table="_table_addresses"/>
  <rolapsrc:TableSource xmi:id="_tablesource_parcels" table="_table_parcels"/>
  <rolapsrc:TableSource xmi:id="_tablesource_parcel_types" table="_table_parcel_types"/>
  <rolapsrc:TableSource xmi:id="_tablesource_defects" table="_table_defects"/>
  <rolaplev:Level xmi:id="_level_city" name="City" column="_column_addresses_city"/>
  <rolaplev:Level xmi:id="_level_continent" name="Continent" column="_column_addresses_continent"/>
  <rolaplev:Level xmi:id="_level_country" name="Country" column="_column_addresses_country"/>
  <rolaplev:Level xmi:id="_level_customs" name="Customs" column="_column_parcels_customs"/>
  <rolaplev:Level xmi:id="_level_defect" name="Defect" column="_column_defects_defect_id" nameColumn="_column_defects_defect_name"/>
  <rolaplev:Level xmi:id="_level_deliverable" name="Deliverable" column="_column_parcels_deliverable"/>
  <rolaplev:Level xmi:id="_level_depth" name="Depth" column="_column_parcels_depth"/>
  <rolaplev:Level xmi:id="_level_height" name="Height" column="_column_parcels_height"/>
  <rolaplev:Level xmi:id="_level_parcel_type" name="Parcel Type" column="_column_parcel_types_type_id" nameColumn="_column_parcel_types_type_name"/>
  <rolaplev:Level xmi:id="_level_postal_code" name="Postal Code" column="_column_addresses_postal_code"/>
  <rolaplev:Level xmi:id="_level_return" name="Return" column="_column_parcels_return_status"/>
  <rolaplev:Level xmi:id="_level_street" name="Street" column="_column_addresses_street"/>
  <rolaplev:Level xmi:id="_level_width" name="Width" column="_column_parcels_width"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_customs" name="Customs" allMemberName="All Customs" primaryKey="_column_parcels_customs" source="_tablesource_parcels" levels="_level_customs"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_defect" name="Defect" allMemberName="All Defects" primaryKey="_column_defects_defect_id" source="_tablesource_defects" levels="_level_defect"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_deliverable" name="Deliverable" allMemberName="All Deliverable" primaryKey="_column_parcels_deliverable" source="_tablesource_parcels" levels="_level_deliverable"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_depth" name="Depth" allMemberName="All Depths" primaryKey="_column_parcels_depth" source="_tablesource_parcels" levels="_level_depth"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_geographic_address" name="Geographic Address" allMemberName="All Addresses" primaryKey="_column_addresses_address_id" source="_tablesource_addresses" levels="_level_continent _level_country _level_city _level_postal_code _level_street"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_height" name="Height" allMemberName="All Heights" primaryKey="_column_parcels_height" source="_tablesource_parcels" levels="_level_height"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_parcel_type" name="Parcel Type" allMemberName="All Types" primaryKey="_column_parcel_types_type_id" source="_tablesource_parcel_types" levels="_level_parcel_type"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_return" name="Return" allMemberName="All Return" primaryKey="_column_parcels_return_status" source="_tablesource_parcels" levels="_level_return"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_width" name="Width" allMemberName="All Widths" primaryKey="_column_parcels_width" source="_tablesource_parcels" levels="_level_width"/>
  <rolapdim:StandardDimension xmi:id="_standarddimension_customs" name="Customs" hierarchies="_explicithierarchy_customs"/>
  <rolapdim:StandardDimension xmi:id="_standarddimension_defect" name="Defect" hierarchies="_explicithierarchy_defect"/>
  <rolapdim:StandardDimension xmi:id="_standarddimension_deliverable" name="Deliverable" hierarchies="_explicithierarchy_deliverable"/>
  <rolapdim:StandardDimension xmi:id="_standarddimension_delivery_address" name="Delivery Address" hierarchies="_explicithierarchy_geographic_address"/>
  <rolapdim:StandardDimension xmi:id="_standarddimension_depth" name="Depth" hierarchies="_explicithierarchy_depth"/>
  <rolapdim:StandardDimension xmi:id="_standarddimension_drop_off_address" name="Drop Off Address" hierarchies="_explicithierarchy_geographic_address"/>
  <rolapdim:StandardDimension xmi:id="_standarddimension_height" name="Height" hierarchies="_explicithierarchy_height"/>
  <rolapdim:StandardDimension xmi:id="_standarddimension_parcel_type" name="Parcel Type" hierarchies="_explicithierarchy_parcel_type"/>
  <rolapdim:StandardDimension xmi:id="_standarddimension_receiver_address" name="Receiver Address" hierarchies="_explicithierarchy_geographic_address"/>
  <rolapdim:StandardDimension xmi:id="_standarddimension_return" name="Return" hierarchies="_explicithierarchy_return"/>
  <rolapdim:StandardDimension xmi:id="_standarddimension_sender_address" name="Sender Address" hierarchies="_explicithierarchy_geographic_address"/>
  <rolapdim:StandardDimension xmi:id="_standarddimension_width" name="Width" hierarchies="_explicithierarchy_width"/>
  <rolapcube:PhysicalCube xmi:id="_physicalcube_parcels" name="Parcels" source="_tablesource_parcels">
    <dimensionConnectors xmi:id="_dimensionconnector_width" foreignKey="_column_parcels_width" dimension="_standarddimension_width" overrideDimensionName="Width"/>
    <dimensionConnectors xmi:id="_dimensionconnector_depth" foreignKey="_column_parcels_depth" dimension="_standarddimension_depth" overrideDimensionName="Depth"/>
    <dimensionConnectors xmi:id="_dimensionconnector_height" foreignKey="_column_parcels_height" dimension="_standarddimension_height" overrideDimensionName="Height"/>
    <dimensionConnectors xmi:id="_dimensionconnector_parcel_type" foreignKey="_column_parcels_type_id" dimension="_standarddimension_parcel_type" overrideDimensionName="Parcel Type"/>
    <dimensionConnectors xmi:id="_dimensionconnector_defect" foreignKey="_column_parcels_defect_id" dimension="_standarddimension_defect" overrideDimensionName="Defect"/>
    <dimensionConnectors xmi:id="_dimensionconnector_deliverable" foreignKey="_column_parcels_deliverable" dimension="_standarddimension_deliverable" overrideDimensionName="Deliverable"/>
    <dimensionConnectors xmi:id="_dimensionconnector_customs" foreignKey="_column_parcels_customs" dimension="_standarddimension_customs" overrideDimensionName="Customs"/>
    <dimensionConnectors xmi:id="_dimensionconnector_return" foreignKey="_column_parcels_return_status" dimension="_standarddimension_return" overrideDimensionName="Return"/>
    <dimensionConnectors xmi:id="_dimensionconnector_sender_address" foreignKey="_column_parcels_sender_id" dimension="_standarddimension_sender_address" overrideDimensionName="Sender Address"/>
    <dimensionConnectors xmi:id="_dimensionconnector_receiver_address" foreignKey="_column_parcels_receiver_id" dimension="_standarddimension_receiver_address" overrideDimensionName="Receiver Address"/>
    <dimensionConnectors xmi:id="_dimensionconnector_drop_off_address" foreignKey="_column_parcels_drop_off_id" dimension="_standarddimension_drop_off_address" overrideDimensionName="Drop Off Address"/>
    <dimensionConnectors xmi:id="_dimensionconnector_delivery_address" foreignKey="_column_parcels_delivery_id" dimension="_standarddimension_delivery_address" overrideDimensionName="Delivery Address"/>
    <measureGroups xmi:id="_measuregroup">
      <measures xsi:type="rolapmeas:CountMeasure" xmi:id="_countmeasure_parcel_count" name="Parcel Count" formatString="#,###" column="_column_parcels_parcel_id"/>
      <measures xsi:type="rolapmeas:SumMeasure" xmi:id="_summeasure_postage_sum" name="Postage Sum" formatString="#,##0.00" column="_column_parcels_postage"/>
      <measures xsi:type="rolapmeas:SumMeasure" xmi:id="_summeasure_insurance_value_sum" name="Insurance Value Sum" formatString="#,##0.00" column="_column_parcels_insurance_value"/>
      <measures xsi:type="rolapmeas:MinMeasure" xmi:id="_minmeasure_weight_min" name="Weight Min" formatString="#,##0.00" column="_column_parcels_weight"/>
      <measures xsi:type="rolapmeas:MaxMeasure" xmi:id="_maxmeasure_weight_max" name="Weight Max" formatString="#,##0.00" column="_column_parcels_weight"/>
      <measures xsi:type="rolapmeas:AvgMeasure" xmi:id="_avgmeasure_weight_avg" name="Weight Avg" formatString="#,##0.00" column="_column_parcels_weight"/>
    </measureGroups>
  </rolapcube:PhysicalCube>
</xmi:XMI>

Tutorial Zip

This file contains the data-tables as csv and the mapping as xmi file.

Download Zip File