rendered paste body<?xml version="1.0" encoding="UTF-8"?>
<Schema name="MonthlyBaseValues">
<Cube name="MonthlyBaseValues">
<Table name="view_basevalues"/>
<Dimension name="Group">
<Hierarchy name="Group" hasAll="true" allMemberName="All group">
<Table name="view_basevalues"/>
<Level name="Group" table="view_basevalues" column="GROUP" uniqueMembers="true"/>
<Level name="tradcode" table="view_basevalues" column="BRANCH_NAME" ordinalColumn="tradcode" uniqueMembers="false"/>
<Level name="movement" table="view_basevalues" column="Type" uniqueMembers="false" ordinalColumn="movement"/>
</Hierarchy>
</Dimension>
<Measure name="Cost" column="cost" aggregator="sum" datatype="Numeric" formatString="#,###,##0"/>
<Measure name="Value" column="value" aggregator="sum" datatype="Numeric" formatString="#,###,##0"/>
<CalculatedMember name="Profit" dimension="Measures">
<formula>
((([Measures].[Value] - [Measures].[Cost])))
</formula>
<CalculatedMemberProperty name="FORMAT_STRING" value="#,###,##0"/>
</CalculatedMember>
</Cube>
</Schema>