自己写的第一个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>