📄 foodmartsale dw.cube
字号:
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>
<Value>-2493</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name>
<Value>1517</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name>
<Value>75</Value>
</Annotation>
</Annotations>
<LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
<State>Unprocessed</State>
<Dimensions>
<Dimension dwd:design-time-name="c5cf71d3-9745-4075-9555-e2cceec5711b">
<ID>Time By Day</ID>
<Name>Time By Day</Name>
<DimensionID>Time By Day</DimensionID>
<Attributes>
<Attribute dwd:design-time-name="ffa52744-edda-400d-8771-76a8793a7205">
<AttributeID>年</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="ee9306aa-a40d-40cd-87be-cadadd39ece6">
<AttributeID>季度</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="69357955-c5e7-4275-a228-847e951fd986">
<AttributeID>月份</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="aa984929-9be3-4672-abde-f5baf4c58994">
<AttributeID>日期</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="ab48c60d-6ba4-4d77-8a6d-872bda22dba0">
<AttributeID>time_id</AttributeID>
</Attribute>
</Attributes>
<Hierarchies>
<Hierarchy dwd:design-time-name="69c6f43f-e7ed-463d-89d1-bda8c166843d">
<HierarchyID>the_year - quarter - the_month - the_day</HierarchyID>
</Hierarchy>
</Hierarchies>
</Dimension>
<Dimension dwd:design-time-name="fb7908ba-c2d9-48d0-84d2-e28009e8ef7a">
<ID>Promotion</ID>
<Name>Promotion</Name>
<DimensionID>Promotion</DimensionID>
<Attributes>
<Attribute dwd:design-time-name="b3987c26-b742-4e54-a981-bbea623dabb2">
<AttributeID>Promotion</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="de776ef2-0927-4aed-96bb-16f620752835">
<AttributeID>Promotion District Id</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="bc87b9c9-df94-46c7-885b-ce6dbb8e6854">
<AttributeID>Promotion Name</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="3ad5d563-55d2-4a28-8587-1eadebbd695a">
<AttributeID>Media Type</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="12208bbe-5a16-4987-a04d-4ebb38a6f8e4">
<AttributeID>Cost</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="4993a00a-10bd-4d17-9744-51b567244883">
<AttributeID>Start Date</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="f6719faf-5663-49e1-bf02-2008aea71a06">
<AttributeID>End Date</AttributeID>
</Attribute>
</Attributes>
</Dimension>
<Dimension dwd:design-time-name="3fe56acc-c717-4b0b-85ef-944a5833ec72">
<ID>Store</ID>
<Name>Store</Name>
<DimensionID>Store</DimensionID>
<Attributes>
<Attribute dwd:design-time-name="57fe7e21-5ee1-46bb-9d66-ec0114c94b3c">
<AttributeID>Store</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="01aa82b1-90ba-4523-b2a6-0854b65ac16e">
<AttributeID>Store Type</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="889cd673-bd75-4daf-878c-243ca65a5068">
<AttributeID>Region Id</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="629fd605-7c5d-4dde-98db-6b8a334e46c6">
<AttributeID>Store Name</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="9f7427f2-12da-43a7-9a33-fe23e5b92dc2">
<AttributeID>Store Number</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="dc0a91ff-f5be-47a3-b768-56af2ecd997a">
<AttributeID>Store Street Address</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="e4553160-2229-4867-bb74-8ec551de2c23">
<AttributeID>Store City</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="e1960cee-48bc-40b1-a83c-6c384b46fe8f">
<AttributeID>Store State</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="f3bf9078-e74f-44dc-b35c-a25b5a8c5a04">
<AttributeID>Store Postal Code</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="3e5b7dd7-4e90-4b1e-8836-f4e2e9854aaa">
<AttributeID>Store Country</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="5ef9efb5-8cc8-47b9-add8-f4677e2d4f15">
<AttributeID>Store Manager</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="2a6208d6-e026-4203-80ff-8a2d44db1446">
<AttributeID>Store Phone</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="043a1802-4de5-4b40-ad4b-08201be227f7">
<AttributeID>Store Fax</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="66120bea-bf45-4187-8a61-b6301124d74c">
<AttributeID>First Opened Date</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="ff05e3db-5602-4826-b75f-bb85c835ccf5">
<AttributeID>Last Remodel Date</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="d0846d9d-5002-4e28-aed7-c39dc69127c2">
<AttributeID>Lease Sqft</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="53a78134-ebc3-402b-a5ae-53ed02538dfb">
<AttributeID>Store Sqft</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="db16b5ad-9a0e-4cf5-bf6c-5760abd95270">
<AttributeID>Grocery Sqft</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="4474b7bc-56db-4924-9833-1d7146853b82">
<AttributeID>Frozen Sqft</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="cf76a0c1-b3e3-4bbf-a4f0-dcb1b382372b">
<AttributeID>Meat Sqft</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="1f136278-980f-4ec9-ae0c-adfa71c554eb">
<AttributeID>Coffee Bar</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="1fadb202-4522-4f82-bc5f-c10793c2bc12">
<AttributeID>Video Store</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="73ec25d6-61ea-4cd4-bbe2-101f28ecf1f2">
<AttributeID>Salad Bar</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="ccff3b7d-6e3e-43d1-8464-eaf878fe6e32">
<AttributeID>Prepared Food</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="84d37d8b-f191-404c-b945-1e4a116f449a">
<AttributeID>Florist</AttributeID>
</Attribute>
</Attributes>
<Hierarchies>
<Hierarchy dwd:design-time-name="e5aa5497-68a2-4677-a1a1-2384da0b0167">
<HierarchyID>Store Country - Store State</HierarchyID>
</Hierarchy>
</Hierarchies>
</Dimension>
<Dimension dwd:design-time-name="5981d3fb-ec7e-4665-9e31-ffaa8d096107">
<ID>Customer</ID>
<Name>Customer</Name>
<DimensionID>Customer</DimensionID>
<Attributes>
<Attribute dwd:design-time-name="00004f9c-a2ac-4c65-aa11-e62bd528343c">
<AttributeID>Customer</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="a73af9dc-c597-450c-b67b-6ac8d8ec6a72">
<AttributeID>Account Num</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="e3362143-7025-4aa3-a8ea-9718432c48f2">
<AttributeID>Lname</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="78221903-df7d-4ce1-818d-2a2d39a3b89f">
<AttributeID>Fname</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="7e21330d-ad34-4e67-abda-dc3e00753ec9">
<AttributeID>Mi</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="878d61e3-8e9d-4e31-84fe-2fc73aadf300">
<AttributeID>Address1</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="d23c6e1d-d218-491e-b4d2-f49d72807281">
<AttributeID>Address2</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="54cd5c1e-14dd-4e6c-b0cb-06e36479b7e0">
<AttributeID>Address3</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="6ce408a9-f4a1-43f8-bb0d-fea7046b5a5f">
<AttributeID>Address4</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="3d78b7b9-6d02-44fb-94d8-68102f9fd0fb">
<AttributeID>City</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="7895bafc-12c1-4c27-bc36-f706bb942666">
<AttributeID>State Province</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="e110255d-0635-4b61-9786-ab9090f7966f">
<AttributeID>Postal Code</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="970c1207-e1e3-45de-9a8b-3cf6e2e360e0">
<AttributeID>Country</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="57f7f1b6-45ef-4122-9a41-835e8abb6995">
<AttributeID>Customer Region Id</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="ba987355-5973-450f-b661-2ea342260120">
<AttributeID>Phone1</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="4b8ca779-0253-4829-9e35-62cb1272c17b">
<AttributeID>Phone2</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="fe927999-9077-4a56-8673-7925019e258e">
<AttributeID>Birthdate</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="1f49825e-d3f3-4408-bfcd-d3ce4072d194">
<AttributeID>Marital Status</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="8bca3a48-ee73-4dcf-8de5-42a0b7350e5c">
<AttributeID>Yearly Income</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="b0c70fb6-42e0-4061-91dc-b9f20af064ac">
<AttributeID>Gender</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="b4debea4-5749-41fe-a8db-93d7b0889627">
<AttributeID>Total Children</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="8fd5f2b9-6699-4692-86f4-eb33c948134d">
<AttributeID>Num Children At Home</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="27113289-25f5-4be5-8a0d-ce34d11a4519">
<AttributeID>Education</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="bb0f7cb5-c937-4949-a8d3-6b7737747bfb">
<AttributeID>Date Accnt Opened</AttributeID>
</Attribute>
<Attribute dwd:design-time-name="f381851e-4ead-4309-9524-3749b65371b3">
<AttributeID>Member Card</AttributeID>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -