📄 aworks.asdatabase
字号:
<TableID>dbo_DimCustomer</TableID>
<ColumnID>HouseOwnerFlag</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Number Cars Owned</ID>
<Name>Number Cars Owned</Name>
<EstimatedCount>5</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>UnsignedTinyInt</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_DimCustomer</TableID>
<ColumnID>NumberCarsOwned</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Date First Purchase</ID>
<Name>Date First Purchase</Name>
<KeyColumns>
<KeyColumn>
<DataType>Date</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_DimCustomer</TableID>
<ColumnID>DateFirstPurchase</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>FilteredList</InstanceSelection>
</Attribute>
<Attribute>
<ID>Commute Distance</ID>
<Name>Commute Distance</Name>
<EstimatedCount>5</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>WChar</DataType>
<DataSize>15</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_DimCustomer</TableID>
<ColumnID>CommuteDistance</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>地区</ID>
<Name>地区</Name>
<EstimatedCount>655</EstimatedCount>
<KeyColumns>
<KeyColumn>
<NullProcessing>UnknownMember</NullProcessing>
<DataType>Integer</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_DimGeography</TableID>
<ColumnID>GeographyKey</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<AttributeRelationships>
<AttributeRelationship>
<AttributeID>City</AttributeID>
<Name>City</Name>
</AttributeRelationship>
<AttributeRelationship>
<AttributeID>State Province Name</AttributeID>
<Name>State Province Name</Name>
</AttributeRelationship>
<AttributeRelationship>
<AttributeID>English Country Region Name</AttributeID>
<Name>English Country Region Name</Name>
</AttributeRelationship>
<AttributeRelationship>
<AttributeID>Postal Code</AttributeID>
<Name>Postal Code</Name>
</AttributeRelationship>
</AttributeRelationships>
<OrderBy>Key</OrderBy>
<InstanceSelection>FilteredList</InstanceSelection>
</Attribute>
<Attribute>
<ID>City</ID>
<Name>城市</Name>
<EstimatedCount>562</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>WChar</DataType>
<DataSize>30</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_DimGeography</TableID>
<ColumnID>City</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>FilteredList</InstanceSelection>
</Attribute>
<Attribute>
<ID>State Province Name</ID>
<Name>国家名称</Name>
<EstimatedCount>71</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>WChar</DataType>
<DataSize>50</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_DimGeography</TableID>
<ColumnID>StateProvinceName</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>English Country Region Name</ID>
<Name>English Country Region Name</Name>
<EstimatedCount>6</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>WChar</DataType>
<DataSize>50</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_DimGeography</TableID>
<ColumnID>EnglishCountryRegionName</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Postal Code</ID>
<Name>Postal Code</Name>
<EstimatedCount>635</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>WChar</DataType>
<DataSize>15</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_DimGeography</TableID>
<ColumnID>PostalCode</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>FilteredList</InstanceSelection>
</Attribute>
</Attributes>
<Hierarchies>
<Hierarchy>
<ID>State Province Name - 地区</ID>
<Name>State Province Name - 地区</Name>
<Levels>
<Level>
<ID>State Province Name</ID>
<Name>国家</Name>
<SourceAttributeID>State Province Name</SourceAttributeID>
</Level>
<Level>
<ID>地区</ID>
<Name>地区</Name>
<SourceAttributeID>地区</SourceAttributeID>
</Level>
<Level>
<ID>城市</ID>
<Name>城市</Name>
<SourceAttributeID>City</SourceAttributeID>
</Level>
<Level>
<ID>客户</ID>
<Name>客户</Name>
<SourceAttributeID>客户</SourceAttributeID>
</Level>
</Levels>
</Hierarchy>
</Hierarchies>
</Dimension>
<Dimension>
<ID>产品</ID>
<Name>产品</Name>
<CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
<LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
<Annotations>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramLayout</Name>
<Value>
<dds xmlns="">
<diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="MSDDS.Rectilinear" defaultlineroute="MSDDS.Rectilinear" version="7" nextobject="3" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-1673" scrolltop="3597" gridx="150" gridy="150" marginx="5000" marginy="5000" zoom="100" x="6271" y="9684" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="0" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="1" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}">
<font>
<ddsxmlobjectstreamwrapper binary="018600009001905f010004cbcecce5" />
</font>
<mouseicon>
<ddsxmlobjectstreamwrapper binary="6c74000000000000" />
</mouseicon>
</diagram>
<layoutmanager>
<ddsxmlobj />
</layoutmanager>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="DimProduct (dbo.DimProduct)" left="20" top="0" logicalid="2" controlid="1" masterid="0" hint1="0" hint2="0" width="4366" height="7831" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobjectstreaminitwrapper binary="000800000e110000971e0000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="dbo_DimProduct" vartype="8" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
</dds>
</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name>
<Value>true</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowRelationshipNames</Name>
<Value>false</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:UseDiagramDefaultLayout</Name>
<Value>true</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortLeft</Name>
<Value>-1673</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>
<Value>3597</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>
<Value>20</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name>
<Value>0</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name>
<Value>100</Value>
</Annotation>
</Annotations>
<LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
<State>Unprocessed</State>
<Source xsi:type="DataSourceViewBinding">
<DataSourceViewID>Adventure Works DW</DataSourceViewID>
</Source>
<CurrentStorageMode>Molap</CurrentStorageMode>
<Attributes>
<Attribute>
<ID>产品</ID>
<Name>产品名称</Name>
<Usage>Key</Usage>
<EstimatedCount>606</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>Integer</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_DimProduct</TableID>
<ColumnID>ProductKey</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<NameColumn>
<DataType>WChar</DataType>
<DataSize>50</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_DimProduct</TableID>
<ColumnID>EnglishProductName</ColumnID>
</Source>
</NameColumn>
<AttributeRelationships>
<AttributeRelationship>
<AttributeID>Product Subcategory Key</AttributeID>
<Name>Product Subcategory Key</Name>
</AttributeRelationship>
<AttributeRelationship>
<AttributeID>Color</AttributeID>
<Name>Color</Name>
</AttributeRelationship>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -