📄 foodmartsale as.asdatabase
字号:
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Store Postal Code</ID>
<Name>Store Postal Code</Name>
<EstimatedCount>1</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>WChar</DataType>
<DataSize>50</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_store</TableID>
<ColumnID>store_postal_code</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Store Country</ID>
<Name>Store Country</Name>
<EstimatedCount>3</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>WChar</DataType>
<DataSize>50</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_store</TableID>
<ColumnID>store_country</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Store Manager</ID>
<Name>Store Manager</Name>
<EstimatedCount>23</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>WChar</DataType>
<DataSize>255</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_store</TableID>
<ColumnID>store_manager</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Store Phone</ID>
<Name>Store Phone</Name>
<EstimatedCount>25</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>WChar</DataType>
<DataSize>255</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_store</TableID>
<ColumnID>store_phone</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Store Fax</ID>
<Name>Store Fax</Name>
<EstimatedCount>25</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>WChar</DataType>
<DataSize>255</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_store</TableID>
<ColumnID>store_fax</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>First Opened Date</ID>
<Name>First Opened Date</Name>
<EstimatedCount>25</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>Date</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_store</TableID>
<ColumnID>first_opened_date</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Last Remodel Date</ID>
<Name>Last Remodel Date</Name>
<EstimatedCount>25</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>Date</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_store</TableID>
<ColumnID>last_remodel_date</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Lease Sqft</ID>
<Name>Lease Sqft</Name>
<EstimatedCount>1</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>Double</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_store</TableID>
<ColumnID>lease_sqft</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Store Sqft</ID>
<Name>Store Sqft</Name>
<EstimatedCount>21</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>Double</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_store</TableID>
<ColumnID>store_sqft</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Grocery Sqft</ID>
<Name>Grocery Sqft</Name>
<EstimatedCount>21</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>Double</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_store</TableID>
<ColumnID>grocery_sqft</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Frozen Sqft</ID>
<Name>Frozen Sqft</Name>
<EstimatedCount>21</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>Double</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_store</TableID>
<ColumnID>frozen_sqft</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Meat Sqft</ID>
<Name>Meat Sqft</Name>
<EstimatedCount>21</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>Double</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_store</TableID>
<ColumnID>meat_sqft</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Coffee Bar</ID>
<Name>Coffee Bar</Name>
<EstimatedCount>2</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>Boolean</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_store</TableID>
<ColumnID>coffee_bar</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Video Store</ID>
<Name>Video Store</Name>
<EstimatedCount>2</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>Boolean</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_store</TableID>
<ColumnID>video_store</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Salad Bar</ID>
<Name>Salad Bar</Name>
<EstimatedCount>2</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>Boolean</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_store</TableID>
<ColumnID>salad_bar</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Prepared Food</ID>
<Name>Prepared Food</Name>
<EstimatedCount>2</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>Boolean</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_store</TableID>
<ColumnID>prepared_food</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Florist</ID>
<Name>Florist</Name>
<EstimatedCount>2</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>Boolean</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_store</TableID>
<ColumnID>florist</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
</Attributes>
<Hierarchies>
<Hierarchy>
<ID>Store Country - Store State</ID>
<Name>Store Country - Store State</Name>
<Levels>
<Level>
<ID>Store Country</ID>
<Name>Store Country</Name>
<SourceAttributeID>Store Country</SourceAttributeID>
</Level>
<Level>
<ID>Store State</ID>
<Name>Store State</Name>
<SourceAttributeID>Store State</SourceAttributeID>
</Level>
<Level>
<ID>Store</ID>
<Name>Store</Name>
<SourceAttributeID>Store</SourceAttributeID>
</Level>
</Levels>
</Hierarchy>
</Hierarchies>
</Dimension>
<Dimension>
<ID>Customer</ID>
<Name>Customer</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>
</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>0</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>
<Value>0</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>
<Value>0</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>Foodmartsale DW</DataSourceViewID>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -