首页 › 资源下载 › SQL Server › < SQL Server2005程 › 源码查看
sales.cube

来自「< SQL Server2005程序设计>」· CUBE 代码 · 共 1,134 行 · 第 1/4 页
CUBE
1,134 行
          <AttributeID>Day of Month</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="7a48d656-3d76-47f0-a177-a210d90f80ca">
          <AttributeID>Month of Year</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="edf2244d-b93e-4e3e-9149-0eb960ba7146">
          <AttributeID>Month of Quarter</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="587a55f7-43b3-470a-9d2e-32b2eccd6cb7">
          <AttributeID>Quarter of Year</AttributeID>
        </Attribute>
      </Attributes>
      <Hierarchies>
        <Hierarchy dwd:design-time-name="dc66f0da-b1c3-4891-b200-fc1b29954fe6">
          <HierarchyID>Year -  Quarter -  Month -  Date</HierarchyID>
        </Hierarchy>
      </Hierarchies>
    </Dimension>
  </Dimensions>
  <CubePermissions>
    <CubePermission dwd:design-time-name="240c5067-d09f-46ca-b9c0-d98e21666c29">
      <ID>CubePermission</ID>
      <Name>CubePermission</Name>
      <CreatedTimestamp>0001-01-01T05:00:00Z</CreatedTimestamp>
      <LastSchemaUpdate>0001-01-01T05:00:00Z</LastSchemaUpdate>
      <RoleID>Role</RoleID>
      <Read>Allowed</Read>
      <ReadSourceData>None</ReadSourceData>
      <DimensionPermissions>
        <DimensionPermission dwd:design-time-name="e4a16287-1125-40c3-8e13-4bb6e720083e">
          <CubeDimensionID>Vw Geography</CubeDimensionID>
          <Read>Allowed</Read>
          <AttributePermissions>
            <AttributePermission dwd:design-time-name="c7906e2c-bc84-48de-a217-595b30e4b0bb">
              <AttributeID>Country</AttributeID>
              <AllowedSet>{[Geography].[Country].&amp;[Canada], [Geography].[Country].&amp;[Mexico], [Geography].[Country].&amp;[USA]}</AllowedSet>
            </AttributePermission>
          </AttributePermissions>
        </DimensionPermission>
        <DimensionPermission dwd:design-time-name="3f460a03-18a4-4a77-a942-54b86e802a32">
          <CubeDimensionID>ServerTime</CubeDimensionID>
          <Read>Allowed</Read>
          <AttributePermissions>
            <AttributePermission dwd:design-time-name="06d538c9-0bb4-4de7-b642-3fb56a4ddb0c">
              <AttributeID>Date</AttributeID>
              <AllowedSet>{}</AllowedSet>
            </AttributePermission>
            <AttributePermission dwd:design-time-name="5f793b42-d313-4930-b5fe-995e11d6e418">
              <AttributeID>Day of Month</AttributeID>
              <AllowedSet>{}</AllowedSet>
            </AttributePermission>
            <AttributePermission dwd:design-time-name="c4a8b09e-b909-45ff-849e-367518aad976">
              <AttributeID>Day of Year</AttributeID>
              <AllowedSet>{}</AllowedSet>
            </AttributePermission>
            <AttributePermission dwd:design-time-name="ca9cd75f-9586-4849-bb93-4964f3749f83">
              <AttributeID>Month of Quarter</AttributeID>
              <AllowedSet>{}</AllowedSet>
            </AttributePermission>
            <AttributePermission dwd:design-time-name="38bd7124-aab4-4fd3-81db-773c9ec668f8">
              <AttributeID>Month</AttributeID>
              <AllowedSet>{}</AllowedSet>
            </AttributePermission>
            <AttributePermission dwd:design-time-name="71d52077-5d35-47d0-a903-509eb4ce33b7">
              <AttributeID>Month of Year</AttributeID>
              <AllowedSet>{}</AllowedSet>
            </AttributePermission>
            <AttributePermission dwd:design-time-name="b0e8d9d3-93f3-40f8-893b-209931f8e09b">
              <AttributeID>Quarter</AttributeID>
              <AllowedSet>{}</AllowedSet>
            </AttributePermission>
            <AttributePermission dwd:design-time-name="0be4be8b-0068-4d04-9441-6ee1fbdc5d36">
              <AttributeID>Quarter of Year</AttributeID>
              <AllowedSet>{}</AllowedSet>
            </AttributePermission>
            <AttributePermission dwd:design-time-name="85f0d8d1-d90f-4cf8-9528-b55542b4d935">
              <AttributeID>Year</AttributeID>
              <AllowedSet>{}</AllowedSet>
            </AttributePermission>
            <AttributePermission dwd:design-time-name="9072eab3-1e95-4db1-a7f3-2004e75a33c9">
              <AttributeID>Day of Quarter</AttributeID>
              <AllowedSet>{}</AllowedSet>
            </AttributePermission>
          </AttributePermissions>
        </DimensionPermission>
      </DimensionPermissions>
    </CubePermission>
  </CubePermissions>
  <Perspectives>
    <Perspective dwd:design-time-name="796f4050-ebb5-43a2-8ab2-b781accdf935">
      <ID>Perspective</ID>
      <Name>Product Info</Name>
      <CreatedTimestamp>0001-01-01T05:00:00Z</CreatedTimestamp>
      <LastSchemaUpdate>0001-01-01T05:00:00Z</LastSchemaUpdate>
      <Dimensions>
        <Dimension dwd:design-time-name="45478a21-2e5d-407b-8baf-c1f8452ca972">
          <CubeDimensionID>Vw Products</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="c3bd262f-b79e-4759-b919-9464c0f20bdf">
              <AttributeID>Vw Products</AttributeID>
            </Attribute>
            <Attribute dwd:design-time-name="51daba88-7876-4d3d-81b9-3d4c61e97aa7">
              <AttributeID>Category Name</AttributeID>
            </Attribute>
            <Attribute dwd:design-time-name="6485a26b-8701-416d-9567-6694586c5882">
              <AttributeID>Product Name 1</AttributeID>
            </Attribute>
          </Attributes>
          <Hierarchies>
            <Hierarchy dwd:design-time-name="22c67b68-35b0-4f2e-842b-9032fb1a3c10">
              <HierarchyID>Hierarchy</HierarchyID>
            </Hierarchy>
            <Hierarchy dwd:design-time-name="bbc974c3-2fd8-487d-9817-fa6096a84042">
              <HierarchyID>Hierarchy 1</HierarchyID>
            </Hierarchy>
          </Hierarchies>
        </Dimension>
        <Dimension dwd:design-time-name="8b5f44ef-35d5-4cc9-8a5c-3a472fe9f2c0">
          <CubeDimensionID>Vw Suppliers</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="226ef4c0-c709-4791-ab5d-bca7111de5d2">
              <AttributeID>Vw Suppliers</AttributeID>
            </Attribute>
            <Attribute dwd:design-time-name="c8d91c02-a0b4-4ed7-ac22-232e490c7a40">
              <AttributeID>Supplier Name</AttributeID>
            </Attribute>
          </Attributes>
        </Dimension>
      </Dimensions>
      <MeasureGroups>
        <MeasureGroup dwd:design-time-name="f21bb73d-5a7b-4a23-afe1-22e3031cbec3">
          <MeasureGroupID>Tbl Fact</MeasureGroupID>
          <Measures>
            <Measure dwd:design-time-name="56ce1135-eff2-43d6-9afb-e0d79010788d">
              <MeasureID>Total Sales</MeasureID>
            </Measure>
            <Measure dwd:design-time-name="eda7e55b-cd6e-4a4b-b752-d47970127598">
              <MeasureID>Discount</MeasureID>
            </Measure>
            <Measure dwd:design-time-name="5ebd812b-57b0-49dd-b997-74977aedeb59">
              <MeasureID>Unit Sales</MeasureID>
            </Measure>
            <Measure dwd:design-time-name="55570168-cd91-4f71-87bc-bc5ef4d0de64">
              <MeasureID>Total Sales - Main</MeasureID>
            </Measure>
          </Measures>
        </MeasureGroup>
      </MeasureGroups>
      <Calculations>
        <Calculation dwd:design-time-name="0eb091e8-9d71-4529-abe2-ad6e41baba6c">
          <Name>[MEASURES].[Adjusted Sales]</Name>
          <Type>Member</Type>
        </Calculation>
        <Calculation dwd:design-time-name="7a2d6953-0042-4e2b-a14e-e33904930a6f">
          <Name>[MEASURES].[Adjusted Sales Growth]</Name>
          <Type>Member</Type>
        </Calculation>
      </Calculations>
      <Kpis>
        <Kpi dwd:design-time-name="dad2357b-f6b4-4e1e-9347-28c2ed994f2e">
          <KpiID>KPI</KpiID>
        </Kpi>
      </Kpis>
      <Actions>
        <Action dwd:design-time-name="ab4eab88-a825-46d9-b7b3-1e2894cd9d8e">
          <ActionID>Drillthrough Action</ActionID>
        </Action>
      </Actions>
    </Perspective>
  </Perspectives>
  <MeasureGroups>
    <MeasureGroup dwd:design-time-name="7fc83991-7670-44a1-98d3-304aa6ca0971">
      <ID>Tbl Fact</ID>
      <Name>Main</Name>
      <CreatedTimestamp>0001-01-01T05:00:00Z</CreatedTimestamp>
      <LastSchemaUpdate>0001-01-01T05:00:00Z</LastSchemaUpdate>
      <LastProcessed>0001-01-01T05:00:00Z</LastProcessed>
      <State>Unprocessed</State>
      <Measures>
        <Measure dwd:design-time-name="cda4a6d5-6391-42d2-a312-a53dc1ec740d">
          <ID>Total Sales</ID>
          <Name>Total Sales</Name>
          <Source dwd:design-time-name="4e521fb3-5087-4996-9564-0ae4f019e8f4">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="1c820d1c-f944-481c-8439-9af7ca832026">
              <TableID>dbo_tblFact</TableID>
              <ColumnID>Total_x0020_Sales</ColumnID>
            </Source>
          </Source>
          <DisplayFolder>Sum</DisplayFolder>
          <FormatString>Currency</FormatString>
        </Measure>
        <Measure dwd:design-time-name="7a650fcc-9dbd-4fd5-9710-7d68107c89d9">
          <ID>Discount</ID>
          <Name>Discount</Name>
          <Source dwd:design-time-name="2e6dee19-cc16-450b-9bc5-4688d84eeaf3">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="3be98c44-a005-4551-aecc-c645009fa602">
              <TableID>dbo_tblFact</TableID>
              <ColumnID>Discount</ColumnID>
            </Source>
          </Source>
          <DisplayFolder>Sum</DisplayFolder>
          <FormatString>Currency</FormatString>
        </Measure>
        <Measure dwd:design-time-name="36b90c2c-d582-4355-856b-b3a53aa31c09">
          <ID>Unit Sales</ID>
          <Name>Unit Sales</Name>
          <Source dwd:design-time-name="f7852c09-df93-408b-8f70-483885b2b2c5">
            <DataType>Integer</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="9b3a186e-0771-421b-bd78-70581d4c24ad">
              <TableID>dbo_tblFact</TableID>
              <ColumnID>Unit_x0020_Sales</ColumnID>
            </Source>
          </Source>
          <DisplayFolder>Sum</DisplayFolder>
          <FormatString>Currency</FormatString>
        </Measure>
        <Measure dwd:design-time-name="a855ef34-bf28-4eb7-af18-c9e21a15029e">
          <ID>Total Sales - Main</ID>
          <Name>Avg Total Sales</Name>
          <AggregateFunction>AverageOfChildren</AggregateFunction>
          <Source dwd:design-time-name="ceedfd03-6925-4b33-b6af-f7c8e8bb5214">
            <DataType>Double</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="22aaa921-9c00-4397-9e93-ce9b3c88e501">
              <TableID>dbo_tblFact</TableID>
              <ColumnID>Total_x0020_Sales</ColumnID>
            </Source>
          </Source>
          <DisplayFolder>Non-Sum</DisplayFolder>
          <FormatString>Currency</FormatString>
        </Measure>
      </Measures>
      <StorageMode>Molap</StorageMode>
      <EstimatedRows>2155</EstimatedRows>
      <ProcessingMode>Regular</ProcessingMode>
      <Dimensions>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="3def588b-9de9-4ac2-95df-55af3f295e9d">
          <CubeDimensionID>Vw Products</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="878f292b-4773-47ba-8e7a-7f74bf1898e2">
              <AttributeID>Vw Products</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="66e5d140-28fc-4e75-992f-441286cf95e9">
                  <DataType>Integer</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="9652d2fe-6b83-4018-99cb-5c1ed8e215a9">
                    <TableID>dbo_tblFact</TableID>
                    <ColumnID>ProductID</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="a7d824bd-2580-4fd1-b943-2c8e5f79c331">
          <CubeDimensionID>Vw Geography</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="c8131dd3-19b1-4a65-a32a-751cec354aeb">
              <AttributeID>Vw Geography</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="41e2c40d-c543-46fe-a48d-10b0fae9e20f">
                  <NullProcessing>UnknownMember</NullProcessing>
                  <DataType>WChar</DataType>
                  <DataSize>10</DataSize>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="9e374d85-3f0a-475a-9558-49cbbc3fb8e0">
                    <TableID>dbo_tblFact</TableID>
                    <ColumnID>PostalCode</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="20bbc1d4-a5c8-4e5c-aeba-e45462125bce">
          <CubeDimensionID>Vw Suppliers</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="ae363a0b-7389-4d2e-9436-8eb75e50f96b">
              <AttributeID>Vw Suppliers</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="cbf60a77-9056-4149-9b9f-3a7c78da5764">
                  <DataType>Integer</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="d908b80d-383d-45b9-8f48-37f13a994b47">
sales.cube - 源码说明

本页面展示了「< SQL Server2005程序设计>」中的 sales.cube 源码文件，采用 CUBE 编程语言编写，共 1,134 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。
虫虫下载站收录了大量与Server相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。
⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?