自己写的第一个Schema文件

<Schema name="FinSchema" description="财务模式" measuresCaption="财务模式">

  <Cube name="BalanceCube" caption="资产负债Cube" visible="true" description="资产负债Cube" cache="true" enabled="true">

    <Table name="资产负债视图" schema="dbo">

    </Table>

    <Dimension type="StandardDimension" visible="true" foreignKey="组织编码" highCardinality="false" name="组织" caption="组织编码">

      <Hierarchy visible="true" hasAll="true" allMemberName="所有组织" allMemberCaption="所有组织" primaryKey="组织编码">

        <Table name="资产负债视图" alias="temp1">

        </Table>

        <Level name="组织编码" visible="true" column="组织编码" nameColumn="组织名称" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">

        </Level>

        <Level name="组织名称" visible="true" column="组织名称" type="String" uniqueMembers="false">

        </Level>

      </Hierarchy>

    </Dimension>

    <Dimension type="StandardDimension" visible="true" foreignKey="年" name="年">

      <Hierarchy name="YearHierarchy" visible="true" hasAll="true" allMemberName="所有年" allMemberCaption="所有年" primaryKey="年">

        <Table name="资产负债视图" alias="Temp2">

        </Table>

        <Level name="年" visible="true" column="年" type="Integer" uniqueMembers="false">

        </Level>

      </Hierarchy>

    </Dimension>

    <Dimension type="StandardDimension" visible="true" foreignKey="期间" name="期间">

      <Hierarchy name="MonthHierarchy" visible="true" hasAll="true" allMemberName="所有期间" allMemberCaption="所有期间" primaryKey="期间">

        <Table name="资产负债视图" alias="Temp3">

        </Table>

        <Level name="期间" visible="true" column="期间" type="Integer" uniqueMembers="false">

        </Level>

      </Hierarchy>

    </Dimension>

    <Dimension type="StandardDimension" visible="true" foreignKey="账簿名称" name="账簿">

      <Hierarchy name="BookHierarchy" visible="true" hasAll="true" allMemberName="所有账簿" allMemberCaption="所有账簿" primaryKey="账簿名称">

        <Table name="资产负债视图" alias="Temp4">

        </Table>

        <Level name="账簿名称" visible="true" column="账簿名称" nameColumn="账簿名称" type="String" uniqueMembers="false">

        </Level>

      </Hierarchy>

    </Dimension>

    <Dimension type="StandardDimension" visible="true" foreignKey="项目分类" name="项目分类">

      <Hierarchy name="ItemTypeHierarchy" visible="true" hasAll="true" allMemberName="所有分类" allMemberCaption="所有分类" primaryKey="项目分类">

        <Table name="资产负债视图" alias="Temp5">

        </Table>

        <Level name="项目分类" visible="true" column="项目分类" type="String" uniqueMembers="false">

        </Level>

      </Hierarchy>

    </Dimension>

    <Dimension type="StandardDimension" visible="true" foreignKey="项目名称" name="项目名称">

      <Hierarchy name="ItemHierarchy" visible="true" hasAll="true" allMemberName="所有项目" allMemberCaption="所有项目" primaryKey="项目名称">

        <Table name="资产负债视图" alias="Temp5">

        </Table>

        <Level name="项目名称" visible="true" column="项目名称" type="String" uniqueMembers="false">

        </Level>

      </Hierarchy>

    </Dimension>

    <Measure name="年初数" column="年初数" aggregator="sum" visible="true">

    </Measure>

    <Measure name="期末数" column="期末数" aggregator="sum" visible="true">

    </Measure>

  </Cube>

</Schema>