Categories Notes

· Describe how to define a simple rollover to move current data to a prior category (same frequencies, manual rollovers).

To create a Rollover Set:

1. From the Categories window menubar select Navigate > Rollover.
2. Select an existing Rollover Set or create a new one.
3. Select Source and Destination categories and save the set.

To run a Rollover Set:

1. From the Application window menubar select Task > Run Rollovers.
2. Select a Rollover Set and press OK.

· Describe how rollovers work when the source and destination data categories have different frequencies.

The frequency attribute of the source category must be the same or greater than the destination category frequency. For example, you can roll over data from a monthly category into a quarterly category. Hyperion Enterprise intelligently adds periods together when the source category has more periods than the destination period.

· Describe how rollovers work in an organization-by-period application where the entity exists in 1 category and not the other.

When organisation-by-period categories are rolled over the organisation is rolled with the data.

· Describe what will appear in different parts of the application when setting a particular frequency, start, and prior period.

Period frequency mainly affects the number of columns displayed. Period start mainly affects column headings. Prior period mainly affects formula which refer to prior periods.

· Describe how to set-up and maintain categories.

Categories are maintained in the Categories window.

· Describe the data view option for a category and how it affects how data will be displayed after it has been entered.

Normally periodic categories are used for budget data and to-date categories for actual data. The following table shows the same financial data is stored in both types of category.

· Describe the effect of the missing data as zero periodic or category-to-date option for non-journal entities.

The following tables shows the result when 1,000 is input into Q1 of two categories. The data view of both categories is to-date but missing data is different.

· Describe the effect of the missing data as zero periodic or category-to-date option for journal entities and how it is affected by the 'Affects Future Periods' setting in Journals.

Missing data as zero works the same for journal entities as for non journal entities. Changing the 'Affects Future Periods' setting lets you posts journals which affect future periods as well as the current period.