All pastes #823445 Raw Edit

Something

public text v1 · immutable
·published 2007-12-19 11:25 UTC
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>