📄 foodmartsale as.asdatabase
字号:
<ColumnID>phone1</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>MandatoryFilter</InstanceSelection>
</Attribute>
<Attribute>
<ID>Phone2</ID>
<Name>Phone2</Name>
<KeyColumns>
<KeyColumn>
<DataType>WChar</DataType>
<DataSize>50</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_customer</TableID>
<ColumnID>phone2</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>MandatoryFilter</InstanceSelection>
</Attribute>
<Attribute>
<ID>Birthdate</ID>
<Name>Birthdate</Name>
<KeyColumns>
<KeyColumn>
<DataType>Date</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_customer</TableID>
<ColumnID>birthdate</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>MandatoryFilter</InstanceSelection>
</Attribute>
<Attribute>
<ID>Marital Status</ID>
<Name>Marital Status</Name>
<EstimatedCount>2</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>WChar</DataType>
<DataSize>1</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_customer</TableID>
<ColumnID>marital_status</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Yearly Income</ID>
<Name>Yearly Income</Name>
<EstimatedCount>8</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>WChar</DataType>
<DataSize>50</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_customer</TableID>
<ColumnID>yearly_income</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Gender</ID>
<Name>Gender</Name>
<EstimatedCount>2</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>WChar</DataType>
<DataSize>1</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_customer</TableID>
<ColumnID>gender</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Total Children</ID>
<Name>Total Children</Name>
<EstimatedCount>6</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>SmallInt</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_customer</TableID>
<ColumnID>total_children</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Num Children At Home</ID>
<Name>Num Children At Home</Name>
<EstimatedCount>6</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>SmallInt</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_customer</TableID>
<ColumnID>num_children_at_home</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Education</ID>
<Name>Education</Name>
<EstimatedCount>5</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>WChar</DataType>
<DataSize>30</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_customer</TableID>
<ColumnID>education</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Date Accnt Opened</ID>
<Name>Date Accnt Opened</Name>
<KeyColumns>
<KeyColumn>
<DataType>Date</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_customer</TableID>
<ColumnID>date_accnt_opened</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>MandatoryFilter</InstanceSelection>
</Attribute>
<Attribute>
<ID>Member Card</ID>
<Name>Member Card</Name>
<EstimatedCount>4</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>WChar</DataType>
<DataSize>50</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_customer</TableID>
<ColumnID>member_card</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Occupation</ID>
<Name>Occupation</Name>
<EstimatedCount>5</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>WChar</DataType>
<DataSize>50</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_customer</TableID>
<ColumnID>occupation</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Houseowner</ID>
<Name>Houseowner</Name>
<EstimatedCount>2</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>WChar</DataType>
<DataSize>1</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_customer</TableID>
<ColumnID>houseowner</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
<Attribute>
<ID>Num Cars Owned</ID>
<Name>Num Cars Owned</Name>
<EstimatedCount>5</EstimatedCount>
<KeyColumns>
<KeyColumn>
<DataType>SmallInt</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_customer</TableID>
<ColumnID>num_cars_owned</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
</Attribute>
</Attributes>
<Hierarchies>
<Hierarchy>
<ID>Country - State Province - Customer Region Id</ID>
<Name>Country - State Province - Customer Region Id</Name>
<Levels>
<Level>
<ID>Country</ID>
<Name>Country</Name>
<SourceAttributeID>Country</SourceAttributeID>
</Level>
<Level>
<ID>State Province</ID>
<Name>State Province</Name>
<SourceAttributeID>State Province</SourceAttributeID>
</Level>
<Level>
<ID>Customer Region Id</ID>
<Name>Customer Region Id</Name>
<SourceAttributeID>Customer Region Id</SourceAttributeID>
</Level>
<Level>
<ID>Customer</ID>
<Name>Customer</Name>
<SourceAttributeID>Customer</SourceAttributeID>
</Level>
</Levels>
</Hierarchy>
</Hierarchies>
</Dimension>
<Dimension>
<ID>Product</ID>
<Name>Product</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>
</Source>
<UnknownMember>Visible</UnknownMember>
<CurrentStorageMode>Molap</CurrentStorageMode>
<Attributes>
<Attribute>
<ID>Product</ID>
<Name>Product</Name>
<Usage>Key</Usage>
<EstimatedCount>1560</EstimatedCount>
<KeyColumns>
<KeyColumn>
<NullProcessing>UnknownMember</NullProcessing>
<DataType>Integer</DataType>
<Source xsi:type="ColumnBinding">
<TableID>dbo_product</TableID>
<ColumnID>product_id</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
<NameColumn>
<DataType>WChar</DataType>
<DataSize>255</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_product</TableID>
<ColumnID>product_name</ColumnID>
</Source>
</NameColumn>
<AttributeRelationships>
<AttributeRelationship>
<AttributeID>Brand Name</AttributeID>
<Name>Brand Name</Name>
</AttributeRelationship>
<AttributeRelationship>
<AttributeID>SKU</AttributeID>
<Name>SKU</Name>
</AttributeRelationship>
<AttributeRelationship>
<AttributeID>SRP</AttributeID>
<Name>SRP</Name>
</AttributeRelationship>
<AttributeRelationship>
<AttributeID>Gross Weight</AttributeID>
<Name>Gross Weight</Name>
</AttributeRelationship>
<AttributeRelationship>
<AttributeID>Net Weight</AttributeID>
<Name>Net Weight</Name>
</AttributeRelationship>
<AttributeRelationship>
<AttributeID>Recyclable Package</AttributeID>
<Name>Recyclable Package</Name>
</AttributeRelationship>
<AttributeRelationship>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -