JRapid BI simple example

Main_part.xml

<entity label="Store" menu="Menu" name="Store">
        <property display="primary" label="Name" name="name"/>
    </entity>

    <entity crosstab="crosstab" label="Sale" menu="Menu" name="Sale">
        <property dimension="row" display="primary" label="Sale Date" name="saleDate" type="date"/>
        <property dimension="column" display="primary" entity="Store" label="Store" name="store"/>
        <property display="primary" label="Total Amount" name="totalAmount" type="double"/>
        <property childproperty="sale" collection="set" embedded="inline" entity="SaleDetail" extendable="extendable" label="Detail" name="lines"/>
    </entity>

    <entity label="Product" menu="Menu" name="Product">
        <property display="primary" label="Name" name="name"/>
    </entity>

    <entity label="Sale Detail" name="SaleDetail">
        <property entity="Sale" label="Sale" name="sale"/>
        <property label="Quantity" name="quantity" type="integer"/>
        <property entity="Product" label="Product" name="product"/>
        <property label="Price" name="price" type="double"/>
    </entity>