One of the perks that comes with choosing OneStream as a CPM platform is the growing number of free out-of-the-box solutions available for licensed customers within the OneStream MarketPlace. One of those solutions is People Planning.
People Planning allows you to plan for employee and contractor compensations, benefits, as well as travel and expenses. The solution gives you flexibility based on dashboards and SQL tables.
In this blog post, you’ll learn everything you need to know about People Planning with OneStream, including:
With this solution, you’re given better visibility into employee information with details on easy-to-read, flexible dashboards. The solution makes your employee data easier to manage with no need to update the cube with every new employee or metadata change. You get the ability to calculate additional employee or contractor information, including complex comp, benefit, or sales plans without costly downtime experienced with other products. People Planning is also tied to the expense budgeting solutions with drill-down capability from the appropriate ledger accounts.
The People Planning solution is designed with XF Relational Blending and operates under the assumption that People Planning is often planning for the unknown with many different managers and differing employee types. In other systems, all data must be fed into a cube and forces separate applications to contain outlines to represent unknown changes in their cube. This data simply does not belong in the cube. Relational Blending allows the data to live where it belongs with detailed transactional data that lives in relational tables.
This relational and cube data are still in a single application — delivering the best of both the worlds. Because the relational table lives together with the analytic model in this single application, you can always report and drill back to the details whenever you need to — giving you complete visibility into the details that make up the plan.
Additionally, all of your information is secure with controlled access through the record management dashboard to the People Planning Register. Source data is also restricted by the OneStream Data Connector.
When you’re designing your solution, you’ll need to look at individual employee detail information vs. application (GL data) level needs. You should ask yourself:
Next, you need to decide how details are collected. You have two options
You also need to consider your performance by looking at how many employees and how many different types of employees will be contained within the system.
With People Planning, workflow will drive your process. You’ll have a Central Workflow Profile and an Individual Workflow Profiles. Both of these include a workspace channel to access the People Register and an import channel to load data from the People Planning tables into the OneStream XF Cube. The difference is the Central Workflow Profile includes a Central Load Connector, while the Individual Workflow Profiles include a Transfer IN Connector and Transfer OUT Connector.
It’s incredibly important that your employee data is secure, something that OneStream fully understands. People Planning can be secured by individual end user and individual base level Entity. If you require less security, you can set your People Planning solution to be accessible and manageable by every user.
If you’ve already implemented People Planning with OneStream, the following tips can help you further optimize this solution.
Tip 1: Overall design
From an overall design standpoint, you should begin with your end goal in mind, asking yourself “What GL Accounts with OneStream XF will be driven from People Planning?” You should create a matrix listing all of the People Planning Solution Accounts, identifying each account:
Tip 2: People Planning accounts needed
You need to consider what People Planning accounts will be needed to drive the OneStream XF app accounts. To do this, you should create a list of all the salary and benefit accounts within your OneStream XF application. Create your list with the following information:
Tip 3: How transfer employees are handled in the system
Your Plan Data for transfer employees is visible via the Import process by the “receiving” entity during the load process from your People Planning solution to your OneStream XF Cube. The associated employee record is held at the transferring entity and never moved or visible to the “receiving” entity. To modify the data associated with that record, a new instance with the same Employee ID can be created with the “receiving” entity’s register — this is similar to the inherent process within the transferring entity’s register. The Employee ID associated with incoming data for the ‘Transfer In (PLP_PeoplePlanningData_EntityTIN)’ Import channels can be found by drilling back to the source data and viewing the Register detail provided.
Tip 4: Updates & migrations
Fortunately, no additional work is required with full migration of OneStream XF Applications. Application extracts include People Planning dashboards; however, this does not include SQL tables, and initial setup steps are required.
Your People Planning Dashboard File (TableSetup_PLPS.txt) will require an update that drives the table creation process and solution setup. This update does not contain Customer specific configuration, but it can be modified to recreate your Solution configuration through:
– Terry Ledet
Terry Ledet is a seasoned financial systems professional, at US-Analytics, with expertise in developing complex financial reporting, accounting, and planning applications. With 18+ years of experience in project and resource management, Terry possesses the ability to identify and translate a client’s needs into an actionable technical solution.