agent_trans

<?xml version="1.0"?>
<Schema name="Phoenix" metamodelVersion="4.0">
 <PhysicalSchema>
    <Table name='AGENTS'>
        <Key>
            <Column name='A_ID'/>
        </Key>
    </Table>
    <Table name='TRANSACTIONS'/>
    <Table name='AG_TER_PRO'/>
 </PhysicalSchema>

 <Dimension name='Agent Details' table='AGENTS' key='Agent Id'>
    <Attributes>
        <Attribute name='Agent Id' keyColumn='A_ID' hasHierarchy='false'/>
        <Attribute name='Agent Name' keyColumn='A_NAME' hasHierarchy='false'/>
        <Attribute name='Agent Role' keyColumn='A_ROLE' hasHierarchy='false'/>
        <Attribute name='Agent Department' keyColumn='A_DEPARTMENT' hasHierarchy='false'/>
    </Attributes>
    <Hierarchies>
        <Hierarchy name="Agent Attributes" allMemberName="All Agents">
            <Level attribute="Agent Name"/>
        </Hierarchy>
    </Hierarchies>
 </Dimension>

 <Cube name="Agent Transactions">
  <Dimensions>
      <Dimension source="Agent Details"/>
  </Dimensions>
  <MeasureGroups>
    <MeasureGroup name="Transactions" table='TRANSACTIONS'>
        <Measures>
            <Measure name='Total Sales' column='TOTAL_SALES' aggregator='sum' formatString='#,###.00' />
            <Measure name='Total Expenses' column='TOTAL_EXPENSES' aggregator='sum' formatString='#,###.00'/>
        </Measures>
        <DimensionLinks>
            <ForeignKeyLink dimension='Agent Details' foreignKeyColumn='AGENT_ID'/>
        </DimensionLinks>
    </MeasureGroup>

    <MeasureGroup table='AG_TER_PRO' type='aggregate'>
        <Measures>
            <MeasureRef name='Total Sales' aggColumn='SUM_TOTAL_SALES'/>
            <MeasureRef name='Total Expenses' aggColumn='SUM_TOTAL_EXPENSES'/>
        </Measures>
        <DimensionLinks>
            <ForeignKeyLink dimension='Agent Details' foreignKeyColumn='AGENT_ID'/>
        </DimensionLinks>
    </MeasureGroup>
  </MeasureGroups>
 </Cube>
</Schema>