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