Microsoft Office Tutorials and References
In Depth Information
Switch to the Time tab, where you can specify the cube’s primary time dimension.
(See Figure 6-31 .)
Figure 6-31. Selecting a time dimension
The Time Dimension drop-down menu will list all of the hierarchies available in the cube.
Select “Date.Date.Fiscal.” This is a fiscal calendar that begins on the first of July of each year.
Under Reference Member, select a member from the dimension that represents the first
day of the fiscal year, such as January 1, 2005.
For the Reference Date, enter the same date in your regional format. This allows
PerformancePoint to understand how years are structured in the date dimension.
■ Depending on when you downloaded the adventureWorks sample databases, the actual dates available in your
cube might be different from those shown. the sample database used here has data from fY 2006 to fY 2009.
Search JabSto ::