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 Ac...
Forum Discussion
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?
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?
