QPR Knowledge Base

Working with Period Levels

Hide Navigation Pane

Working with Period Levels

Previous topic Next topic No expanding text in this topic  

Working with Period Levels

Previous topic Next topic JavaScript is required for expanding text Mail us feedback on this topic!  

Comments (...)

You can add, delete and modify period levels in the Periods Window.



Adding a New Period Level

To add a new period level:


1.In the Periods window, click the Add Level... button. The Add Period Level dialog opens.




2.Type a name for the period level into the Name field.
3.Select the period type in the Period Type section.
4.Select when the values for upper level periods are gathered in the Periodic Accumulation section.
5.Optionally, select the Lock periods automatically check box to enable automatic period locking, and define a value in the days after period ends field.
6.Click OK. The new period level is added into the list in the Periods window.


Period Type Options

You can choose the period type to be any of the seven predefined lengths, or you can use the Custom Level or Milestones option.


The Custom Level allows you to define the start and the end date completely freely. However, you cannot use the Period Wizard with custom levels. Note also, that in order for Periodic Accumulation to work, the custom period level must be placed to the correct position in the hierarchy. For example, a custom period level consisting of dates from January 1st to July 31st of a given year should go between the 'Year' and 'Half year' period levels.


If the period level type is Milestones, Periodic Accumulation and Automatic Period Locking have no effect on it and Period Wizard cannot be used with it. Any number of periods can be added to the period level. Periods added to the Milestones period level have no dates associated with them; they only have a name. Values entered for periods on a Milestones period level are associated only with the corresponding period. If a formula on on a Milestones period level measure refers to a measure on a non-Milestones period level or vice versa, the value is considered to be null. In addition, Milestones period measures cannot be mixed with non-Milestones period measures on on the same chart (i.e. benchmarking between the measures cannot be done). If a measure uses a Milestones period level, all layout items that show the measure's value use the same Milestones period level.


Periodic Accumulation Options

The Periodic Accumulation options define when values are collected for the upper level periods (for example when weekly periods send their values to monthly periods). You can choose to accumulate periods by the first day of the period, middle of the period, or by the last day of the period. For example, if you have a level with the Week period type and "First day of the period" accumulation settings, and the month changes on Thursday, the values for that week will end up to the month period in which the week started. On the other hand, if the period level would have had the "Last day of the period" accumulation settings, the week period's value would have ended up to the new month period.


Automatic Period Locking

When Automatic Period Locking is enabled, periods of the corresponding period level will be locked after the amount of days defined in the days after period ends field has passed after the end of the period. The value can be positive or negative. Automatic Period Locking is available only for users with at least model administrator rights.



Editing Period Levels

To edit a period level:


1.In the Periods window, select the period level you want to rename.
2.Click the Edit button. The Edit Period Level window opens..




3.Modify the settings you want to change, for example type a new name in the Name field.
4.Click OK. The new settings will take effect immediately.



Deleting a Period Level

To delete a period level:


1.In the Periods window, select the period level you want to delete.
2.Click the Delete button or press the Delete key and a confirmation dialog appears. To confirm the deletion, click the Yes button and the period level will be deleted from the list.

Warning: Deleting a period level also deletes all periods that belong to that level.



Arranging and Copying Period Levels

You can arrange the order of the period level by moving period levels up and down in the list using the Up and Down buttons.


You can also copy period levels by selecting the desired period level and clicking the Copy button.





See Also


Period Wizard



Comments (...)