Eclipse Daanse

Appearance

Daanse Tutorial - Level If Blank Name Multiple ​

A basic OLAP schema with a level with property Level has attribute HideMemberIf.IF_BLANK_NAME Catalog has two cubes with one level with HideMemberIf atribut and with multiple levels. Attribute HideMemberIf.IF_BLANK_NAME uses for multiple levels

Database Schema ​

The cube defined in this example is based on a 4 tables that stores all the data.

  • The phisical table is named Fact_Multiple uses for Cube1 and contains two columns: DIM_KEY and VALUE. The DIM_KEY column serves as a discriminator, while the VALUE column contains the measurements to be aggregated.
  • The phisical table is named Level_1_Multiple uses for Level1 and contains 2 columns: KEY, NAME .
  • The phisical table is named Level_2_Multiple uses for Level2 and contains 3 columns: KEY, NAME, L1_KEY.
  • The phisical table is named Level_3_Multiple uses for Level2 and contains 3 columns: KEY, NAME, L2_KEY.
xml
<relational:Schema xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"  xmlns:relational="http://www.omg.org/spec/CWM/1.1/resource/relational" xmi:id="_schema">
  <ownedElement xsi:type="relational:Table" xmi:id="_table_fact_multiple" name="Fact_Multiple">
    <feature xsi:type="relational:Column" xmi:id="_column_fact_multiple_dim_key" name="DIM_KEY"/>
    <feature xsi:type="relational:Column" xmi:id="_column_fact_multiple_value" name="VALUE"/>
  </ownedElement>
  <ownedElement xsi:type="relational:Table" xmi:id="_table_level_1_multiple" name="Level_1_Multiple">
    <feature xsi:type="relational:Column" xmi:id="_column_level_1_multiple_key" name="KEY"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_1_multiple_name" name="NAME"/>
  </ownedElement>
  <ownedElement xsi:type="relational:Table" xmi:id="_table_level_2_multiple" name="Level_2_Multiple">
    <feature xsi:type="relational:Column" xmi:id="_column_level_2_multiple_key" name="KEY"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_2_multiple_name" name="NAME"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_2_multiple_l1_key" name="L1_KEY"/>
  </ownedElement>
  <ownedElement xsi:type="relational:Table" xmi:id="_table_level_3_multiple" name="Level_3_Multiple">
    <feature xsi:type="relational:Column" xmi:id="_column_level_3_multiple_key" name="KEY"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_3_multiple_name" name="NAME"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_3_multiple_l2_key" name="L2_KEY"/>
  </ownedElement>
</relational:Schema>

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

Query Fact ​

The bridge between the cube and the database is the query element. In this case, it is a TableQuery, as it directly references the physical table Fact_Multiple.

xml
<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:rolapsrc="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/database/source">
  <rolapsrc:TableSource xmi:id="_tablesource_fact_multiple" table="_table_fact_multiple"/>
  <relational:Table xmi:id="_table_fact_multiple" name="Fact_Multiple">
    <feature xsi:type="relational:Column" xmi:id="_column_fact_multiple_dim_key" name="DIM_KEY"/>
    <feature xsi:type="relational:Column" xmi:id="_column_fact_multiple_value" name="VALUE"/>
  </relational:Table>
</xmi:XMI>

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

Query Level1 ​

The bridge between the cube and the database is the query element. In this case, it is a TableQuery, as it directly references the physical table Level_1_Multiple.

xml
<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:rolapsrc="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/database/source">
  <rolapsrc:TableSource xmi:id="_tablesource_level_1_multiple" table="_table_level_1_multiple"/>
  <relational:Table xmi:id="_table_level_1_multiple" name="Level_1_Multiple">
    <feature xsi:type="relational:Column" xmi:id="_column_level_1_multiple_key" name="KEY"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_1_multiple_name" name="NAME"/>
  </relational:Table>
</xmi:XMI>

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

Query Level2 ​

The bridge between the cube and the database is the query element. In this case, it is a TableQuery, as it directly references the physical table Level_2_Multiple.

xml
<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:rolapsrc="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/database/source">
  <rolapsrc:TableSource xmi:id="_tablesource_level_2_multiple" table="_table_level_2_multiple"/>
  <relational:Table xmi:id="_table_level_2_multiple" name="Level_2_Multiple">
    <feature xsi:type="relational:Column" xmi:id="_column_level_2_multiple_key" name="KEY"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_2_multiple_name" name="NAME"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_2_multiple_l1_key" name="L1_KEY"/>
  </relational:Table>
</xmi:XMI>

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

Query Level3 ​

The bridge between the cube and the database is the query element. In this case, it is a TableQuery, as it directly references the physical table Level_3_Multiple.

xml
<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:rolapsrc="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/database/source">
  <rolapsrc:TableSource xmi:id="_tablesource_level_3_multiple" table="_table_level_3_multiple"/>
  <relational:Table xmi:id="_table_level_3_multiple" name="Level_3_Multiple">
    <feature xsi:type="relational:Column" xmi:id="_column_level_3_multiple_key" name="KEY"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_3_multiple_name" name="NAME"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_3_multiple_l2_key" name="L2_KEY"/>
  </relational:Table>
</xmi:XMI>

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

Query Join Right ​

The JoinSource specifies which TableQueries should be joined. It also defines the columns in each table that are used for the join:

  • In the lower-level table (Level_2_Multiple), the join uses the foreign key L1_KEY.
  • In the upper-level table (Level_1_Multiple), the join uses the primary key KEY.
xml
<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:rolapsrc="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/database/source">
  <rolapsrc:JoinSource xmi:id="_joinsource">
    <left xmi:id="_joinedqueryelement_l1_key" key="_column_level_2_multiple_l1_key" source="_tablesource_level_2_multiple"/>
    <right xmi:id="_joinedqueryelement_key" key="_column_level_1_multiple_key" source="_tablesource_level_1_multiple"/>
  </rolapsrc:JoinSource>
  <rolapsrc:TableSource xmi:id="_tablesource_level_2_multiple" table="_table_level_2_multiple"/>
  <relational:Table xmi:id="_table_level_2_multiple" name="Level_2_Multiple">
    <feature xsi:type="relational:Column" xmi:id="_column_level_2_multiple_key" name="KEY"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_2_multiple_name" name="NAME"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_2_multiple_l1_key" name="L1_KEY"/>
  </relational:Table>
  <rolapsrc:TableSource xmi:id="_tablesource_level_1_multiple" table="_table_level_1_multiple"/>
  <relational:Table xmi:id="_table_level_1_multiple" name="Level_1_Multiple">
    <feature xsi:type="relational:Column" xmi:id="_column_level_1_multiple_key" name="KEY"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_1_multiple_name" name="NAME"/>
  </relational:Table>
</xmi:XMI>

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

Query Join ​

The JoinSource specifies which TableQueries should be joined. It also defines the columns in each table that are used for the join:

  • In the lower-level table (Level_3_Multiple), the join uses the foreign key L2_KEY.
  • In the upper-level queryJoinRight, the join uses the primary key KEY from Level_2_Multiple.
xml
<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:rolapsrc="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/database/source">
  <rolapsrc:JoinSource xmi:id="_joinsource">
    <left xmi:id="_joinedqueryelement_l2_key" key="_column_level_3_multiple_l2_key" source="_tablesource_level_3_multiple"/>
    <right xmi:id="_joinedqueryelement_key" key="_column_level_2_multiple_key" source="_joinsource_1"/>
  </rolapsrc:JoinSource>
  <rolapsrc:TableSource xmi:id="_tablesource_level_2_multiple" table="_table_level_2_multiple"/>
  <relational:Table xmi:id="_table_level_2_multiple" name="Level_2_Multiple">
    <feature xsi:type="relational:Column" xmi:id="_column_level_2_multiple_key" name="KEY"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_2_multiple_name" name="NAME"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_2_multiple_l1_key" name="L1_KEY"/>
  </relational:Table>
  <rolapsrc:TableSource xmi:id="_tablesource_level_3_multiple" table="_table_level_3_multiple"/>
  <rolapsrc:JoinSource xmi:id="_joinsource_1">
    <left xmi:id="_joinedqueryelement_l1_key" key="_column_level_2_multiple_l1_key" source="_tablesource_level_2_multiple"/>
    <right xmi:id="_joinedqueryelement_key_1" key="_column_level_1_multiple_key" source="_tablesource_level_1_multiple"/>
  </rolapsrc:JoinSource>
  <rolapsrc:TableSource xmi:id="_tablesource_level_1_multiple" table="_table_level_1_multiple"/>
  <relational:Table xmi:id="_table_level_3_multiple" name="Level_3_Multiple">
    <feature xsi:type="relational:Column" xmi:id="_column_level_3_multiple_key" name="KEY"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_3_multiple_name" name="NAME"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_3_multiple_l2_key" name="L2_KEY"/>
  </relational:Table>
  <relational:Table xmi:id="_table_level_1_multiple" name="Level_1_Multiple">
    <feature xsi:type="relational:Column" xmi:id="_column_level_1_multiple_key" name="KEY"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_1_multiple_name" name="NAME"/>
  </relational:Table>
</xmi:XMI>

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

DimensionMembersHiddenMultipleLevels ​

The Dimension has only one hierarchy.

xml
<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_dimensionmembershiddenmultiplelevels" name="DimensionMembersHiddenMultipleLevels" hierarchies="_explicithierarchy_hierarchy1"/>
  <rolaplev:Level xmi:id="_level_level2" name="Level2" hideMemberIf="IfBlankName">
    <column href="_column_level_2_multiple_key"/>
    <nameColumn href="_column_level_2_multiple_name"/>
  </rolaplev:Level>
  <rolapsrc:TableSource xmi:id="_tablesource_level_2_multiple" table="_table_level_2_multiple"/>
  <rolaplev:Level xmi:id="_level_level1" name="Level1">
    <column href="_column_level_1_multiple_key"/>
    <nameColumn href="_column_level_1_multiple_name"/>
  </rolaplev:Level>
  <rolapsrc:JoinSource xmi:id="_joinsource">
    <left xmi:id="_joinedqueryelement_l1_key" key="_column_level_2_multiple_l1_key" source="_tablesource_level_2_multiple"/>
    <right xmi:id="_joinedqueryelement_key" source="_tablesource_level_1_multiple">
      <key href="_column_level_1_multiple_key"/>
    </right>
  </rolapsrc:JoinSource>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_hierarchy1" name="Hierarchy1" primaryKey="_column_level_3_multiple_key" source="_joinsource_1" levels="_level_level1 _level_level2 _level_level3"/>
  <rolapsrc:JoinSource xmi:id="_joinsource_1">
    <left xmi:id="_joinedqueryelement_l2_key" key="_column_level_3_multiple_l2_key" source="_tablesource_level_3_multiple"/>
    <right xmi:id="_joinedqueryelement_key_1" key="_column_level_2_multiple_key" source="_joinsource"/>
  </rolapsrc:JoinSource>
  <relational:Table xmi:id="_table_level_1_multiple" name="Level_1_Multiple">
    <feature xsi:type="relational:Column" xmi:id="_column_level_1_multiple_key" name="KEY"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_1_multiple_name" name="NAME"/>
  </relational:Table>
  <relational:Table xmi:id="_table_level_3_multiple" name="Level_3_Multiple">
    <feature xsi:type="relational:Column" xmi:id="_column_level_3_multiple_key" name="KEY"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_3_multiple_name" name="NAME"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_3_multiple_l2_key" name="L2_KEY"/>
  </relational:Table>
  <relational:Table xmi:id="_table_level_2_multiple" name="Level_2_Multiple">
    <feature xsi:type="relational:Column" xmi:id="_column_level_2_multiple_key" name="KEY"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_2_multiple_name" name="NAME"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_2_multiple_l1_key" name="L1_KEY"/>
  </relational:Table>
  <rolapsrc:TableSource xmi:id="_tablesource_level_3_multiple" table="_table_level_3_multiple"/>
  <rolaplev:Level xmi:id="_level_level3" name="Level3" column="_column_level_3_multiple_key" hideMemberIf="IfBlankName" nameColumn="_column_level_3_multiple_name"/>
  <rolapsrc:TableSource xmi:id="_tablesource_level_1_multiple" table="_table_level_1_multiple"/>
</xmi:XMI>

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

Hierarchy1 ​

This hierarchy consists two levels Level1 and Level2.

  • The primaryKey attribute specifies the column that contains the primary key of the hierarchy.
  • The query attribute references the query used to retrieve the data for the hierarchy.
xml
<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: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">
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_hierarchy1" name="Hierarchy1" primaryKey="_column_level_3_multiple_key" source="_joinsource_1" levels="_level_level1 _level_level2 _level_level3"/>
  <rolaplev:Level xmi:id="_level_level2" name="Level2" column="_column_level_2_multiple_key" hideMemberIf="IfBlankName" nameColumn="_column_level_2_multiple_name"/>
  <rolapsrc:TableSource xmi:id="_tablesource_level_2_multiple" table="_table_level_2_multiple"/>
  <rolaplev:Level xmi:id="_level_level1" name="Level1" column="_column_level_1_multiple_key" nameColumn="_column_level_1_multiple_name"/>
  <rolapsrc:JoinSource xmi:id="_joinsource">
    <left xmi:id="_joinedqueryelement_l1_key" key="_column_level_2_multiple_l1_key" source="_tablesource_level_2_multiple"/>
    <right xmi:id="_joinedqueryelement_key" key="_column_level_1_multiple_key" source="_tablesource_level_1_multiple"/>
  </rolapsrc:JoinSource>
  <rolapsrc:JoinSource xmi:id="_joinsource_1">
    <left xmi:id="_joinedqueryelement_l2_key" key="_column_level_3_multiple_l2_key" source="_tablesource_level_3_multiple"/>
    <right xmi:id="_joinedqueryelement_key_1" key="_column_level_2_multiple_key" source="_joinsource"/>
  </rolapsrc:JoinSource>
  <relational:Table xmi:id="_table_level_1_multiple" name="Level_1_Multiple">
    <feature xsi:type="relational:Column" xmi:id="_column_level_1_multiple_key" name="KEY"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_1_multiple_name" name="NAME"/>
  </relational:Table>
  <relational:Table xmi:id="_table_level_3_multiple" name="Level_3_Multiple">
    <feature xsi:type="relational:Column" xmi:id="_column_level_3_multiple_key" name="KEY"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_3_multiple_name" name="NAME"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_3_multiple_l2_key" name="L2_KEY"/>
  </relational:Table>
  <relational:Table xmi:id="_table_level_2_multiple" name="Level_2_Multiple">
    <feature xsi:type="relational:Column" xmi:id="_column_level_2_multiple_key" name="KEY"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_2_multiple_name" name="NAME"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_2_multiple_l1_key" name="L1_KEY"/>
  </relational:Table>
  <rolapsrc:TableSource xmi:id="_tablesource_level_3_multiple" table="_table_level_3_multiple"/>
  <rolaplev:Level xmi:id="_level_level3" name="Level3" column="_column_level_3_multiple_key" hideMemberIf="IfBlankName" nameColumn="_column_level_3_multiple_name"/>
  <rolapsrc:TableSource xmi:id="_tablesource_level_1_multiple" table="_table_level_1_multiple"/>
</xmi:XMI>

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

Level1 ​

The Level uses the column attribute to specify the primary key KEY from Level_1_Multiple. Additionally, it defines the nameColumn NAME from Level_1_Multiple attribute to specify the column that contains the name of the level.

xml
<rolaplev:Level xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:rolaplev="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy/level" xmi:id="_level_level1" name="Level1">
  <column href="_column_level_1_multiple_key"/>
  <nameColumn href="_column_level_1_multiple_name"/>
</rolaplev:Level>

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

Level2 ​

The Level uses the column attribute to specify the primary key KEY from Level_2_Multiple. Additionally, it defines the nameColumn NAME from Level_2_Multiple attribute to specify the column that contains the name of the level. Level has attribute HideMemberIf.IF_PARENTS_NAME Hide members whose name matches their parent member's name. Eliminates redundant display where child members have identical names to their parents in the hierarchy.

xml
<rolaplev:Level xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:rolaplev="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy/level" xmi:id="_level_level2" name="Level2" hideMemberIf="IfBlankName">
  <column href="_column_level_2_multiple_key"/>
  <nameColumn href="_column_level_2_multiple_name"/>
</rolaplev:Level>

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

Level3 ​

The Level uses the column attribute to specify the primary key KEY from Level_3_Multiple. Additionally, it defines the nameColumn NAME from Level_3_Multiple attribute to specify the column that contains the name of the level. Level has attribute HideMemberIf.IF_PARENTS_NAME Hide members whose name matches their parent member's name. Eliminates redundant display where child members have identical names to their parents in the hierarchy.

xml
<rolaplev:Level xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:rolaplev="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/dimension/hierarchy/level" xmi:id="_level_level3" name="Level3" hideMemberIf="IfBlankName">
  <column href="_column_level_3_multiple_key"/>
  <nameColumn href="_column_level_3_multiple_name"/>
</rolaplev:Level>

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

Measure1 ​

    Measure1 use Fact table VALUE column with sum aggregation in Cube.
xml
<rolapmeas:SumMeasure xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:rolapmeas="https://www.daanse.org/spec/org.eclipse.daanse.rolap.mapping/olap/cube/measure" xmi:id="_summeasure_measure" name="Measure">
  <column href="_column_fact_multiple_value"/>
</rolapmeas:SumMeasure>

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

Cube ​

In this example uses cube with fact table Fact as data.

xml
<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: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">
  <rolapcube:PhysicalCube xmi:id="_physicalcube_hiddenmembersmultiplelevels" name="HiddenMembersMultipleLevels" source="_tablesource_fact_multiple">
    <dimensionConnectors xmi:id="_dimensionconnector_dimensionmembershiddenmultiplelevels" foreignKey="_column_fact_multiple_dim_key" dimension="_standarddimension_dimensionmembershiddenmultiplelevels" overrideDimensionName="DimensionMembersHiddenMultipleLevels"/>
    <measureGroups xmi:id="_measuregroup">
      <measures xsi:type="rolapmeas:SumMeasure" xmi:id="_summeasure_measure" name="Measure" column="_column_fact_multiple_value"/>
    </measureGroups>
  </rolapcube:PhysicalCube>
  <rolaplev:Level xmi:id="_level_level2" name="Level2" hideMemberIf="IfBlankName">
    <column href="_column_level_2_multiple_key"/>
    <nameColumn href="_column_level_2_multiple_name"/>
  </rolaplev:Level>
  <rolapsrc:TableSource xmi:id="_tablesource_level_2_multiple">
    <table href="_table_level_2_multiple"/>
  </rolapsrc:TableSource>
  <rolaplev:Level xmi:id="_level_level1" name="Level1">
    <column href="_column_level_1_multiple_key"/>
    <nameColumn href="_column_level_1_multiple_name"/>
  </rolaplev:Level>
  <rolapsrc:JoinSource xmi:id="_joinsource">
    <left xmi:id="_joinedqueryelement_l1_key" source="_tablesource_level_2_multiple">
      <key href="_column_level_2_multiple_l1_key"/>
    </left>
    <right xmi:id="_joinedqueryelement_key" source="_tablesource_level_1_multiple">
      <key href="_column_level_1_multiple_key"/>
    </right>
  </rolapsrc:JoinSource>
  <rolapdim:StandardDimension xmi:id="_standarddimension_dimensionmembershiddenmultiplelevels" name="DimensionMembersHiddenMultipleLevels" hierarchies="_explicithierarchy_hierarchy1"/>
  <rolapsrc:TableSource xmi:id="_tablesource_fact_multiple" table="_table_fact_multiple"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_hierarchy1" name="Hierarchy1" primaryKey="_column_level_3_multiple_key" source="_joinsource_1" levels="_level_level1 _level_level2 _level_level3"/>
  <rolapsrc:JoinSource xmi:id="_joinsource_1">
    <left xmi:id="_joinedqueryelement_l2_key" key="_column_level_3_multiple_l2_key" source="_tablesource_level_3_multiple"/>
    <right xmi:id="_joinedqueryelement_key_1" source="_joinsource">
      <key href="_column_level_2_multiple_key"/>
    </right>
  </rolapsrc:JoinSource>
  <relational:Table xmi:id="_table_level_3_multiple" name="Level_3_Multiple">
    <feature xsi:type="relational:Column" xmi:id="_column_level_3_multiple_key" name="KEY"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_3_multiple_name" name="NAME"/>
    <feature xsi:type="relational:Column" xmi:id="_column_level_3_multiple_l2_key" name="L2_KEY"/>
  </relational:Table>
  <relational:Table xmi:id="_table_fact_multiple" name="Fact_Multiple">
    <feature xsi:type="relational:Column" xmi:id="_column_fact_multiple_dim_key" name="DIM_KEY"/>
    <feature xsi:type="relational:Column" xmi:id="_column_fact_multiple_value" name="VALUE"/>
  </relational:Table>
  <rolapsrc:TableSource xmi:id="_tablesource_level_3_multiple" table="_table_level_3_multiple"/>
  <rolaplev:Level xmi:id="_level_level3" name="Level3" column="_column_level_3_multiple_key" hideMemberIf="IfBlankName" nameColumn="_column_level_3_multiple_name"/>
  <rolapsrc:TableSource xmi:id="_tablesource_level_1_multiple">
    <table href="_table_level_1_multiple"/>
  </rolapsrc:TableSource>
</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
<?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_level_2_multiple_name _column_level_1_multiple_name _column_level_3_multiple_name" typeNumber="12"/>
  <relational:SQLSimpleType xmi:id="_sqlsimpletype_integer" name="INTEGER" structuralFeature="_column_level_2_multiple_l1_key _column_fact_multiple_dim_key _column_level_1_multiple_key _column_level_2_multiple_key _column_level_3_multiple_key _column_level_3_multiple_l2_key _column_fact_multiple_value" typeNumber="4"/>
  <rolapcat:Catalog xmi:id="_catalog_level_if_blank_name_multiple" description="Multiple levels handling blank names" name="Daanse Tutorial - Level If Blank Name Multiple" cubes="_physicalcube_hiddenmembersmultiplelevels" dbschemas="_schema"/>
  <relational:Schema xmi:id="_schema">
    <ownedElement xsi:type="relational:Table" xmi:id="_table_fact_multiple" name="Fact_Multiple">
      <feature xsi:type="relational:Column" xmi:id="_column_fact_multiple_dim_key" name="DIM_KEY" type="_sqlsimpletype_integer"/>
      <feature xsi:type="relational:Column" xmi:id="_column_fact_multiple_value" name="VALUE" type="_sqlsimpletype_integer"/>
    </ownedElement>
    <ownedElement xsi:type="relational:Table" xmi:id="_table_level_1_multiple" name="Level_1_Multiple">
      <feature xsi:type="relational:Column" xmi:id="_column_level_1_multiple_key" name="KEY" type="_sqlsimpletype_integer"/>
      <feature xsi:type="relational:Column" xmi:id="_column_level_1_multiple_name" name="NAME" type="_sqlsimpletype_character_varying"/>
    </ownedElement>
    <ownedElement xsi:type="relational:Table" xmi:id="_table_level_2_multiple" name="Level_2_Multiple">
      <feature xsi:type="relational:Column" xmi:id="_column_level_2_multiple_key" name="KEY" type="_sqlsimpletype_integer"/>
      <feature xsi:type="relational:Column" xmi:id="_column_level_2_multiple_name" name="NAME" type="_sqlsimpletype_character_varying"/>
      <feature xsi:type="relational:Column" xmi:id="_column_level_2_multiple_l1_key" name="L1_KEY" type="_sqlsimpletype_integer"/>
    </ownedElement>
    <ownedElement xsi:type="relational:Table" xmi:id="_table_level_3_multiple" name="Level_3_Multiple">
      <feature xsi:type="relational:Column" xmi:id="_column_level_3_multiple_key" name="KEY" type="_sqlsimpletype_integer"/>
      <feature xsi:type="relational:Column" xmi:id="_column_level_3_multiple_name" name="NAME" type="_sqlsimpletype_character_varying"/>
      <feature xsi:type="relational:Column" xmi:id="_column_level_3_multiple_l2_key" name="L2_KEY" type="_sqlsimpletype_integer"/>
    </ownedElement>
  </relational:Schema>
  <rolapsrc:TableSource xmi:id="_tablesource_level_3_multiple" table="_table_level_3_multiple"/>
  <rolapsrc:TableSource xmi:id="_tablesource_level_1_multiple" table="_table_level_1_multiple"/>
  <rolapsrc:TableSource xmi:id="_tablesource_fact_multiple" table="_table_fact_multiple"/>
  <rolapsrc:TableSource xmi:id="_tablesource_level_2_multiple" table="_table_level_2_multiple"/>
  <rolapsrc:JoinSource xmi:id="_joinsource">
    <left xmi:id="_joinedqueryelement_l1_key" key="_column_level_2_multiple_l1_key" source="_tablesource_level_2_multiple"/>
    <right xmi:id="_joinedqueryelement_key_1" key="_column_level_1_multiple_key" source="_tablesource_level_1_multiple"/>
  </rolapsrc:JoinSource>
  <rolapsrc:JoinSource xmi:id="_joinsource_1">
    <left xmi:id="_joinedqueryelement_l2_key" key="_column_level_3_multiple_l2_key" source="_tablesource_level_3_multiple"/>
    <right xmi:id="_joinedqueryelement_key" key="_column_level_2_multiple_key" source="_joinsource"/>
  </rolapsrc:JoinSource>
  <rolaplev:Level xmi:id="_level_level1" name="Level1" column="_column_level_1_multiple_key" nameColumn="_column_level_1_multiple_name"/>
  <rolaplev:Level xmi:id="_level_level2" name="Level2" column="_column_level_2_multiple_key" hideMemberIf="IfBlankName" nameColumn="_column_level_2_multiple_name"/>
  <rolaplev:Level xmi:id="_level_level3" name="Level3" column="_column_level_3_multiple_key" hideMemberIf="IfBlankName" nameColumn="_column_level_3_multiple_name"/>
  <rolaphier:ExplicitHierarchy xmi:id="_explicithierarchy_hierarchy1" name="Hierarchy1" primaryKey="_column_level_3_multiple_key" source="_joinsource_1" levels="_level_level1 _level_level2 _level_level3"/>
  <rolapdim:StandardDimension xmi:id="_standarddimension_dimensionmembershiddenmultiplelevels" name="DimensionMembersHiddenMultipleLevels" hierarchies="_explicithierarchy_hierarchy1"/>
  <rolapcube:PhysicalCube xmi:id="_physicalcube_hiddenmembersmultiplelevels" name="HiddenMembersMultipleLevels" source="_tablesource_fact_multiple">
    <dimensionConnectors xmi:id="_dimensionconnector_dimensionmembershiddenmultiplelevels" foreignKey="_column_fact_multiple_dim_key" dimension="_standarddimension_dimensionmembershiddenmultiplelevels" overrideDimensionName="DimensionMembersHiddenMultipleLevels"/>
    <measureGroups xmi:id="_measuregroup">
      <measures xsi:type="rolapmeas:SumMeasure" xmi:id="_summeasure_measure" name="Measure" column="_column_fact_multiple_value"/>
    </measureGroups>
  </rolapcube:PhysicalCube>
</xmi:XMI>

Tutorial Zip ​

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

Download Zip File

Released under the Eclipse Public License 2.0

Copyright © 2025 - Eclipse-Daanse