Daanse Tutorial - Measure Inline Table

Data cube with InlineTable. InlineTable represents a table with data embedded directly in the schema definition rather than referencing external database tables. InlineTable allows small lookup tables, dimension data, or test data to be included directly in the OLAP schema, eliminating the need for separate database tables for static reference data.

Database Schema

DatabaseSchema includes InlineTable with data embedded directly in the schema definition. InlineTable, named Fact, contains two columns: KEY and VALUE.

<roma:DatabaseSchema   id="_databaseSchema_inlinetable">
  <tables xsi:type="roma:InlineTable" id="_table_fact" name="Fact">
    <columns xsi:type="roma:PhysicalColumn" id="_column_fact_key" name="KEY"/>
    <columns xsi:type="roma:PhysicalColumn" id="_column_fact_value" name="VALUE" type="Integer"/>
    <rows>
      <rowValues column="_column_fact_key" value="A"/>
      <rowValues column="_column_fact_value" value="100.5"/>
    </rows>
  </tables>
</roma:DatabaseSchema>

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

Query

This example uses a InlineTableQuery, as it directly references the InlineTable table Fact.

<roma:InlineTableQuery  id="_query_fact" alias="Fact" table="_table_fact"/>

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

Measure-Sum

    Measure use InlineTable column with sum aggregation.

<roma:SumMeasure  id="_measure-sum" name="Measure-Sum" column="_column_fact_value"/>

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

Cube with Inline Table

In this example uses cube with InlineTable as data.

<roma:PhysicalCube   id="_cube" name="Cube" query="roma:InlineTableQuery _query_fact">
  <measureGroups>
    <measures xsi:type="roma:SumMeasure" id="_measure-sum" name="Measure-Sum" column="_column_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:InlineTableQuery id="_query_fact" alias="Fact" table="_table_fact"/>
  <roma:Catalog description="Measure with inline table data" name="Daanse Tutorial - Measure Inline Table" cubes="_cube" dbschemas="_databaseSchema_inlinetable"/>
  <roma:DatabaseSchema id="_databaseSchema_inlinetable">
    <tables xsi:type="roma:InlineTable" id="_table_fact" name="Fact">
      <columns xsi:type="roma:PhysicalColumn" id="_column_fact_key" name="KEY"/>
      <columns xsi:type="roma:PhysicalColumn" id="_column_fact_value" name="VALUE" type="Integer"/>
      <rows>
        <rowValues column="_column_fact_key" value="A"/>
        <rowValues column="_column_fact_value" value="100.5"/>
      </rows>
    </tables>
  </roma:DatabaseSchema>
  <roma:PhysicalCube id="_cube" name="Cube" query="_query_fact">
    <measureGroups>
      <measures xsi:type="roma:SumMeasure" id="_measure-sum" name="Measure-Sum" column="_column_fact_value"/>
    </measureGroups>
  </roma:PhysicalCube>
</xmi:XMI>

Tutorial Zip

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

Download Zip File