Map the time dimensions in the external data source to those used in Performance Scorecard.
To map time-related dimensions:
From Time Dimension Count, select a value as follows:
Select 1 to hide the Year Dimension and Select Year Dimension elements. This option is set as the default.
Select 2 to show the Year Dimension and Period Dimension elements.
From the Period Dimension List, set the period dimension label to the selected dimension.
Under Start Date, click the calendar button
, and then select the Start Date that maps to the first member in the time and year member. Tip:
To reverse the order of dimensional members mapped to dates, select In Reverse Order.
Under Period Generation, click Select and choose the member from the dimension to represent the generation or depth of the dimension to use in Performance Scorecard.
For example, if you select “January,” the monthly generation is used. If you select “week 1,” the weekly generation is used.From Period Generation Significance, select the required frequency for the time dimension generation, such as Day, Week, Month (default) or Quarter. These attributes provide date values for each row. If these attributes are changed, Performance Scorecard regenerates this table with default values.
Review the dates for the pairs of time members. These members are taken automatically from the Essbase database, showing the generation level that you selected. Click the Calendar button to select a different date for individual members. To remove one or more members from the generated database, click Delete