Forum Discussion

Brooks's avatar
Brooks
New Contributor III
5 days ago

Populating Future period in a Cube View

Hello,

I'm trying to create a cube view that grabs actuals from People Planning and populates the future periods with the latest month of actuals. e.g. in M3, M1=M1 Actuals, M2=M2 Actuals, M3=M3 Actuals, M4-12=M3 Actuals.  I need this in a cube view because we need to be able to show the data in both local currency and USD.  People Planning is currency agnostic.  I tried this directly querying XFW_PLP_Plan with SQL and a biViewer, but ran into the problem of not being able to bring in FX rates.  I can only show local currency.

Has anybody done this or have any ideas?  Perhaps something with UD8?  Perhaps there is something simpler I'm overlooking?  There is SO much to learn with OneStream and I know I'm only scratching the surface.

BI Viewer
Cube View
Reports
  • T_Kress's avatar
    T_Kress
    Valued Contributor
    5 days ago

    Not entirely following but are you not ultimately pushing your people planning data (that sits in XFW_PLP_Plan table) into the cube?  Traditionally, you use a connector BR to pull the data out of the register tables and push in to the cube, albeit at a more summary level.  And in the cube you have forecast scenarios that combine Act+Fcst, no?

    • Brooks's avatar
      Brooks
      New Contributor III
      5 days ago

      Yes, we push the People Planning data into the cube.  We do not have a forecast scenario that we use for People Planning.  We just have actual.  Our finance users want to see the Actuals "extended" to the future periods for comparison to the budget.  Sort of a poor man's forecast, if you will.  Extending them directly from XFW_PLP_Plan is doable, but that does not allow for matching different entities up with the appropriate FX rates for each period.  A cube view would allow this using already built in functionality.  Can it be done?