Donat Was Here

DonatShell
Server IP : 180.180.241.3 / Your IP : 216.73.216.252
Web Server : Microsoft-IIS/7.5
System : Windows NT NETWORK-NHRC 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586
User : IUSR ( 0)
PHP Version : 5.3.28
Disable Function : NONE
MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF
Directory : C:/Program Files (x86)/Microsoft SQL Server/110/Tools/Templates/olap/1033/
Upload File :
[ HOME SHELL ]
Current File : C:/Program Files (x86)/Microsoft SQL Server/110/Tools/Templates/olap/1033/TimeIntelligence.xml
<?xml version="1.0" encoding="utf-8"?>
<TimeIntelligence xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:space="preserve">
  <_locDefinition>
    <_locDefault _loc="locNone" />
    <_locTag _loc="locData">FormulaComment</_locTag>
    <_locTag _loc="locData">mdxMainTopComment</_locTag>
    <_locTag _loc="locData">mdxMainBottomComment</_locTag>
    <_locTag _loc="locData">Description</_locTag>
    <_locTag _loc="locData">ViewName</_locTag>
  </_locDefinition>
  <mdxCreateCalculatedMemberFormula>
Create Member 
  CurrentCube.[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»] 
  As "NA" ;
  </mdxCreateCalculatedMemberFormula>
  <mdxPhysicalMeasureListItem>       [Measures].[«MeasureName»]</mdxPhysicalMeasureListItem>
  <mdxCalculatedMeasureListItem>    [Measures].[«MeasureName»]</mdxCalculatedMeasureListItem>
  <mdxMeasureListItemSeparator>,
  </mdxMeasureListItemSeparator>
  <mdxPhysicalMeasureListLayout>
Scope(
       {
  «PhysicalMeasureList»
       }
) ;</mdxPhysicalMeasureListLayout>
  <mdxCalculatedMeasureListLayout>,
    {
  «CalculatedMeasureList»
    }
  </mdxCalculatedMeasureListLayout>
  <mdxSelectedCubeDimensionKeyAttributeMembers>,
	[«SelectedCubeDimension»].[«SelectedCubeDimensionKeyAttribute»].Members</mdxSelectedCubeDimensionKeyAttributeMembers>
  <mdxMeasuresFormula>
«MDXFormulaComment»«MDXFormula»
«MDXFormulaProperties»
  </mdxMeasuresFormula>
  <mdxMainTopComment>
  Begin Time Intelligence script for the [«SelectedCubeDimension»].[«SelectedHierarchyName»] hierarchy.
</mdxMainTopComment>
  <mdxMainBottomComment>
  End Time Intelligence script for the [«SelectedCubeDimension»].[«SelectedHierarchyName»] hierarchy.
</mdxMainBottomComment>
  <mdxLayout>
«mdxMainTopComment»
«MDXCreates»
«PhysicalMeasureListLayout»
«MDXFormulas»
End Scope ;
«mdxMainBottomComment»
  </mdxLayout>
  <TimeViews>
    <anyType xsi:type="TimeView">
      <ViewName>Year to Date</ViewName>
      <RequiredLevelGroups>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Years</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalYears</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingYears</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingYears</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Iso8601Years</anyType>
        </anyType>
      </RequiredLevelGroups>
      <FormulaComment>Year to Date</FormulaComment>
	  <Formula>
  (
    [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =

  Aggregate(
             { «DefaultMember» } 
             *
             PeriodsToDate(
                            [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«YearLevelUniqueName»],
                            [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
             )
  ) ;</Formula>
      <Description>Year to date enables you to see the data in an accumulated view from the first day of the year to the selected period.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Semester to Date</ViewName>
      <RequiredLevelGroups>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">HalfYears</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">HalfYearOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingHalfYears</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingHalfYearOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingHalfYears</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingHalfYearOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalHalfYears</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalHalfYearOfYear</anyType>
        </anyType>
      </RequiredLevelGroups>
      <FormulaComment>Semester to Date</FormulaComment>
      <Formula>  
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =

  Aggregate(
             { «DefaultMember» } 
             *
             PeriodsToDate(
                            [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«HalfYearLevelUniqueName»],
                            [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
             )
  ) ;</Formula>
     <Description>Semester to date enables you to see data in an accumulated view from the first day of the semester to the selected period.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Quarter to Date</ViewName>
      <RequiredLevelGroups>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Quarters</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">QuarterOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">QuarterOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalQuarters</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalQuarterOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalQuarterOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingQuarters</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingQuarterOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingQuarterOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingQuarters</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingQuarterOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingQuarterOfYear</anyType>
        </anyType>
      </RequiredLevelGroups>
      <FormulaComment>Quarter to Date</FormulaComment>
      <Formula>
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =

  Aggregate(
             { «DefaultMember» } 
             *
             PeriodsToDate(
                            [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«QuarterLevelUniqueName»],
                            [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
             )
  ) ;</Formula>
     <Description>Quarter to date enables you to see data in an accumulated view from the first day of the quarter to the selected period.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Trimester to Date</ViewName>
      <RequiredLevelGroups>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Trimesters</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">TrimesterOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalTrimesters</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalTrimesterOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingTrimesters</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingTrimesterOfYear</anyType>
        </anyType>
      </RequiredLevelGroups>
      <FormulaComment>Trimester to Date</FormulaComment>
      <Formula>
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =

  Aggregate(
             { «DefaultMember» } 
             *
             PeriodsToDate(
                            [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«TrimesterLevelUniqueName»],
                            [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
             )
  ) ;</Formula>
     <Description>Trimester to date enables you to see data in an accumulated view from the first day of the trimester to the selected period.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Month to Date</ViewName>
      <RequiredLevelGroups>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Months</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">MonthOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">MonthOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">MonthOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">MonthOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonths</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonthOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonthOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonthOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonthOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonths</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonthOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonthOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonthOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonthOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonths</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonthOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonthOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonthOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonthOfYear</anyType>
        </anyType>
      </RequiredLevelGroups>
      <FormulaComment>Month to Date</FormulaComment>
      <Formula>
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =

  Aggregate(
             { «DefaultMember» } 
             *
             PeriodsToDate(
                            [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«MonthLevelUniqueName»],
                            [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
             )
  ) ;</Formula>
     <Description>Month to date enables you to see data in an accumulated view from the first day of the month to the selected period.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Twelve Months to Date</ViewName>
		<RequiredLevelGroups>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">Months</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">MonthOfHalfYear</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">MonthOfQuarter</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">MonthOfTrimester</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">MonthOfYear</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">FiscalMonths</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">FiscalMonthOfHalfYear</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">FiscalMonthOfQuarter</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">FiscalMonthOfTrimester</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">FiscalMonthOfYear</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">ReportingMonths</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">ReportingMonthOfHalfYear</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">ReportingMonthOfQuarter</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">ReportingMonthOfTrimester</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">ReportingMonthOfYear</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">ManufacturingMonths</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">ManufacturingMonthOfHalfYear</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">ManufacturingMonthOfQuarter</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">ManufacturingMonthOfTrimester</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">ManufacturingMonthOfYear</anyType>
			</anyType>
		</RequiredLevelGroups>
		<FormulaComment>Twelve Months to Date</FormulaComment>
      <Formula>
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =
    
  Aggregate(
             { «DefaultMember» } 
             *
             {
               ParallelPeriod(
                               [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«MonthLevelUniqueName»],
                               11,
                               [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
               ) : [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
             }
  ) ;</Formula>
     <Description>Twelve months to date enables you to see data in an accumulated view from the same period in the previous year to the selected period.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Twelve Month Moving Average</ViewName>
		<RequiredLevelGroups>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">Months</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">MonthOfHalfYear</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">MonthOfQuarter</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">MonthOfTrimester</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">MonthOfYear</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">FiscalMonths</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">FiscalMonthOfHalfYear</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">FiscalMonthOfQuarter</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">FiscalMonthOfTrimester</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">FiscalMonthOfYear</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">ReportingMonths</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">ReportingMonthOfHalfYear</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">ReportingMonthOfQuarter</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">ReportingMonthOfTrimester</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">ReportingMonthOfYear</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">ManufacturingMonths</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">ManufacturingMonthOfHalfYear</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">ManufacturingMonthOfQuarter</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">ManufacturingMonthOfTrimester</anyType>
			</anyType>
			<anyType xsi:type="ArrayOfAnyType">
				<anyType xsi:type="xsd:string">ManufacturingMonthOfYear</anyType>
			</anyType>
		</RequiredLevelGroups>
		<FormulaComment>Twelve Month Moving Average</FormulaComment>
      <Formula>  
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =
    
  Avg(
       ParallelPeriod(
                       [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«MonthLevelUniqueName»],
                       11,
                       [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
       ) 
       : [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
       *
       «DefaultMember»
  ) ;</Formula>
     <Description>Twelve month moving average enables viewing a rolling average for the previous twelve months from the currently selected period.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Six Month Moving Average</ViewName>
      <RequiredLevelGroups>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Months</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">MonthOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">MonthOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">MonthOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">MonthOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonths</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonthOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonthOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonthOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonthOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonths</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonthOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonthOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonthOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonthOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonths</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonthOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonthOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonthOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonthOfYear</anyType>
        </anyType>
      </RequiredLevelGroups>
      <FormulaComment>Six Month Moving Average</FormulaComment>
      <Formula>  
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =
    
  Avg(
       ParallelPeriod(
                       [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«MonthLevelUniqueName»],
                       5,
                       [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
       ) 
       : [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
       *
       «DefaultMember»
  ) ;</Formula>   
     <Description>Six month moving average allows you to see the rolling average for the previous six months from the currently selected period.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Three Month Moving Average</ViewName>
      <RequiredLevelGroups>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Months</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">MonthOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">MonthOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">MonthOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">MonthOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonths</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonthOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonthOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonthOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonthOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonths</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonthOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonthOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonthOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonthOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonths</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonthOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonthOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonthOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonthOfYear</anyType>
        </anyType>
      </RequiredLevelGroups>
      <FormulaComment>Three Month Moving Average</FormulaComment>
      <Formula>  
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =
    
  Avg(
       ParallelPeriod(
                       [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«MonthLevelUniqueName»],
                       2,
                       [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
       ) 
       : [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
       *
       «DefaultMember»
  ) ;</Formula> 
     <Description>Three month moving average allows you to see the rolling average for the previous three months from the currently selected period.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Year Over Year Growth %</ViewName>
      <RequiredLevelGroups>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Years</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalYears</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingYears</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingYears</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Iso8601Years</anyType>
        </anyType>
      </RequiredLevelGroups>
      <FormulaComment>Year Over Year Growth %</FormulaComment>
      <Formula>  
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 1 ) : Null«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =      

  ( 
    ( 
      «DefaultMember», 
      [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
    ) 
    
    -
    
    ( 
      «DefaultMember»,
      ParallelPeriod(
                      [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«YearLevelUniqueName»],
                      1,
                      [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
      )
    )
  )
  
  /
  
  ( 
    «DefaultMember»,
    ParallelPeriod(
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«YearLevelUniqueName»],
                    1,
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
    )
  ) ;
  
  ( 
    [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 0 )«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) = Null ; 
  
  Format_String( 
                 ( 
				   [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
				   [«SelectedCubeDimension»].[«SelectedCubeDimensionKeyAttribute»].Members
				 )
  ) = "Percent" ;</Formula>
    <Description>Year over year growth % allows you to view the data for the current period as a percentage of the same period in the previous year.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Year Over Year Growth</ViewName>
      <RequiredLevelGroups>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Years</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalYears</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingYears</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingYears</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Iso8601Years</anyType>
        </anyType>
      </RequiredLevelGroups>
      <FormulaComment>Year Over Year Growth</FormulaComment>
      <Formula>  
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 1 ) : Null«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =      

  ( 
    «DefaultMember», 
    [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
  ) 
  
  -
  
  ( 
    «DefaultMember»,
    ParallelPeriod(
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«YearLevelUniqueName»],
                    1,
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
    )
  ) ;
  
  ( 
    [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 0 )«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) = Null ;</Formula>
    <Description>Year over year growth allows you to view the difference between the current period and the same period in the previous year.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Semester Over Semester Growth %</ViewName>
      <RequiredLevelGroups>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">HalfYears</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">HalfYearOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingHalfYears</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingHalfYearOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingHalfYears</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingHalfYearOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalHalfYears</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalHalfYearOfYear</anyType>
        </anyType>
      </RequiredLevelGroups>
      <FormulaComment>Semester Over Semester Growth %</FormulaComment>
      <Formula>  
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 1 ) : Null«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =      

  (
    ( 
      «DefaultMember», 
      [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
    ) 
    
    -
    
    ( 
      «DefaultMember»,
      ParallelPeriod(
                      [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«HalfYearLevelUniqueName»],
                      1,
                      [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
      )
    )
  )
  
  /
  
  ( 
    «DefaultMember»,
    ParallelPeriod(
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«HalfYearLevelUniqueName»],
                    1,
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
    )
  ) ;
  
  ( 
    [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 0 )«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) = Null ; 
  
  Format_String( 
                 ( 
				   [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
				   [«SelectedCubeDimension»].[«SelectedCubeDimensionKeyAttribute»].Members
				 )
  ) = "Percent" ;</Formula>
      <Description>Semester over semester growth allows you to view the data for the current period as a percentage of the same period in the previous semester.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Semester Over Semester Growth</ViewName>
      <RequiredLevelGroups>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">HalfYears</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">HalfYearOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingHalfYears</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingHalfYearOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingHalfYears</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingHalfYearOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalHalfYears</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalHalfYearOfYear</anyType>
        </anyType>
      </RequiredLevelGroups>
      <FormulaComment>Semester Over Semester Growth</FormulaComment>
      <Formula>  
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 1 ) : Null«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =      

  ( 
    «DefaultMember», 
    [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
  ) 
  
  -
  
  ( 
    «DefaultMember»,
    ParallelPeriod(
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«HalfYearLevelUniqueName»],
                    1,
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
    )
  ) ;
  
  ( 
    [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 0 )«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) = Null ;</Formula>
      <Description>Semester over semester growth allows you to view the difference between the data for the current period and the same period in the previous semester.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Trimester Over Trimester Growth %</ViewName>
      <RequiredLevelGroups>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Trimesters</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">TrimesterOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalTrimesters</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalTrimesterOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingTrimesters</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingTrimesterOfYear</anyType>
        </anyType>
      </RequiredLevelGroups>
      <FormulaComment>Trimester Over Trimester Growth %</FormulaComment>
      <Formula>  
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 1 ) : Null«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =      

  (
    ( 
      «DefaultMember»,
      [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
    ) 
    
    -
    
    ( 
      «DefaultMember»,
      ParallelPeriod(
                      [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«TrimesterLevelUniqueName»],
                      1,
                      [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
      )
    )
  )
  
  /
  
  ( 
    «DefaultMember»,
    ParallelPeriod(
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«TrimesterLevelUniqueName»],
                    1,
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
    )
  ) ;
  
  ( 
    [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 0 )«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) = Null ; 
  
  Format_String( 
                 ( 
				   [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
				   [«SelectedCubeDimension»].[«SelectedCubeDimensionKeyAttribute»].Members
				 )
  ) = "Percent" ;</Formula>
      <Description>Trimester over trimester growth % allows you to view the data for the current period as a percentage of the same period in the previous trimester.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Trimester Over Trimester Growth</ViewName>
      <RequiredLevelGroups>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Trimesters</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">TrimesterOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalTrimesters</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalTrimesterOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingTrimesters</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingTrimesterOfYear</anyType>
        </anyType>
      </RequiredLevelGroups>
      <FormulaComment>Trimester Over Trimester Growth</FormulaComment>
      <Formula>  
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 1 ) : Null«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =      

  ( 
    «DefaultMember», 
    [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
  ) 
  
  -
  
  ( 
    «DefaultMember»,
    ParallelPeriod(
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«TrimesterLevelUniqueName»],
                    1,
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
    )
  ) ;
  
  ( 
    [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 0 )«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) = Null ;</Formula>
      <Description>Trimester over trimester growth allows you to view the difference in the data for the current period and the same period in the previous trimester.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Quarter Over Quarter Growth %</ViewName>
      <RequiredLevelGroups>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Quarters</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">QuarterOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">QuarterOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalQuarters</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalQuarterOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalQuarterOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingQuarters</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingQuarterOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingQuarterOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingQuarters</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingQuarterOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingQuarterOfYear</anyType>
        </anyType>
      </RequiredLevelGroups>
      <FormulaComment>Quarter Over Quarter Growth %</FormulaComment>
      <Formula>  
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 1 ) : Null«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =      

  (
    ( 
      «DefaultMember», 
      [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
    ) 
    
    -
    
    ( 
      «DefaultMember»,
      ParallelPeriod(
                      [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«QuarterLevelUniqueName»],
                      1,
                      [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
      )
    )
  )
  
  /
  
  ( 
    «DefaultMember»,
    ParallelPeriod(
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«QuarterLevelUniqueName»],
                    1,
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
    )
  ) ;
  
  ( 
    [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 0 )«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) = Null ; 
  
  Format_String( 
                 ( 
				   [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
				   [«SelectedCubeDimension»].[«SelectedCubeDimensionKeyAttribute»].Members
				 )
  ) = "Percent" ;</Formula>
      <Description>Quarter over quarter growth % allows you to view the data for the current period as a percentage of the same period in the previous quarter.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Quarter Over Quarter Growth</ViewName>
      <RequiredLevelGroups>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Quarters</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">QuarterOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">QuarterOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalQuarters</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalQuarterOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalQuarterOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingQuarters</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingQuarterOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingQuarterOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingQuarters</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingQuarterOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingQuarterOfYear</anyType>
        </anyType>
      </RequiredLevelGroups>
      <FormulaComment>Quarter Over Quarter Growth</FormulaComment>
      <Formula>  
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 1 ) : Null«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =      

  ( 
    «DefaultMember», 
    [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
  ) 
  
  -
  
  ( 
    «DefaultMember»,
    ParallelPeriod(
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«QuarterLevelUniqueName»],
                    1,
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
    )
  ) ;
  
  ( 
    [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 0 )«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) = Null ;</Formula>
      <Description>Quarter over quarter growth allows you to view the difference in the data for the current period and the same period in the previous quarter.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Month Over Month Growth %</ViewName>
      <RequiredLevelGroups>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Months</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">MonthOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">MonthOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">MonthOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">MonthOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonths</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonthOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonthOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonthOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonthOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonths</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonthOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonthOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonthOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonthOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonths</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonthOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonthOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonthOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonthOfYear</anyType>
        </anyType>
      </RequiredLevelGroups>
      <FormulaComment>Month Over Month Growth %</FormulaComment>
      <Formula>  
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 1 ) : Null«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =      

  (
    ( 
      «DefaultMember», 
      [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
    ) 
    
    -
    
    ( 
      «DefaultMember»,
      ParallelPeriod(
                      [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«MonthLevelUniqueName»],
                      1,
                      [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
      )
    )
  )
  
  /
  
  ( 
    «DefaultMember»,
    ParallelPeriod(
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«MonthLevelUniqueName»],
                    1,
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
    )
  ) ;
  
  ( 
    [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 0 )«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) = Null ; 
  
  Format_String( 
                 ( 
				   [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
				   [«SelectedCubeDimension»].[«SelectedCubeDimensionKeyAttribute»].Members
				 )
  ) = "Percent" ;</Formula>
      <Description>Month over month growth % allows you to view the data for the current period as a percentage of the same period in the previous month.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Month Over Month Growth</ViewName>
      <RequiredLevelGroups>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Months</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">MonthOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">MonthOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">MonthOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">MonthOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonths</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonthOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonthOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonthOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalMonthOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonths</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonthOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonthOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonthOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingMonthOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonths</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonthOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonthOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonthOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingMonthOfYear</anyType>
        </anyType>
      </RequiredLevelGroups>
      <FormulaComment>Month Over Month Growth</FormulaComment>
      <Formula>  
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 1 ) : Null«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =      

  ( 
    «DefaultMember», 
    [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
  ) 
  
  -
  
  ( 
    «DefaultMember»,
    ParallelPeriod(
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«MonthLevelUniqueName»],
                    1,
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
    )
  ) ;
  
  ( 
    [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 0 )«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) = Null ;</Formula>
      <Description>Month over month growth allows you to view the difference in the data for the current period and the same period in the previous month.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Week Over Week Growth %</ViewName>
      <RequiredLevelGroups>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Weeks</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">WeekOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalWeeks</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalWeekOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalWeekOfMonth</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalWeekOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalWeekOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalWeekOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingWeeks</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingWeekOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingWeekOfMonth</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingWeekOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingWeekOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingWeekOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingWeeks</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingWeekOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingWeekOfMonth</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingWeekOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingWeekOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingWeekOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingWeeks</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Iso8601Weeks</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Iso8601WeekOfYear</anyType>
        </anyType>
      </RequiredLevelGroups>
      <FormulaComment>Week Over Week Growth %</FormulaComment>
      <Formula>  
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 1 ) : Null«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =      

  (
    ( 
      «DefaultMember», 
      [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
    ) 
    
    -
    
    ( 
      «DefaultMember»,
      ParallelPeriod(
                      [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«WeekLevelUniqueName»],
                      1,
                      [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
      )
    )
  )
  
  /
  
  ( 
    «DefaultMember»,
    ParallelPeriod(
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«WeekLevelUniqueName»],
                    1,
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
    )
  ) ;
  
  ( 
    [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 0 )«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) = Null ; 
  
  Format_String( 
                 ( 
				   [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
				   [«SelectedCubeDimension»].[«SelectedCubeDimensionKeyAttribute»].Members
				 )
  ) = "Percent" ;</Formula>
      <Description>Week over week growth % allows you to view the data for the current period as a percentage of the same period in the previous week.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Week Over Week Growth</ViewName>
      <RequiredLevelGroups>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Weeks</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">WeekOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalWeeks</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalWeekOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalWeekOfMonth</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalWeekOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalWeekOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalWeekOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingWeeks</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingWeekOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingWeekOfMonth</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingWeekOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingWeekOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingWeekOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingWeeks</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingWeekOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingWeekOfMonth</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingWeekOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingWeekOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingWeekOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingWeeks</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Iso8601Weeks</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Iso8601WeekOfYear</anyType>
        </anyType>
      </RequiredLevelGroups>
      <FormulaComment>Week Over Week Growth</FormulaComment>
      <Formula>  
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 1 ) : Null«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =      

  ( 
    «DefaultMember», 
    [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
  ) 
  
  -
  
  ( 
    «DefaultMember»,
    ParallelPeriod(
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«WeekLevelUniqueName»],
                    1,
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
    )
  ) ;
  
  ( 
    [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 0 )«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) = Null ;</Formula>
      <Description>Week over week growth allows you to view the difference in the data for the current period and the same period in the previous week.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Day Over Day Growth %</ViewName>
      <RequiredLevelGroups>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Date</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Days</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">DayOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">DayOfMonth</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">DayOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">DayOfTenDays</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">DayOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">DayOfWeek</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">DayofYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalDate</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalDayOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalDayOfMonth</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalDayOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalDayOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalDayOfWeek</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalDayOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingDate</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingDayOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingDayOfMonth</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingDayOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingDayOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingDayOfWeek</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingDayOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingDate</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingDayOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingDayOfMonth</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingDayOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingDayOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingDayOfWeek</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingDayOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ISO8601Date</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ISO8601DayOfWeek</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ISO8601DayOfYear</anyType>
        </anyType>
      </RequiredLevelGroups>
      <FormulaComment>Day Over Day Growth %</FormulaComment>
      <Formula>  
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 1 ) : Null«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout»
  ) 
  
  =      

  (
    ( 
      «DefaultMember»,
      [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
    ) 
    
    -
    
    ( 
      «DefaultMember»,
      ParallelPeriod(
                      [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«DayLevelUniqueName»],
                      1,
                      [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
      )
    )
  )
  
  /
  
  ( 
    «DefaultMember»,
    ParallelPeriod(
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«DayLevelUniqueName»],
                    1,
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
    )
  ) ;
  
  ( 
    [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 0 )«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) = Null ;
  
  Format_String( 
                 ( 
				   [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
				   [«SelectedCubeDimension»].[«SelectedCubeDimensionKeyAttribute»].Members
				 )
  ) = "Percent" ;</Formula>
      <Description>Day over day growth allows you to view the data for the current day as a percentage of the previous day.</Description>
    </anyType>
    <anyType xsi:type="TimeView">
      <ViewName>Day Over Day Growth</ViewName>
      <RequiredLevelGroups>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Date</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">Days</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">DayOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">DayOfMonth</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">DayOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">DayOfTenDays</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">DayOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">DayOfWeek</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">DayofYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalDate</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalDayOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalDayOfMonth</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalDayOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalDayOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalDayOfWeek</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">FiscalDayOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingDate</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingDayOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingDayOfMonth</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingDayOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingDayOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingDayOfWeek</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ReportingDayOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingDate</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingDayOfHalfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingDayOfMonth</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingDayOfQuarter</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingDayOfTrimester</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingDayOfWeek</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ManufacturingDayOfYear</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ISO8601Date</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ISO8601DayOfWeek</anyType>
        </anyType>
        <anyType xsi:type="ArrayOfAnyType">
          <anyType xsi:type="xsd:string">ISO8601DayOfYear</anyType>
        </anyType>
      </RequiredLevelGroups>
      <FormulaComment>Day Over Day Growth</FormulaComment>
      <Formula>  
  ( 
	[«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 1 ) : Null«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) 
  
  =      

  ( 
    «DefaultMember», 
    [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
  ) 
  
  -
  
  ( 
    «DefaultMember»,
    ParallelPeriod(
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].[«DayLevelUniqueName»],
                    1,
                    [«SelectedCubeDimension»].[«SelectedHierarchyName»].CurrentMember
    )
  ) ;
  
  ( 
    [«DestinationDimensionName»].[«NewAttributeName»].[«CalculatedMemberName»],
    [«SelectedCubeDimension»].[«SelectedHierarchySourceAttributeName»].[«SelectedHierarchySourceAttributeLevelName»].Members ( 0 )«SelectedCubeDimensionKeyAttributeMembers»«CalculatedMeasureListLayout» 
  ) = Null ;</Formula>
      <Description>Day over day growth allows you to view the difference in the data for the current day and the previous day.</Description>
    </anyType>
  </TimeViews>
</TimeIntelligence>
Anon7 - 2022
AnonSec Team