Skip to main content
A
anonymous1
Newcomer
April 17, 2023

Help with Data Buffers

  • April 17, 2023
  • 2 replies
  • 0 views

Hi everyone. I am looking for some assistance with using data buffers for a revenue planning form.

Essentially, budgeted revenue growth percentages will be input individually for each brand by month. The total PY Actual revenue for each brand by month will be loaded into OneStream.

The formula to forecast budget is:
CY Budget = PYAct * (1 + Growth % / 100)

While I can calculate each CY Budget cell individually for each brand by month, this would be a tedious and very long process since there are 26 brands and 12 months, which would require 312 individual calculations.

I would like to use a data buffer instead to calculate CY Budget by looping through each brand (and across all months from Jan 2022 to Dec 2022). However, I am unsure of how to do this and would appreciate guidance.

For ease of reference, I have also attached a screenshot of my cube view.

anonymous1_0-1681768869700.png

2 replies

S
OneStream Employee
SergeyOneStream Employee
OneStream Employee
April 18, 2023

Hello,

 

More than a data buffer, you will need a multiplyunbalanced formula. This post from Cameron is covering it : https://blackdiamondadvisory.com/2022/03/15/keeping-your-balance-with-unbalanced-math/

 

Regards,

    H
    OneStream Employee
    HenningOneStream Employee
    OneStream Employee
    April 18, 2023

    Hi, just in case the brands and "AMZN" displayed in your screenshot are not just a random example, you may want to blur out those parts depending on your employer's / customer's stance on how open they are with regards to sharing (small) parts of their application.

    Terms & ConditionsAccessibility statement