Page Comparison

Many Hyperion Financial Management and Hyperion Enterprise applications contain Actuals at various rates, typically Actual, Budget and sometimes even Last Year rate. The background is that for management reporting purposes some companies prefer to compare actuals to budget or actuals to last year excluding the effect of exchange rates.

In the CXO-Cockpit, we have the Rate [RAT] dimension, which is typically used for this purpose. In order to set it up in a user friendly way, you need to do something extra. By default, if you put the rate dimension in the CXO-Cockpit and switch to e.g. Actualrate, then not only the Actuals, but also the Budget will be show at Actual rate. Since you only want to apply this dimension to the Actuals category, we recommend the following actions:

1. Map your data to specific rates

For example, to ActualRate (description: Actual Rate) and DefaultRate (description: Budget Rate)

2. Create a custom member CXO_ActualRate for the [RAT] dimension

WHEN

[CAT].[CAT].CurrentMember.Name='Actual'