| 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 : /Program Files (x86)/Microsoft SQL Server/110/Tools/Templates/olap/1033/ |
Upload File : |
<?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>