Skip to main content
January 14, 2025

Enter yearly rates through cubeview

  • January 14, 2025
  • 2 replies
  • 0 views

I am trying to build a cubeview to enter yearly rates in cubeview for forecast scenario. Is there any way I can do that? Idea is to enter rates during budget and use to for all forecast months instead of loading by periods.

 

2 replies

January 14, 2025

You can set up your metadata to hold the rates (where a user can enter it), switch the Translation Algorithm Type on the cube(s) to Standard Using Business Rules for FX Rates and write a Finance rule to return the rate from the cube rather than from the FX rate table.

pranav46Author
January 21, 2025

Its not FX rates. Its allocation percentages.

January 23, 2025

Your rate account can be a balance recurring. User enters the rate in M1 and it will carry through all periods.