Database Reference
In-Depth Information
SELECT DateKey, FullDateAlternateKey,
CONVERT(varchar, FullDateAlternateKey,
101) AS DateName, DayNumberOfWeek,
EnglishDayNameOfWeek,
SpanishDayNameOfWeek,
FrenchDayNameOfWeek, DayNumberOfMonth,
DayNumberOfYear, WeekNumberOfYear,
EnglishMonthName, SpanishMonthName,
FrenchMonthName,
MonthNumberOfYear, CalendarQuarter, 'Q' +
CAST(CalendarQuarter AS varchar) + ' ' +
CAST(CalendarYear AS varchar) AS
FullCalendarQuarter,
CalendarYear,
CalendarSemester, FiscalQuarter,
FiscalYear, FiscalSemester, N'Current
Order Date' AS [Hierarchy Order Date
Calculations]
FROM DimDate
4. Click on the Hierarchy Order Date Calculations 1 calculation and click on
the Delete button to remove it from the definition.
5. Process the cube.
The second thing that the Time Intelligence wizard does is to add a couple of mem-
bers. The following script shows the Year to Date member:
Create Member
CurrentCube.[Order Date].[Hierarchy Order
Date Calculations].[Year to Date]
As "NA";
As you can see, the member is actually just containing the string NA . The third thing
that is done is to add the calculation that does all the work. The first part of the cal-
culation is a scope statement that defines that the calculation is affecting the Sales
Amount and the Sales Amount - Fact Reseller Sales measures.
Search WWH ::




Custom Search