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/
optimizing-time-based-calculations-ssas .
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