📄 财务管理.cube

📁 SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德利,出版日期：2007-10-01 页　数： 383 出版社：电子工业
💻 CUBE
📖 第 1 页 / 共 2 页
字号:
上一页 12
        <Attribute dwd:design-time-name="e16a54c8-ad9a-4c83-9adc-a14c8491f3b5">
          <AttributeID>日期</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="c4adeb42-130b-433f-bd85-0a4cc463435e">
          <AttributeID>每年的某一日</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="45e09fa4-a33a-47dd-adee-ed95225735ea">
          <AttributeID>每半年的某一日</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="25d59ef3-6fe3-4622-9d39-6af40ba21799">
          <AttributeID>每个季度的某一日</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="e874e32f-d725-4657-be42-bcb8e323a0bb">
          <AttributeID>每月的某一日</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="44c480da-65b4-4189-9abc-8ce02d15e5cd">
          <AttributeID>每周的某一日</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="82318c6f-9d2a-48ea-8d80-ab8c276f09fd">
          <AttributeID>每年的某一周</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="11ec9be8-7634-4722-ab90-263fbaa9b8a1">
          <AttributeID>每年的某一月</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="68451ec9-2458-4ed9-bc43-ecf84ebe5444">
          <AttributeID>每半年的某一月</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="8e0783a3-2c88-4385-b0bf-0fc67021a542">
          <AttributeID>每个季度的某一月</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="786e2396-fc51-412e-bc40-5b66c264dd62">
          <AttributeID>每年的某一季度</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="d5cc6553-014f-4d98-8c2f-30e3445186e2">
          <AttributeID>每半年的某一季度</AttributeID>
        </Attribute>
        <Attribute dwd:design-time-name="52b0e4a1-ab2c-4a28-92a1-5d90040ea32c">
          <AttributeID>每年的某一半年</AttributeID>
        </Attribute>
      </Attributes>
      <Hierarchies>
        <Hierarchy dwd:design-time-name="b4417825-5852-4707-8928-d6a40711f334">
          <HierarchyID>年 -  半年 -  季度 -  月份 -  日期</HierarchyID>
        </Hierarchy>
        <Hierarchy dwd:design-time-name="0c3676cb-5b7f-4ca1-acd7-6c830cd8a3c7">
          <HierarchyID>年 -  周 -  日期</HierarchyID>
        </Hierarchy>
      </Hierarchies>
    </Dimension>
    <Dimension dwd:design-time-name="d9150c97-fe07-4173-bf33-88a3b2484add">
      <ID>客户</ID>
      <Name>客户</Name>
      <DimensionID>客户</DimensionID>
      <Attributes>
        <Attribute dwd:design-time-name="47465f44-5a04-489d-ae74-b50f3177a901">
          <AttributeID>客户</AttributeID>
        </Attribute>
      </Attributes>
    </Dimension>
    <Dimension dwd:design-time-name="efa7bdd2-2630-46dd-adad-0c656002f5ba">
      <ID>地区</ID>
      <Name>地区</Name>
      <DimensionID>地区</DimensionID>
      <Attributes>
        <Attribute dwd:design-time-name="9d796d63-7d57-4dbc-95f4-429c29308044">
          <AttributeID>地区</AttributeID>
        </Attribute>
      </Attributes>
    </Dimension>
    <Dimension dwd:design-time-name="742f898b-8189-48af-8f1d-b5ea1e0a0998">
      <ID>产品</ID>
      <Name>产品</Name>
      <DimensionID>产品</DimensionID>
      <Attributes>
        <Attribute dwd:design-time-name="d5a73bd1-136a-4dca-b3ef-ed9a9b6abae5">
          <AttributeID>产品</AttributeID>
        </Attribute>
      </Attributes>
    </Dimension>
  </Dimensions>
  <MeasureGroups>
    <MeasureGroup dwd:design-time-name="f5d24607-2b2b-4f35-9904-c8b2ad8eb1e6">
      <ID>财务管理</ID>
      <Name>财务管理</Name>
      <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
      <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
      <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
      <State>Unprocessed</State>
      <Measures>
        <Measure dwd:design-time-name="53f08074-719a-4e62-b229-c6cc3f904866">
          <ID>收入</ID>
          <Name>收入</Name>
          <Source dwd:design-time-name="a8032db2-532d-4f63-9f22-1b380bc7a3af">
            <DataType>Single</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="95f3eb1d-3e93-4f99-b2bd-c056af32d780">
              <TableID>财务管理</TableID>
              <ColumnID>收入</ColumnID>
            </Source>
          </Source>
        </Measure>
        <Measure dwd:design-time-name="72b8c353-95a3-4b36-8d30-a742fa27b9dd">
          <ID>成本</ID>
          <Name>成本</Name>
          <Source dwd:design-time-name="2fec2dc3-eda2-403b-95e3-3ce9253219b1">
            <DataType>Single</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="12bb81c3-55d8-4b4f-abe0-16c9afcbea40">
              <TableID>财务管理</TableID>
              <ColumnID>成本</ColumnID>
            </Source>
          </Source>
        </Measure>
        <Measure dwd:design-time-name="49bb2568-c5d8-4118-9e18-aa37a3a2b7c0">
          <ID>费用</ID>
          <Name>费用</Name>
          <Source dwd:design-time-name="9063d911-1516-424a-8e0a-9b60ef6c017a">
            <DataType>Single</DataType>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="6a9ccaa2-471a-4ffb-b0ca-6c11d2927e7c">
              <TableID>财务管理</TableID>
              <ColumnID>费用</ColumnID>
            </Source>
          </Source>
        </Measure>
      </Measures>
      <StorageMode>Molap</StorageMode>
      <ProcessingMode>Regular</ProcessingMode>
      <Dimensions>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="1c1d2c80-f461-4949-a7e2-576f9b8cd3cf">
          <CubeDimensionID>时间</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="5749fd96-50d4-4967-8a6e-4a890700b7e7">
              <AttributeID>日期</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="e93945c1-62d9-4f34-90f3-71e9b0242abf">
                  <DataType>Date</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="25675496-6d3b-4e27-ae47-b555057ab95a">
                    <TableID>财务管理</TableID>
                    <ColumnID>FK_时间</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="b511624d-2eaa-49b8-ba80-e4e3103b3e6d">
          <CubeDimensionID>客户</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="544a8d10-4bae-48fb-8a39-aba892d06100">
              <AttributeID>客户</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="a5a9d05e-d063-41a4-b156-e82a7105842b">
                  <DataType>Integer</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="835357f0-2789-48f1-9666-ac7c2ff03c0b">
                    <TableID>财务管理</TableID>
                    <ColumnID>FK_客户</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="e6585086-e34d-49be-a96e-ff6f557cdd55">
          <CubeDimensionID>地区</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="187a3d14-68ed-40b7-a26c-8b2160e58566">
              <AttributeID>地区</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="a8ed3bd6-31aa-4d64-92fc-921253e099a3">
                  <DataType>Integer</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="7af99847-752b-44de-afb5-c0b46614d50f">
                    <TableID>财务管理</TableID>
                    <ColumnID>FK_地区</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="68c24d33-35b7-4067-8f83-c6ca142f2cb4">
          <CubeDimensionID>产品</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="3517952e-e388-44ba-9155-51b40f1513c0">
              <AttributeID>产品</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="e63b7e16-a735-4454-a6b8-5d8df9483b23">
                  <DataType>Integer</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="9839b3f1-1fe4-4c74-90ba-78da733ba299">
                    <TableID>财务管理</TableID>
                    <ColumnID>FK_产品</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
      </Dimensions>
      <Partitions />
    </MeasureGroup>
  </MeasureGroups>
  <Source dwd:design-time-name="a670601b-f072-46dc-8daf-9ce9ac15de3d">
    <DataSourceViewID>自上而下创建的cube</DataSourceViewID>
  </Source>
</Cube>
上一页 12
⌨️ 快捷键说明

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