📄 产品.dim
字号:
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<AttributeHierarchyDisplayFolder>Financial</AttributeHierarchyDisplayFolder>
<InstanceSelection>List</InstanceSelection>
</Attribute>
<Attribute dwd:design-time-name="13ded82f-99f1-4da3-bc7e-15593377095d">
<ID>Size</ID>
<Name>Size</Name>
<EstimatedCount>19</EstimatedCount>
<KeyColumns>
<KeyColumn dwd:design-time-name="8177f203-2b05-4a67-bc88-4d9f22a1589e">
<DataType>WChar</DataType>
<DataSize>50</DataSize>
<Source xsi:type="ColumnBinding" dwd:design-time-name="cdc2e51f-0b6f-4488-abc6-72c35e63220f">
<TableID>dbo_DimProduct</TableID>
<ColumnID>Size</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<AttributeHierarchyDisplayFolder>Stocking</AttributeHierarchyDisplayFolder>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute dwd:design-time-name="11bf90d0-93f5-42a3-be89-0744e99b0829">
<ID>Size Range</ID>
<Name>Size Range</Name>
<EstimatedCount>11</EstimatedCount>
<KeyColumns>
<KeyColumn dwd:design-time-name="2198e17f-69ca-4fea-a7ee-7e44e0852431">
<DataType>WChar</DataType>
<DataSize>50</DataSize>
<Source xsi:type="ColumnBinding" dwd:design-time-name="223457fa-0717-42af-90e1-df3d4cbc81e2">
<TableID>dbo_DimProduct</TableID>
<ColumnID>SizeRange</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<AttributeHierarchyDisplayFolder>Stocking</AttributeHierarchyDisplayFolder>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute dwd:design-time-name="6debe0d4-ee97-4d4c-b2bd-8ec0aab3b9e6">
<ID>Weight</ID>
<Name>Weight</Name>
<EstimatedCount>128</EstimatedCount>
<KeyColumns>
<KeyColumn dwd:design-time-name="10a94294-875e-48d4-805b-047d276a481e">
<DataType>Double</DataType>
<Source xsi:type="ColumnBinding" dwd:design-time-name="ed16235d-940f-4623-adc4-771385cdccf4">
<TableID>dbo_DimProduct</TableID>
<ColumnID>Weight</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<AttributeHierarchyDisplayFolder>Stocking</AttributeHierarchyDisplayFolder>
<InstanceSelection>List</InstanceSelection>
</Attribute>
<Attribute dwd:design-time-name="02ed664d-831d-4a87-be32-bc0920475715">
<ID>Days To Manufacture</ID>
<Name>Days To Manufacture</Name>
<EstimatedCount>4</EstimatedCount>
<KeyColumns>
<KeyColumn dwd:design-time-name="c0ecbf77-da10-4af9-8c3f-d52eacd56a98">
<DataType>Integer</DataType>
<Source xsi:type="ColumnBinding" dwd:design-time-name="3192820e-4542-4c01-84c7-1503daaf0003">
<TableID>dbo_DimProduct</TableID>
<ColumnID>DaysToManufacture</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<AttributeHierarchyDisplayFolder>Stocking</AttributeHierarchyDisplayFolder>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute dwd:design-time-name="56c54feb-c143-402f-89d0-87feca235d9f">
<ID>Product Line</ID>
<Name>Product Line</Name>
<EstimatedCount>5</EstimatedCount>
<KeyColumns>
<KeyColumn dwd:design-time-name="2a8c70fa-dc52-45e0-981c-c041e843683c">
<DataType>WChar</DataType>
<DataSize>2</DataSize>
<Source xsi:type="ColumnBinding" dwd:design-time-name="6396cd4f-d880-4ca9-b3f5-f073476f9dc8">
<TableID>dbo_DimProduct</TableID>
<ColumnID>ProductLine</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<NameColumn dwd:design-time-name="102aa2d6-165d-4587-92c1-47b64162985e">
<DataType>WChar</DataType>
<DataSize>10</DataSize>
<Source xsi:type="ColumnBinding" dwd:design-time-name="f84d078f-9f8f-4746-91fc-d23ebf44a35a">
<TableID>dbo_DimProduct</TableID>
<ColumnID>ProductLineName</ColumnID>
</Source>
</NameColumn>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute dwd:design-time-name="3be2d640-2621-4bb9-95af-1a0df35b9ee0">
<ID>Dealer Price</ID>
<Name>Dealer Price</Name>
<EstimatedCount>121</EstimatedCount>
<KeyColumns>
<KeyColumn dwd:design-time-name="92cf8a49-562d-4593-853f-6d471f2126a4">
<DataType>Double</DataType>
<Source xsi:type="ColumnBinding" dwd:design-time-name="81b3f8c2-cd0a-42a7-9e46-2a3204e38a1f">
<TableID>dbo_DimProduct</TableID>
<ColumnID>DealerPrice</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<AttributeHierarchyDisplayFolder>Financial</AttributeHierarchyDisplayFolder>
<InstanceSelection>List</InstanceSelection>
</Attribute>
<Attribute dwd:design-time-name="1da8c63b-08e5-4d8c-aebd-78dc54dbe40a">
<ID>Class</ID>
<Name>Class</Name>
<EstimatedCount>4</EstimatedCount>
<KeyColumns>
<KeyColumn dwd:design-time-name="393e5833-2d80-4803-92c4-004f9dd48ce6">
<DataType>WChar</DataType>
<DataSize>2</DataSize>
<Source xsi:type="ColumnBinding" dwd:design-time-name="3d57b3a8-a5a6-44b9-b349-a21541aec8e3">
<TableID>dbo_DimProduct</TableID>
<ColumnID>Class</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<AttributeHierarchyDisplayFolder>Stocking</AttributeHierarchyDisplayFolder>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute dwd:design-time-name="9bdc34ec-4244-465f-b23d-4abd16ff79bc">
<ID>Style</ID>
<Name>Style</Name>
<EstimatedCount>4</EstimatedCount>
<KeyColumns>
<KeyColumn dwd:design-time-name="a3cec9a5-e9b6-47a6-bc13-d2eb938ffeb7">
<DataType>WChar</DataType>
<DataSize>2</DataSize>
<Source xsi:type="ColumnBinding" dwd:design-time-name="a906a8ad-ed7f-44bc-89c9-b5234b9c836a">
<TableID>dbo_DimProduct</TableID>
<ColumnID>Style</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<AttributeHierarchyDisplayFolder>Stocking</AttributeHierarchyDisplayFolder>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute dwd:design-time-name="e73be867-7bea-4412-a946-95b61cf2e5d7">
<ID>Model Name</ID>
<Name>Model Name</Name>
<EstimatedCount>120</EstimatedCount>
<KeyColumns>
<KeyColumn dwd:design-time-name="430eeabb-bbb5-4dba-b8f6-186285089e5d">
<DataType>WChar</DataType>
<DataSize>50</DataSize>
<Source xsi:type="ColumnBinding" dwd:design-time-name="4878bcd3-071c-4130-9845-0c05765e19f8">
<TableID>dbo_DimProduct</TableID>
<ColumnID>ModelName</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>List</InstanceSelection>
</Attribute>
<Attribute dwd:design-time-name="fb7fb94d-8f4c-41e7-9779-faae7e55ae45">
<ID>Start Date</ID>
<Name>Start Date</Name>
<EstimatedCount>4</EstimatedCount>
<KeyColumns>
<KeyColumn dwd:design-time-name="14e361d3-d46e-4b27-aaf1-0dfe23a0c04d">
<DataType>Date</DataType>
<Source xsi:type="ColumnBinding" dwd:design-time-name="2abd64cb-0868-4af5-a6a5-b52764823bfb">
<TableID>dbo_DimProduct</TableID>
<ColumnID>StartDate</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<AttributeHierarchyDisplayFolder>History</AttributeHierarchyDisplayFolder>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute dwd:design-time-name="dfcb2f06-5b99-4c27-b90b-0818eefc1aed">
<ID>End Date</ID>
<Name>End Date</Name>
<EstimatedCount>3</EstimatedCount>
<KeyColumns>
<KeyColumn dwd:design-time-name="ef237bec-2587-4ef9-8c3e-b023e78301a1">
<DataType>Date</DataType>
<Source xsi:type="ColumnBinding" dwd:design-time-name="52d9dc2a-ef33-4936-89f1-26b816d9bee2">
<TableID>dbo_DimProduct</TableID>
<ColumnID>EndDate</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<AttributeHierarchyDisplayFolder>History</AttributeHierarchyDisplayFolder>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute dwd:design-time-name="4fdf3354-094d-4b27-bd4c-4ba468a8ab1e">
<ID>Status</ID>
<Name>Status</Name>
<EstimatedCount>2</EstimatedCount>
<KeyColumns>
<KeyColumn dwd:design-time-name="59e69fc2-8149-470a-99cd-27f1b2cb250b">
<DataType>WChar</DataType>
<DataSize>7</DataSize>
<Source xsi:type="ColumnBinding" dwd:design-time-name="c402ddce-b440-4196-b10e-61a314ddeac3">
<TableID>dbo_DimProduct</TableID>
<ColumnID>Status</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<AttributeHierarchyDisplayFolder>History</AttributeHierarchyDisplayFolder>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
</Attributes>
<AttributeAllMemberName>All Products</AttributeAllMemberName>
<Hierarchies>
<Hierarchy dwd:design-time-name="6aefb2a1-ca5d-445a-82b6-c0164a273dc2">
<ID>Hierarchy</ID>
<Name>Poduct Model Lines</Name>
<AllMemberName>All Products</AllMemberName>
<Levels>
<Level dwd:design-time-name="31e1d79b-521e-4f1a-ad30-703247d32f3c">
<ID>Product Line</ID>
<Name>Product Line</Name>
<SourceAttributeID>Product Line</SourceAttributeID>
</Level>
<Level dwd:design-time-name="aa019f2a-f1ad-492a-a55d-ee5a609c423d">
<ID>Model Name</ID>
<Name>Model Name</Name>
<SourceAttributeID>Model Name</SourceAttributeID>
</Level>
<Level dwd:design-time-name="a0e45c64-6f7d-4fe2-b666-15c2b6c8dd62">
<ID>Product Name</ID>
<Name>Product Name</Name>
<SourceAttributeID>Product</SourceAttributeID>
</Level>
</Levels>
</Hierarchy>
</Hierarchies>
</Dimension>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -