⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 olapdb.rep

📁 师兄的毕业设计,具体的功能我也不清楚,不过是可以用来答辩的,完整的毕业设计,有源代码,可爱执行文件,文档资料.
💻 REP
📖 第 1 页 / 共 5 页
字号:
ParentID|547EAF01-FD65-4938-B566-6483E9A7D492
ObjectName|OLAP挖掘模型
ClassType| 9 
LastUpdated|04-27-2005 17:24:43
Changed|False
Version| 2 
ObjectDefinition|<CUBE Name="OLAP挖掘模型" DefaultDataSource="分析管理员范例数据库 - J  新建文件夹 分析管理员范例数据库" DefaultFactTable="&quot;交易资料&quot;" DefaultFactTableAlias="" JoinClause="(&quot;交易资料&quot;.&quot;书号&quot;=&quot;书籍资料&quot;.&quot;书号&quot;)" FromClause="&quot;交易资料&quot;, &quot;书籍资料&quot;" DefaultFactTableSize="13364"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><MEASURES><MEASURE Name="销货数量" SourceName="&quot;交易资料&quot;.&quot;销货数量&quot;" Format="#,#" ColumnType="20"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></MEASURE><MEASURE Name="销货金额" MeasureNum="2" SourceName="&quot;交易资料&quot;.&quot;销货金额&quot;" Format="#,#" ColumnType="20"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></MEASURE></MEASURES><DIMENSIONS><DIMENSION Name="系列别"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="(全部)" MemberKeyColumn="所有 系列别"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="系列别" MemberKeyColumn="&quot;书籍资料&quot;.&quot;系列别&quot;"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL></LEVELS></DIMENSION><DIMENSION Name="彩色" DimensionNum="2"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="(全部)" MemberKeyColumn="所有 彩色"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="彩色" MemberKeyColumn="&quot;书籍资料&quot;.&quot;彩色&quot;"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL></LEVELS></DIMENSION><DIMENSION Name="本书附件" DimensionNum="3"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="(全部)" MemberKeyColumn="所有 本书附件"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="本书附件" MemberKeyColumn="&quot;书籍资料&quot;.&quot;本书附件&quot;"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL></LEVELS></DIMENSION><DIMENSION Name="销货编号" DimensionNum="4"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="(全部)"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="销货编号"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL></LEVELS></DIMENSION></DIMENSIONS><ROLES></ROLES><COMMANDS></COMMANDS></CUBE>
<Next Record>
ID|AC63D449-8FED-40DF-859A-47CE9DB73C37
ParentID|24B8C498-EED9-47B7-B9FD-5DC3F3194DFB
ObjectName|OLAP挖掘模型虚拟多维数据集
ClassType| 19 
LastUpdated|04-27-2005 17:27:57
Changed|False
Version| 1 
ObjectDefinition|<PARTITION Name="OLAP挖掘模型虚拟多维数据集"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><DIMENSIONS></DIMENSIONS><MEASURES></MEASURES><AGGREGATIONS></AGGREGATIONS></PARTITION>
<Next Record>
ID|24B8C498-EED9-47B7-B9FD-5DC3F3194DFB
ParentID|547EAF01-FD65-4938-B566-6483E9A7D492
ObjectName|OLAP挖掘模型虚拟多维数据集
ClassType| 9 
LastUpdated|06-11-2005 07:59:46
Changed|False
Version| 3 
ObjectDefinition|<CUBE Name="OLAP挖掘模型虚拟多维数据集" DefaultDataSource="" DefaultFactTable="" DefaultFactTableAlias="" FromClause="" DefaultFactTableSize="0" SubClassType="1"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><MEASURES><MEASURE Name="销货数量" SourceName="[OLAP挖掘模型].[销货数量]"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></MEASURE><MEASURE Name="销货金额" MeasureNum="2" SourceName="[OLAP挖掘模型].[销货金额]"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></MEASURE></MEASURES><DIMENSIONS><DIMENSION Name="系列别"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="(全部)"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="系列别"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL></LEVELS></DIMENSION><DIMENSION Name="彩色" DimensionNum="2"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="(全部)"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="彩色"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL></LEVELS></DIMENSION><DIMENSION Name="本书附件" DimensionNum="3"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="(全部)"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="本书附件"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL></LEVELS></DIMENSION><DIMENSION Name="销货编号" DimensionNum="4"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="(全部)"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="销货编号"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL></LEVELS></DIMENSION></DIMENSIONS><ROLES></ROLES><COMMANDS></COMMANDS></CUBE>
<Next Record>
ID|F93BE353-B321-43D4-9253-06353AF5B02C
ParentID|2E1A49BA-528B-4837-B084-16BA42E85DC8
ObjectName|业务分析模式
ClassType| 19 
LastUpdated|06-08-2005 20:38:39
Changed|False
Version| 6 
ObjectDefinition|<PARTITION Name="业务分析模式" DataSource="分析管理员范例数据库 - J  新建文件夹 分析管理员范例数据库" FactTable="&quot;交易资料&quot;" JoinClause="(&quot;客户资料&quot;.&quot;业务编号&quot;=&quot;业务员&quot;.&quot;业务编号&quot;) AND (&quot;交易资料&quot;.&quot;客户编号&quot;=&quot;客户资料&quot;.&quot;客户编号&quot;) AND (&quot;交易资料&quot;.&quot;书号&quot;=&quot;书籍资料&quot;.&quot;书号&quot;)" FromClause="&quot;交易资料&quot;, &quot;客户资料&quot;, &quot;业务员&quot;, &quot;书籍资料&quot;" AggregationPrefix="业务分析模式_业务分析模式_"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><DIMENSIONS><DIMENSION Name="区域.业务_客户"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="(全部)"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="区域型态"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="业务名称"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="客户名称"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL></LEVELS></DIMENSION><DIMENSION Name="区域.客户编号"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="(全部)"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="区域"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="客户编号"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL></LEVELS></DIMENSION><DIMENSION Name="书号"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="(全部)"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="彩色"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="作者译者"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="书号"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL></LEVELS></DIMENSION><DIMENSION Name="销货日期_周"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="(全部)"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="年"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="周"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL></LEVELS></DIMENSION></DIMENSIONS><MEASURES><MEASURE Name="销货数量"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></MEASURE><MEASURE Name="销货成本"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></MEASURE><MEASURE Name="销货金额"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></MEASURE></MEASURES><AGGREGATIONS><AGGREGATION Name="1112" Mode="0" DatasetName="1112" SourceTable="+G2" EstimatedRows="1"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="1113" Mode="0" DatasetName="1113" SourceTable="+G3" EstimatedRows="43"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="1122" Mode="0" DatasetName="1122" SourceTable="+S2" EstimatedRows="4"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="1123" Mode="0" DatasetName="1123" SourceTable="+S3" EstimatedRows="172"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="1132" Mode="0" DatasetName="1132" SourceTable="+5A" EstimatedRows="70"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="1133" Mode="0" DatasetName="1133" SourceTable="+5E" EstimatedRows="2975"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="1142" Mode="0" DatasetName="1142" SourceTable="+5B" EstimatedRows="92"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="1143" Mode="0" DatasetName="1143" SourceTable="+5F" EstimatedRows="3821"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="1212" Mode="0" DatasetName="1212" SourceTable="+K2" EstimatedRows="19"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="1213" Mode="0" DatasetName="1213" SourceTable="+K3" EstimatedRows="817"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="1222" Mode="0" DatasetName="1222" SourceTable="+W2" EstimatedRows="76"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="1223" Mode="0" DatasetName="1223" SourceTable="+W3" EstimatedRows="3213"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="1232" Mode="0" DatasetName="1232" SourceTable="+9A" EstimatedRows="1330"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="1242" Mode="0" DatasetName="1242" SourceTable="+9B" EstimatedRows="1747"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="1312" Mode="0" DatasetName="1312" SourceTable="+O2" EstimatedRows="257"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="1322" Mode="0" DatasetName="1322" SourceTable="+C0" EstimatedRows="1028"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="2112" Mode="0" DatasetName="2112" SourceTable="+H2" EstimatedRows="9"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="2113" Mode="0" DatasetName="2113" SourceTable="+H3" EstimatedRows="387"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="2122" Mode="0" DatasetName="2122" SourceTable="+T2" EstimatedRows="36"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="2123" Mode="0" DatasetName="2123" SourceTable="+T3" EstimatedRows="1548"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="2132" Mode="0" DatasetName="2132" SourceTable="+6A" EstimatedRows="630"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="2142" Mode="0" DatasetName="2142" SourceTable="+6B" EstimatedRows="828"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="2212" Mode="0" DatasetName="2212" SourceTable="+L2" EstimatedRows="171"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="2222" Mode="0" DatasetName="2222" SourceTable="+X2" EstimatedRows="684"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="2312" Mode="0" DatasetName="2312" SourceTable="+P2" EstimatedRows="2306"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="2322" Mode="0" DatasetName="2322" SourceTable="+D0" EstimatedRows="7070"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="3112" Mode="0" DatasetName="3112" SourceTable="+I2" EstimatedRows="32"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="3113" Mode="0" DatasetName="3113" SourceTable="+I3" EstimatedRows="1376"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="3122" Mode="0" DatasetName="3122" SourceTable="+U2" EstimatedRows="128"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="3132" Mode="0" DatasetName="3132" SourceTable="+7A" EstimatedRows="2234"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="3142" Mode="0" DatasetName="3142" SourceTable="+7B" EstimatedRows="2913"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="3212" Mode="0" DatasetName="3212" SourceTable="+M2" EstimatedRows="608"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="3222" Mode="0" DatasetName="3222" SourceTable="+Y2" EstimatedRows="2422"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="3312" Mode="0" DatasetName="3312" SourceTable="+Q2" EstimatedRows="6605"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="3322" Mode="0" DatasetName="3322" SourceTable="+E0" EstimatedRows="10983"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="4112" Mode="0" DatasetName="4112" SourceTable="+J2" EstimatedRows="258"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="4122" Mode="0" DatasetName="4122" SourceTable="+V2" EstimatedRows="1032"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="4212" Mode="0" DatasetName="4212" SourceTable="+N2" EstimatedRows="4581"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="4222" Mode="0" DatasetName="4222" SourceTable="+Z2" EstimatedRows="9690"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="4312" Mode="0" DatasetName="4312" SourceTable="+R2" EstimatedRows="12103"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="4322" Mode="0" DatasetName="4322" SourceTable="+F0" EstimatedRows="13033"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION></AGGREGATIONS></PARTITION>
<Next Record>
ID|2E1A49BA-528B-4837-B084-16BA42E85DC8
ParentID|547EAF01-FD65-4938-B566-6483E9A7D492
ObjectName|业务分析模式
ClassType| 9 
LastUpdated|06-08-2005 21:17:52
Changed|False
Version| 17 
ObjectDefinition|<CUBE Name="业务分析模式" DefaultDataSource="分析管理员范例数据库 - J  新建文件夹 分析管理员范例数据库" DefaultFactTable="&quot;交易资料&quot;" DefaultFactTableAlias="" JoinClause="(&quot;客户资料&quot;.&quot;业务编号&quot;=&quot;业务员&quot;.&quot;业务编号&quot;) AND (&quot;交易资料&quot;.&quot;客户编号&quot;=&quot;客户资料&quot;.&quot;客户编号&quot;) AND (&quot;交易资料&quot;.&quot;书号&quot;=&quot;书籍资料&quot;.&quot;书号&quot;)" FromClause="&quot;客户资料&quot;, &quot;业务员&quot;, &quot;交易资料&quot;, &quot;书籍资料&quot;" DefaultFactTableSize="13364" AllowDrillThrough="-1" DrillThroughColumns="&quot;交易资料&quot;.&quot;销货日期&quot;, &quot;交易资料&quot;.&quot;销货编号&quot;, &quot;交易资料&quot;.&quot;客户编号&quot;, &quot;交易资料&quot;.&quot;书号&quot;, &quot;交易资料&quot;.&quot;销货数量&quot;, &quot;交易资料&quot;.&quot;销货成本&quot;, &quot;交易资料&quot;.&quot;销货金额&quot;, &quot;交易资料&quot;.&quot;折扣&quot;, &quot;交易资料&quot;.&quot;销货型态&quot;, &quot;客户资料&quot;.&quot;客户编号&quot;, &quot;客户资料&quot;.&quot;客户简称&quot;, &quot;客户资料&quot;.&quot;客户名称&quot;, &quot;客户资料&quot;.&quot;区域&quot;, &quot;客户资料&quot;.&quot;业务编号&quot;, &quot;客户资料&quot;.&quot;区域型态&quot;, &quot;客户资料&quot;.&quot;经营型态&quot;, &quot;业务员&quot;.&quot;业务编号&quot;, &quot;业务员&quot;.&quot;业务名称&quot;, &quot;业务员&quot;.&quot;主管编号&quot;, &quot;业务员&quot;.&quot;业务组别&quot;, &quot;业务员&quot;.&quot;年度业绩目标&quot;, &quot;书籍资料&quot;.&quot;书号&quot;, &quot;书籍资料&quot;.&quot;书名&quot;, &quot;书籍资料&quot;.&quot;作者译者&quot;, &quot;书籍资料&quot;.&quot;彩色&quot;, &quot;书籍资料&quot;.&quot;系列别&quot;, &quot;书籍资料&quot;.&quot;本书附件&quot;, &quot;书籍资料&quot;.&quot;页数&quot;" DrillThroughFrom="&quot;交易资料&quot;, &quot;客户资料&quot;, &quot;业务员&quot;, &quot;书籍资料&quot;" DrillThroughJoins="(&quot;交易资料&quot;.&quot;客户编号&quot;=&quot;客户资料&quot;.&quot;客户编号&quot;) AND (&quot;客户资料&quot;.&quot;业务编号&quot;=&quot;业务员&quot;.&quot;业务编号&quot;) AND (&quot;交易资料&quot;.&quot;书号&quot;=&quot;书籍资料&quot;.&quot;书号&quot;)"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><MEASURES><MEASURE Name="销货数量" SourceName="&quot;交易资料&quot;.&quot;销货数量&quot;" Format="#,#" ColumnType="20"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></MEASURE><MEASURE Name="销货成本" MeasureNum="2" SourceName="&quot;交易资料&quot;.&quot;销货成本&quot;" Format="#,#" ColumnType="20"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></MEASURE><MEASURE Name="销货金额" MeasureNum="3" SourceName="&quot;交易资料&quot;.&quot;销货金额&quot;" Format="#,#" ColumnType="20"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></MEASURE></MEASURES><DIMENSIONS><DIMENSION Name="区域.业务_客户"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="(全部)" MemberKeyColumn="所有 区域"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="区域型态" MemberKeyColumn="&quot;客户资料&quot;.&quot;区域型态&quot;"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="业务名称" MemberKeyColumn="&quot;业务员&quot;.&quot;业务名称&quot;"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="客户名称" MemberKeyColumn="&quot;客户资料&quot;.&quot;客户名称&quot;"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL></LEVELS></DIMENSION><DIMENSION Name="区域.客户编号" DimensionNum="2"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="(全部)" MemberKeyColumn="所有 区域"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="区域" MemberKeyColumn="&quot;客户资料&quot;.&quot;区域&quot;"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="客户编号" MemberKeyColumn="&quot;客户资料&quot;.&quot;客户编号&quot;"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL></LEVELS></DIMENSION><DIMENSION Name="书号" DimensionNum="3"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="(全部)"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="彩色"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="作者译者"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="书号"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL></LEVELS></DIMENSION><DIMENSION Name="销货日期_周" DimensionNum="4"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="(全部)" MemberKeyColumn="所有 销货日期_周"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="年" MemberKeyColumn="DatePart(&apos;yyyy&apos;,&quot;交易资料&quot;.&quot;销货日期&quot;)"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="周" MemberKeyColumn="DatePart(&apos;ww&apos;,&quot;交易资料&quot;.&quot;销货日期&quot;)"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL></LEVELS></DIMENSION></DIMENSIONS><ROLES></ROLES><COMMANDS><COMMAND Name="平均销售额" Statement="CREATE MEMBER CURRENTCUBE.Measures.[平均销售额] AS &apos;[Measures].[销货金额]/[Measures].[销货数量]&apos;" CommandType="1"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></COMMAND><COMMAND Name="毛利" Statement="CREATE MEMBER CURRENTCUBE.Measures.[毛利] AS &apos;([Measures].[销货金额]-[Measures].[销货成本])&apos;" CommandType="1" Num="2"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></COMMAND><COMMAND Name="毛利率" Statement="CREATE MEMBER CURRENTCUBE.Measures.[毛利率] AS &apos;[Measures].[毛利]/[Measures].[销货金额]&apos;, FORMAT_STRING = &apos;Percent&apos;" CommandType="1" Num="3"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></COMMAND></COMMANDS></CUBE>
<Next Record>
ID|4E0E9405-AD1E-403D-A0DF-424545647A94
ParentID|547EAF01-FD65-4938-B566-6483E9A7D492

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -