📄 olapdb.rep
字号:
ID|0A78A054-EF40-40A4-B52E-90C31A4FFAF2
ParentID|547EAF01-FD65-4938-B566-6483E9A7D492
ObjectName|本书附件
ClassType| 7
LastUpdated|04-27-2005 17:22:54
Changed|False
Version| 1
ObjectDefinition|<DIMENSION Name="本书附件" DataSource="分析管理员范例数据库 - J 新建文件夹 分析管理员范例数据库" FromClause=""书籍资料""><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="（全部）" MemberKeyColumn="所有 本书附件" IsAll="-1" LevelType="1"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><MEMBERPROPS></MEMBERPROPS></LEVEL><LEVEL Name="本书附件" MemberKeyColumn=""书籍资料"."本书附件"" LevelNum="2" EstimatedSize="5" DBColumnType="130" ColumnSize="255"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><MEMBERPROPS></MEMBERPROPS></LEVEL></LEVELS></DIMENSION>
<Next Record>
ID|09527748-4C98-4DAF-974C-2D16A57894C7
ParentID|0FCCAFBC-B4BA-4CDE-A604-01A0DDC7DCE1
ObjectName|售货
ClassType| 19
LastUpdated|06-11-2005 11:01:57
Changed|False
Version| 3
ObjectDefinition|<PARTITION Name="售货" DataSource="分析管理员范例数据库 - J 新建文件夹 分析管理员范例数据库" FactTable=""交易资料"" FromClause=""交易资料", "书籍资料", "客户资料""><CUSTOMPROPERTIES></CUSTOMPROPERTIES><DIMENSIONS><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></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></LEVELS></DIMENSION><DIMENSION Name="本书附件"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><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="21111" Mode="0" DatasetName="21111" SourceTable="+S1"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="21112" Mode="0" DatasetName="21112" SourceTable="+S2"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="21121" Mode="0" DatasetName="21121" SourceTable="+A4"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="21122" Mode="0" DatasetName="21122" SourceTable="+A6"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="21211" Mode="0" DatasetName="21211" SourceTable="+Y1"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="21212" Mode="0" DatasetName="21212" SourceTable="+Y2"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="21221" Mode="0" DatasetName="21221" SourceTable="+G4"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="21222" Mode="0" DatasetName="21222" SourceTable="+G6"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="21311" Mode="0" DatasetName="21311" SourceTable="+M3"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="21312" Mode="0" DatasetName="21312" SourceTable="+M5"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="21321" Mode="0" DatasetName="21321" SourceTable="+M4"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="22111" Mode="0" DatasetName="22111" SourceTable="+V1"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="22112" Mode="0" DatasetName="22112" SourceTable="+V2"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="22121" Mode="0" DatasetName="22121" SourceTable="+D4"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="22122" Mode="0" DatasetName="22122" SourceTable="+D6"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="22211" Mode="0" DatasetName="22211" SourceTable="+J3"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="22212" Mode="0" DatasetName="22212" SourceTable="+J5"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="22221" Mode="0" DatasetName="22221" SourceTable="+J4"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="22222" Mode="0" DatasetName="22222" SourceTable="+J6"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="22311" Mode="0" DatasetName="22311" SourceTable="+P3"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="31111" Mode="0" DatasetName="31111" SourceTable="+T1"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="31112" Mode="0" DatasetName="31112" SourceTable="+T2"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="31121" Mode="0" DatasetName="31121" SourceTable="+B4"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="31122" Mode="0" DatasetName="31122" SourceTable="+B6"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="31211" Mode="0" DatasetName="31211" SourceTable="+Z1"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="31212" Mode="0" DatasetName="31212" SourceTable="+Z2"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="31221" Mode="0" DatasetName="31221" SourceTable="+H4"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="32111" Mode="0" DatasetName="32111" SourceTable="+W1"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="32112" Mode="0" DatasetName="32112" SourceTable="+W2"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION><AGGREGATION Name="32121" Mode="0" DatasetName="32121" SourceTable="+E4"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></AGGREGATION></AGGREGATIONS></PARTITION>
<Next Record>
ID|0FCCAFBC-B4BA-4CDE-A604-01A0DDC7DCE1
ParentID|547EAF01-FD65-4938-B566-6483E9A7D492
ObjectName|售货
ClassType| 9
LastUpdated|06-11-2005 08:01:02
Changed|False
Version| 1
ObjectDefinition|<CUBE Name="售货" DefaultDataSource="分析管理员范例数据库 - J 新建文件夹 分析管理员范例数据库" DefaultFactTable=""交易资料"" DefaultFactTableAlias="" JoinClause="("交易资料"."书号"="书籍资料"."书号") AND ("交易资料"."客户编号"="客户资料"."客户编号")" FromClause=""交易资料", "书籍资料", "客户资料"" DefaultFactTableSize="13364"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><MEASURES><MEASURE Name="销货数量" SourceName=""交易资料"."销货数量"" Format="#,#" ColumnType="20"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></MEASURE><MEASURE Name="销货成本" MeasureNum="2" SourceName=""交易资料"."销货成本"" Format="#,#" ColumnType="20"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></MEASURE><MEASURE Name="销货金额" MeasureNum="3" SourceName=""交易资料"."销货金额"" Format="#,#" ColumnType="20"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></MEASURE></MEASURES><DIMENSIONS><DIMENSION Name="销货日期_周"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="（全部）" MemberKeyColumn="所有 销货日期_周"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="年" MemberKeyColumn="DatePart('yyyy',"交易资料"."销货日期")"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="周" MemberKeyColumn="DatePart('ww',"交易资料"."销货日期")"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL></LEVELS></DIMENSION><DIMENSION Name="系列别" DimensionNum="2"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="（全部）" MemberKeyColumn="所有 系列别"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="系列别" MemberKeyColumn=""书籍资料"."系列别""><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL></LEVELS></DIMENSION><DIMENSION Name="区域.客户编号" DimensionNum="3"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="（全部）" MemberKeyColumn="所有 区域"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="区域" MemberKeyColumn=""客户资料"."区域""><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="客户编号" MemberKeyColumn=""客户资料"."客户编号""><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL></LEVELS></DIMENSION><DIMENSION Name="彩色" DimensionNum="4"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="（全部）" MemberKeyColumn="所有 彩色"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="彩色" MemberKeyColumn=""书籍资料"."彩色""><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL></LEVELS></DIMENSION><DIMENSION Name="本书附件" DimensionNum="5"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><LEVEL Name="（全部）" MemberKeyColumn="所有 本书附件"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL><LEVEL Name="本书附件" MemberKeyColumn=""书籍资料"."本书附件""><CUSTOMPROPERTIES></CUSTOMPROPERTIES></LEVEL></LEVELS></DIMENSION></DIMENSIONS><ROLES></ROLES><COMMANDS></COMMANDS></CUBE>
<Next Record>
ID|1C04DBF1-5CC9-4F6A-960F-78D2EF162023
ParentID|547EAF01-FD65-4938-B566-6483E9A7D492
ObjectName|决策树分析
ClassType| 33
LastUpdated|06-11-2005 01:26:50
Changed|False
Version| 4
ObjectDefinition|<MININGMODEL Name="决策树分析" LastUpdated="1:20:20 06/11/2005" MiningAlgorithm="Microsoft_Decision_Trees" FromClause=""书籍资料", "交易资料", "客户资料", "业务员", "库存表"" JoinClause="("书籍资料"."书号"="交易资料"."书号") AND ("客户资料"."业务编号"="业务员"."业务编号") AND ("书籍资料"."书号"="库存表"."书号") AND ("交易资料"."客户编号"="客户资料"."客户编号")" Datasource="分析管理员范例数据库 - J 新建文件夹 分析管理员范例数据库"><CUSTOMPROPERTIES><PROPERTY Name="SchemaLayout" DataType="0" Value="({分析管理员范例数据库 - J 新建文件夹 分析管理员范例数据库}{交易资料}{交易资料}{255}{4440}{1800}{2200}{1})({分析管理员范例数据库 - J 新建文件夹 分析管理员范例数据库}{业务员}{业务员}{4080}{4890}{1800}{2200}{1})({分析管理员范例数据库 - J 新建文件夹 分析管理员范例数据库}{客户资料}{客户资料}{1320}{7320}{1800}{2200}{1})({分析管理员范例数据库 - J 新建文件夹 分析管理员范例数据库}{库存表}{库存表}{3512}{2689}{1800}{2200}{1})({分析管理员范例数据库 - J 新建文件夹 分析管理员范例数据库}{书籍资料}{书籍资料}{1200}{600}{1800}{4400}{1})"></PROPERTY></CUSTOMPROPERTIES><COLUMNS><COLUMN Name="书号" SourceColumn=""书籍资料"."书号"" IsKey="-1" IsInput="0" DataType="130" ContentType="DISCRETE"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><COLUMNS></COLUMNS></COLUMN><COLUMN Name="区域" ColumnNum="2" SourceColumn=""客户资料"."区域"" IsPredictable="-1" DataType="130" ContentType="DISCRETE"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><COLUMNS></COLUMNS></COLUMN><COLUMN Name="区域型态" ColumnNum="3" SourceColumn=""客户资料"."区域型态"" IsPredictable="-1" DataType="130" ContentType="DISCRETE"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><COLUMNS></COLUMNS></COLUMN><COLUMN Name="经营型态" ColumnNum="4" SourceColumn=""客户资料"."经营型态"" DataType="130" ContentType="DISCRETE"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><COLUMNS></COLUMNS></COLUMN><COLUMN Name="库存成本" ColumnNum="5" SourceColumn=""库存表"."库存成本"" ContentType="CONTINUOUS"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><COLUMNS></COLUMNS></COLUMN><COLUMN Name="库存量" ColumnNum="6" SourceColumn=""库存表"."库存量"" ContentType="CONTINUOUS"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><COLUMNS></COLUMNS></COLUMN><COLUMN Name="客户编号" ColumnNum="7" SourceColumn=""客户资料"."客户编号"" DataType="130" ContentType="DISCRETE"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><COLUMNS></COLUMNS></COLUMN><COLUMN Name="销货数量" ColumnNum="8" SourceColumn=""交易资料"."销货数量"" ContentType="CONTINUOUS"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><COLUMNS></COLUMNS></COLUMN><COLUMN Name="销货金额" ColumnNum="9" SourceColumn=""交易资料"."销货金额"" ContentType="CONTINUOUS"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><COLUMNS></COLUMNS></COLUMN><COLUMN Name="折扣" ColumnNum="10" SourceColumn=""交易资料"."折扣"" ContentType="DISCRETE"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><COLUMNS></COLUMNS></COLUMN><COLUMN Name="彩色" ColumnNum="11" SourceColumn=""书籍资料"."彩色"" IsPredictable="-1" DataType="130" ContentType="DISCRETE"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><COLUMNS></COLUMNS></COLUMN><COLUMN Name="主管编号" ColumnNum="12" SourceColumn=""业务员"."主管编号"" DataType="130" ContentType="DISCRETE"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><COLUMNS></COLUMNS></COLUMN><COLUMN Name="书名" ColumnNum="13" SourceColumn=""书籍资料"."书名"" IsPredictable="-1" DataType="130" ContentType="DISCRETE"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><COLUMNS></COLUMNS></COLUMN><COLUMN Name="系列别" ColumnNum="14" SourceColumn=""书籍资料"."系列别"" IsPredictable="-1" DataType="130" ContentType="DISCRETE"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><COLUMNS></COLUMNS></COLUMN><COLUMN Name="销货型态" ColumnNum="15" SourceColumn=""交易资料"."销货型态"" IsPredictable="-1" DataType="130" ContentType="DISCRETE"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><COLUMNS></COLUMNS></COLUMN><COLUMN Name="初版日" ColumnNum="16" SourceColumn=""库存表"."初版日"" IsPredictable="-1" DataType="135" ContentType="DISCRETIZED()"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><COLUMNS></COLUMNS></COLUMN><COLUMN Name="业务名称" ColumnNum="17" SourceColumn=""业务员"."业务名称"" IsPredictable="-1" DataType="130" ContentType="DISCRETE"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><COLUMNS></COLUMNS></COLUMN></COLUMNS><ROLES></ROLES></MININGMODEL>
<Next Record>
ID|18BE798A-903B-483A-8E87-59E75EC9C850
ParentID|207D1D79-D309-4587-81DA-A974278B833A
ObjectName|OLAP挖掘模型
ClassType| 19
LastUpdated|04-30-2005 21:49:58
Changed|False
Version| 4
ObjectDefinition|<PARTITION Name="OLAP挖掘模型" DataSource="分析管理员范例数据库 - J 新建文件夹 分析管理员范例数据库" FactTable=""交易资料"" JoinClause="("交易资料"."书号"="书籍资料"."书号")" FromClause=""交易资料", "书籍资料""><CUSTOMPROPERTIES></CUSTOMPROPERTIES><DIMENSIONS><DIMENSION Name="系列别"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><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></LEVELS></DIMENSION><DIMENSION Name="本书附件"><CUSTOMPROPERTIES></CUSTOMPROPERTIES><LEVELS><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></LEVELS></DIMENSION></DIMENSIONS><MEASURES><MEASURE Name="销货数量"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></MEASURE><MEASURE Name="销货金额"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></MEASURE></MEASURES><AGGREGATIONS></AGGREGATIONS></PARTITION>
<Next Record>
ID|207D1D79-D309-4587-81DA-A974278B833A
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -