Database Reference
In-Depth Information
Date].[Hierarchy].CurrentMember
)
);
End Scope;
A similar logic is used for the other calculations defined by the Time Intelligence wiz-
ard.
Note
A drawback of the Time Intelligence wizard is that you need to define all meas-
ures that you want to perform the calculation on in the
scope
statement. An al-
ternative to the Time Intelligence wizard has been described by Tyler Chessman
in an article in
SQL Magazine
at
http://sqlmag.com/sql-server-analysis-services/
Now that the calculations have been defined, they can be used in the reports. To use
them, create a PivotTable in Excel using the following steps:
1. Create a new Excel workbook containing a PivotTable with a connection to
the cube.
2. Drag
Order Date.Hiearchy
to the
Filters
area.
3. Drop
Sales Amount
and
Sales Amount - Fact Reseller Sales
in the
Values
box.
4. Drop
Product Hierarchy
in the
Rows
area.
5. Drag
Hierarchy Order Date Calculations
and drop it on the columns. Your
PivotTable field list should look like the following:
Search WWH ::
Custom Search