📄 aworks.asdatabase
字号:
</Source>
</KeyColumn>
</KeyColumns>
<NameColumn>
<DataType>WChar</DataType>
<DataSize>-1</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_DimTime</TableID>
<ColumnID>CalendarQuarter</ColumnID>
</Source>
</NameColumn>
<Translations>
<Translation>
<Language>2052</Language>
<Caption>季度</Caption>
</Translation>
</Translations>
<OrderBy>Key</OrderBy>
</Attribute>
<Attribute>
<ID>月份</ID>
<Name>EnglishMonthName</Name>
<Type>Months</Type>
<KeyColumns>
<KeyColumn>
<DataType>WChar</DataType>
<DataSize>10</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_DimTime</TableID>
<ColumnID>EnglishMonthName</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<NameColumn>
<DataType>WChar</DataType>
<DataSize>10</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_DimTime</TableID>
<ColumnID>EnglishMonthName</ColumnID>
</Source>
</NameColumn>
<Translations>
<Translation>
<Language>2052</Language>
<Caption>中文月</Caption>
<CaptionColumn>
<DataType>WChar</DataType>
<DataSize>50</DataSize>
<Collation>Chinese_PRC_CI_AS</Collation>
<Source xsi:type="ColumnBinding">
<TableID>dbo_DimTime</TableID>
<ColumnID>ChineseMonthName</ColumnID>
</Source>
</CaptionColumn>
</Translation>
</Translations>
<OrderBy>Key</OrderBy>
</Attribute>
<Attribute>
<ID>TimeKey</ID>
<Name>TimeKey</Name>
<Usage>Key</Usage>
<KeyColumns>
<KeyColumn>
<DataType>Integer</DataType>
<DataSize>-1</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_DimTime</TableID>
<ColumnID>TimeKey</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<NameColumn>
<DataType>WChar</DataType>
<DataSize>96</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_DimTime</TableID>
<ColumnID>chinadate</ColumnID>
</Source>
</NameColumn>
<Translations>
<Translation>
<Language>2052</Language>
<Caption>时间键</Caption>
</Translation>
</Translations>
<AttributeRelationships>
<AttributeRelationship>
<AttributeID>年</AttributeID>
<Name>CalendarYear</Name>
</AttributeRelationship>
<AttributeRelationship>
<AttributeID>半年</AttributeID>
<Name>CalendarSemester</Name>
</AttributeRelationship>
<AttributeRelationship>
<AttributeID>季度</AttributeID>
<Name>CalendarQuarter</Name>
</AttributeRelationship>
<AttributeRelationship>
<AttributeID>月份</AttributeID>
<Name>EnglishMonthName</Name>
</AttributeRelationship>
</AttributeRelationships>
<OrderBy>Key</OrderBy>
</Attribute>
</Attributes>
<Hierarchies>
<Hierarchy>
<ID>CalendarYear - CalendarSemester - CalendarQuarter - EnglishMonthName - FullDateAlternateKey</ID>
<Name>日历时间</Name>
<Translations>
<Translation>
<Language>2052</Language>
<Caption>年</Caption>
</Translation>
</Translations>
<Levels>
<Level>
<ID>CalendarYear</ID>
<Name>日历年</Name>
<SourceAttributeID>年</SourceAttributeID>
<Translations>
<Translation>
<Language>2052</Language>
<Caption>年</Caption>
</Translation>
</Translations>
</Level>
<Level>
<ID>CalendarSemester</ID>
<Name>日历半年</Name>
<SourceAttributeID>半年</SourceAttributeID>
<Translations>
<Translation>
<Language>2052</Language>
<Caption>半年</Caption>
</Translation>
</Translations>
</Level>
<Level>
<ID>CalendarQuarter</ID>
<Name>日历季度</Name>
<SourceAttributeID>季度</SourceAttributeID>
<Translations>
<Translation>
<Language>2052</Language>
<Caption>季度</Caption>
</Translation>
</Translations>
</Level>
<Level>
<ID>EnglishMonthName</ID>
<Name>日历月</Name>
<SourceAttributeID>月份</SourceAttributeID>
<Translations>
<Translation>
<Language>2052</Language>
<Caption>英文月</Caption>
</Translation>
</Translations>
</Level>
<Level>
<ID>FullDateAlternateKey</ID>
<Name>日期</Name>
<SourceAttributeID>TimeKey</SourceAttributeID>
<Translations>
<Translation>
<Language>2052</Language>
<Caption>完整日期键</Caption>
</Translation>
</Translations>
</Level>
</Levels>
</Hierarchy>
</Hierarchies>
</Dimension>
</Dimensions>
<Cubes>
<Cube>
<ID>Adventure Works DW</ID>
<Name>AWorkcube</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="24" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="192" scrolltop="10790" gridx="150" gridy="150" marginx="5000" marginy="5000" zoom="75" x="5080" y="14288" 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="245" top="22200" logicalid="12" controlid="1" masterid="0" hint1="0" hint2="0" width="4366" height="5000" 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="000800000e11000088130000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="dbo_DimProduct" vartype="8" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="DimGeography (dbo.DimGeography)" left="20" top="0" logicalid="13" controlid="2" masterid="0" hint1="0" hint2="0" width="4815" height="5000" 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="00080000cf12000088130000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="dbo_DimGeography" vartype="8" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="DimCustomer (dbo.DimCustomer)" left="324" top="7400" logicalid="14" controlid="3" masterid="0" hint1="0" hint2="0" width="4207" height="5000" 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="000800006f10000088130000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="dbo_DimCustomer" vartype="8" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="DimTime (dbo.DimTime)" left="6878" top="14800" logicalid="15" controlid="4" masterid="0" hint1="0" hint2="0" width="4419" height="5000" 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="000800004311000088130000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="dbo_DimTime" vartype="8" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="FactInternetSales (dbo.FactInternetSales)" left="377" top="14800" logicalid="16" controlid="5" masterid="0" hint1="0" hint2="0" width="4101" height="5000" 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="000800000510000088130000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="dbo_FactInternetSales" vartype="8" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="2029" top="19500" logicalid="17" controlid="6" masterid="0" hint1="0" hint2="0" width="799" height="3200" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobj>
<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
</ddsxmlobj>
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="dataSet.Relations[FK_FactInternetSales_DimProduct]" vartype="8" />
<property name="Virtual" value="0" vartype="11" />
<property name="VisibleAP" value="0" vartype="3" />
</ddsxmlobj>
</layoutobject>
<connector lineroutestyle="MSDDS.Rectilinear" sourceid="1" destid="5" sourceattachpoint="6" destattachpoint="7" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">
<point x="2428" y="22200" />
<point x="2428" y="21000" />
<point x="2427" y="21000" />
<point x="2427" y="19800" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="2028" top="4501" logicalid="18" controlid="7" masterid="0" hint1="0" hint2="0" width="799" height="3199" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobj>
<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
</ddsxmlobj>
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="dataSet.Relations[FK_DimCustomer_DimGeography]" vartype="8" />
<property name="Virtual" value="0" vartype="11" />
<property name="VisibleAP" value="0" vartype="3" />
</ddsxmlobj>
</layoutobject>
<connector lineroutestyle="MSDDS.Rectilinear" sourceid="2" destid="3" sourceattachpoint="9" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">
<point x="2427" y="5000" />
<point x="2427" y="7400" />
</connector>
</ddscontrol>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -