Forum Discussion

pranav46's avatar
pranav46
Contributor II
2 days ago

Enter yearly rates through cubeview

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.

 

Planning
  • chul's avatar
    chul
    Contributor III
    16 hours ago

    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.