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

来自「< SQL Server2005程序设计>」· CUBE 代码 · 共 1,134 行 · 第 1/4 页
CUBE
1,134 行
                    <TableID>dbo_tblFact</TableID>
                    <ColumnID>ProductID</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="b2bee93e-a734-4e72-a174-6902a1594063">
          <CubeDimensionID>Vw Shippers</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="70ec44db-efea-40a1-8e5d-608589943197">
              <AttributeID>Vw Shippers</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="80ecf7bc-ce8c-4a7c-b501-ebcde58a9d5e">
                  <NullProcessing>UnknownMember</NullProcessing>
                  <DataType>Integer</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="3c8a94fd-d723-48fc-bb01-15c2b6622fc6">
                    <TableID>dbo_tblFact</TableID>
                    <ColumnID>ShipperId</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="f1910ba8-9371-4972-9ccf-d9e997ada27a">
          <CubeDimensionID>Vw Employees</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="43594b43-e202-4208-ac85-6c48150234cb">
              <AttributeID>Vw Employees</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="a5d199d4-6446-4cc6-a7de-1b1ef3490ac0">
                  <NullProcessing>UnknownMember</NullProcessing>
                  <DataType>Integer</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="bed243cc-3d70-43e0-84df-5b7202931251">
                    <TableID>dbo_tblFact</TableID>
                    <ColumnID>EmployeeId</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="3899ee78-574b-4613-ba7b-80dde8966b9f">
          <CubeDimensionID>Time</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="d3caef9c-9eb2-4954-a922-e8385be85166">
              <AttributeID>TimeKey</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="582c5ec1-d91f-4fdc-abd3-6f9d1d6867ce">
                  <DataType>Integer</DataType>
                  <DataSize>-1</DataSize>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="63f7d4b3-3358-4fd6-b2b7-6a4679ae2c27">
                    <TableID>dbo_tblFact</TableID>
                    <ColumnID>TimeKey</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="db912a0a-c226-4154-8304-e912d6cd4475">
          <CubeDimensionID>OrgChart</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="73fd0217-ed81-4230-90d3-07ed47f79569">
              <AttributeID>Employees</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="79ae41a2-bf40-4495-bcd9-0306dbccad17">
                  <DataType>Integer</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="60dddc26-5ba4-41ff-8beb-23588f953197">
                    <TableID>dbo_tblFact</TableID>
                    <ColumnID>EmployeeId</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="DegenerateMeasureGroupDimension" dwd:design-time-name="93b5ba8c-a02c-46d2-b6f0-f8952c651786">
          <CubeDimensionID>Ship Geography</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="d1ccf5af-b35f-489b-b9d0-bb2fb1a21761">
              <AttributeID>Tbl Fact</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="dfc7aad8-6343-48a1-8e2d-f1a8a35c30e3">
                  <DataType>WChar</DataType>
                  <DataSize>15</DataSize>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="3f171650-0c97-4b9d-a0b8-3594ef23909b">
                    <TableID>dbo_tblFact</TableID>
                    <ColumnID>ShipRegion</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="dbda33f7-ec50-4b8c-ad7a-db5d977553b7">
          <CubeDimensionID>ServerTime</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="b4450814-1db1-49fe-a878-3e668b43449b">
              <AttributeID>Date</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="e0b9148e-9cf8-4182-bee5-4b5513e17ada">
                  <DataType>Date</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="e9f28811-56ea-4ab7-84f7-638dabe0dc06">
                    <TableID>dbo_tblFact</TableID>
                    <ColumnID>OrderDate</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="48ffaebc-e5dc-41d4-b73d-99bd25518f94">
          <CubeDimensionID>ServerTime 1</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="6b670f7d-0032-430c-989f-6e0f47d3ecd1">
              <AttributeID>Date</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="0a5006f4-8241-49b5-b41f-d507d1ff4372">
                  <DataType>Date</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="27c7841b-9429-4d5a-9f36-203877d9c10b">
                    <TableID>dbo_tblFact</TableID>
                    <ColumnID>ShippedDate</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
        <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="9e283b4d-b312-43b7-a770-1b0671b9fe35">
          <CubeDimensionID>ServerTime 2</CubeDimensionID>
          <Attributes>
            <Attribute dwd:design-time-name="803f246e-cb6f-4265-bf3a-ca22b3261064">
              <AttributeID>Date</AttributeID>
              <KeyColumns>
                <KeyColumn dwd:design-time-name="fafeea4d-8ae0-435e-a620-8dbf1ebb9dbb">
                  <DataType>Date</DataType>
                  <Source xsi:type="ColumnBinding" dwd:design-time-name="dd6c052e-9ccc-4064-92d0-94c51161ba4a">
                    <TableID>dbo_tblFact</TableID>
                    <ColumnID>RequiredDate</ColumnID>
                  </Source>
                </KeyColumn>
              </KeyColumns>
              <Type>Granularity</Type>
            </Attribute>
          </Attributes>
        </Dimension>
      </Dimensions>
      <Partitions />
      <AggregationDesigns />
      <ProactiveCaching dwd:design-time-name="1ed0db4c-aae2-4e38-b423-fa108cc2c3fd">
        <SilenceInterval>PT10S</SilenceInterval>
        <Latency>-PT1S</Latency>
        <SilenceOverrideInterval>PT10M</SilenceOverrideInterval>
        <ForceRebuildInterval>-PT1S</ForceRebuildInterval>
        <Enabled>true</Enabled>
        <OnlineMode>OnCacheComplete</OnlineMode>
        <AggregationStorage>MolapOnly</AggregationStorage>
      </ProactiveCaching>
    </MeasureGroup>
  </MeasureGroups>
  <Source dwd:design-time-name="1b38a3dd-7b36-4a7a-b856-3a5b751fad95">
    <DataSourceViewID>Northwind</DataSourceViewID>
  </Source>
  <MdxScripts>
    <MdxScript dwd:design-time-name="73fa05d5-48c2-4ab4-b9b3-cdaf3455e291">
      <ID>MdxScript</ID>
      <Name>MdxScript</Name>
      <CreatedTimestamp>0001-01-01T05:00:00Z</CreatedTimestamp>
      <LastSchemaUpdate>0001-01-01T05:00:00Z</LastSchemaUpdate>
      <Commands>
        <Command>
          <Text>/*
The CALCULATE command controls the aggregation of leaf cells in the cube.
If the CALCULATE command is deleted or modified, the data within the cube is affected.
You should edit this command only if you manually specify how the cube is aggregated.
*/
CALCULATE;    
CREATE MEMBER CURRENTCUBE.[MEASURES].[Adjusted Sales]
 AS [Measures].[Total Sales] - [Measures].[Discount], 
FORMAT_STRING = "Currency", 
VISIBLE = 1;  
CREATE MEMBER CURRENTCUBE.[MEASURES].[Adjusted Sales Growth]
 AS Case
    When [Order Date].[Year -  Quarter -  Month -  Date].CURRENTMEMBER.LEVEL.ORDINAL = 0 Then 
        NULL
    When ISEMPTY(([Order Date].[Year -  Quarter -  Month -  Date].PREVMEMBER, [Measures].[Adjusted Sales])) Then
        "EMPTY"
    Else
        [Measures].[Adjusted Sales]/([Order Date].[Year -  Quarter -  Month -  Date].PREVMEMBER, [Measures].[Adjusted Sales]) - 1
End, 
FORMAT_STRING = "Percent", 
VISIBLE = 1;  
CREATE SET CURRENTCUBE.[Test Markets]
 AS {[Geography].[City].&amp;[Albuquerque], [Geography].[City].&amp;[Boise], [Geography].[City].&amp;[Kirkland]}; </Text>
        </Command>
      </Commands>
      <CalculationProperties>
        <CalculationProperty dwd:design-time-name="c70e62d8-ce3b-4ba7-bd7d-894d28b28d65">
          <CalculationReference>[MEASURES].[Adjusted Sales]</CalculationReference>
          <CalculationType>Member</CalculationType>
          <AssociatedMeasureGroupID>Tbl Fact</AssociatedMeasureGroupID>
          <DisplayFolder>Sum</DisplayFolder>
        </CalculationProperty>
        <CalculationProperty dwd:design-time-name="c7b8fa36-b386-4b12-b118-9f8540d8163b">
          <CalculationReference>[MEASURES].[Adjusted Sales Growth]</CalculationReference>
          <CalculationType>Member</CalculationType>
          <AssociatedMeasureGroupID>Tbl Fact</AssociatedMeasureGroupID>
          <DisplayFolder>Sum</DisplayFolder>
        </CalculationProperty>
      </CalculationProperties>
    </MdxScript>
  </MdxScripts>
  <Kpis>
    <Kpi dwd:design-time-name="2af335af-2375-4f99-876d-f11243cb8c62">
      <ID>KPI</ID>
      <Name>Average Total Sales KPI</Name>
      <Description>Monitors health of average total sales</Description>
      <AssociatedMeasureGroupID>Tbl Fact</AssociatedMeasureGroupID>
      <Value>[Measures].[Avg Total Sales]</Value>
      <Goal>1500</Goal>
      <Status>CASE
    WHEN KPIVALUE("Average Total Sales KPI") / KPIGOAL("Average Total Sales KPI") &gt;= .95 THEN
        1
    WHEN KPIVALUE("Average Total Sales KPI") / KPIGOAL("Average Total Sales KPI") &lt;  .95
    AND
    KPIVALUE("Average Total Sales KPI") / KPIGOAL("Average Total Sales KPI") &gt;= .85 THEN
        0
    ELSE
        -1
END</Status>
      <Trend>CASE
    WHEN ISEMPTY(( [Measures].[Avg Total Sales], 
    [Order Date].[Year -  Quarter -  Month -  Date].PREVMEMBER)) THEN
        NULL
    WHEN [Measures].[Avg Total Sales] &lt; ([Measures].[Avg Total Sales], 
    [Order Date].[Year -  Quarter -  Month -  Date].PREVMEMBER) THEN 
        -1
    WHEN [Measures].[Avg Total Sales] = ([Measures].[Avg Total Sales], 
    [Order Date].[Year -  Quarter -  Month -  Date].PREVMEMBER) THEN 
        0
    ELSE
        1
END</Trend>
      <TrendGraphic>Standard Arrow</TrendGraphic>
      <StatusGraphic>Gauge - Ascending</StatusGraphic>
      <CurrentTimeMember></CurrentTimeMember>
    </Kpi>
  </Kpis>
  <Actions>
    <Action xsi:type="DrillThroughAction" dwd:design-time-name="72c56f74-6022-40e6-9ad4-2f1d160de131">
      <ID>Drillthrough Action</ID>
      <Name>Total Sales Drillthrough</Name>
      <TargetType>Cells</TargetType>
      <Target>MeasureGroupMeasures("Main")</Target>
      <Type>DrillThrough</Type>
      <Columns>
        <Column xsi:type="MeasureBinding" dwd:design-time-name="73048f79-d098-4a35-a1f0-0ef7dac98171">
          <MeasureID>Total Sales</MeasureID>
        </Column>
      </Columns>
    </Action>
    <Action xsi:type="StandardAction" dwd:design-time-name="74e0cd1f-94d4-4c6b-ad61-357b45daff81">
      <ID>Action</ID>
      <Name>MSN Search</Name>
      <TargetType>LevelMembers</TargetType>
      <Target>[Geography].[Country - State-Province - City - Postal Code].[City]</Target>
      <Type>Url</Type>
      <Expression>"http://search.msn.com/results.aspx?q=" + [Geography].[City].CurrentMember.Name</Expression>
    </Action>
  </Actions>
</Cube>
sales.cube - 源码说明

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

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