Using the Amount–Unit–Rate Template in a Business Rule (Planning and Essbase Block Storage Users Only)

You use the Amount–Unit–Rate template to calculate one of the three variables after you supply two of them.

For example, you may want to use the Amount–Unit–Rate template when you plan for product revenue. For some products, you know what revenue you want to have and what quantity you can have, so you use those two variables to determine the price.

  To use the Amount–Unit–Rate template in a business rule:

  1. Complete step 1 through step 4.

  2. In the Amount–Unit–Rate Template Wizard, on Enter Variables, use the Actions icon to select a values for two of the three variables:

    • Enter or select a member, variable, or function as the Amount value.

    • Enter or select a member, variable, or function as the Rate value.

    • Enter a member, variable, or function as the Unit value.

      See Working with Members, Working with Variables, and Working with Functions.

      In the database, the member that shows #missing is calculated based on the other two members' values. 

      For Amount member input = Product Revenue 
For Units member input = Quantity 
For Rates member input = Price.
In the database, for Jan
Product Revenue = 500, Quantity = 10 and Price = # missing
This template calculates the Price based on Product Revenue / Quantity

    Note:

    This template does not work unless the value of the member is #missing.

  3. Click Finish.