Configure Analysis Services data source time settings by using Dashboard Designer
Published: May 15, 2010
When you want to use Time Intelligence in your PerformancePoint dashboards, make sure that you configure the appropriate data sources correctly to work with Time Intelligence. When you configure a data source to work with Time Intelligence, you specify the values that determine how time will be interpreted for each data source. Read this article to learn how to configure Microsoft SQL Server Analysis Services (SSAS) data sources to work with Time Intelligence.
Always have time dimensions start at the beginning of their respective year, even if that means having empty members for the first half of the year. For example, if the fiscal time dimension year starts on July 1, 2010, but only has data recorded for January 1, 2011, you still must start the fiscal time dimension on July 1, 2010, to ensure that Time Intelligence functions for the full initial fiscal year.
To set time properties in an Analysis Services data source
After creating an Analysis Services data connection, click the Time tab.
From the Time Dimension drop-down list, select the time dimension for all Time Intelligence formulas and functions, such as a fiscal time dimension or a traditional calendar time dimension.
From the Reference Member drop-down list, select the start of the time dimension’s year by clicking an instance of the year’s start date.
If your time dimension uses fiscal years that start on July 1, select an instance of July 1 in the member selector. Note that this could be titled as July 1 in the cube, or it might be represented as FY2010 H1 Q1 M1 D1, or perhaps some other format. If you are using a traditional calendar year time dimension, you would select an instance of January 1.
Select the hierarchy level. This is where you select the precise reference member. For example, indicate if the member represents a day, month, semester, and so on.
Under Reference Date, enter a calendar date that is equal to the period specified by the reference member. In this step, map the cube's time dimension to a traditional calendar.
In the Time Member Associations section, map your time dimension hierarchies (listed under the Member Level column) to defined Time Intelligence hierarchies (listed under the Time Aggregation column).
Click Save on the toolbar.