The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
planning
96 TopicsAllocations Management Solution Feedback
Hi everyone, We're looking into the Allocations Management solution in OneStream for SG&A allocations and wanted to see if anyone is currently using it. If so, we'd love to hear about your experience. How has it worked for your allocation processes? Has implementation and maintenance been manageable? Are there any limitations, challenges, or lessons learned that you'd be willing to share? Thanks in advance!24Views0likes0CommentsWrite Data to Dynamic Dimensions
I've been going through some training material on DCS for a use case that requires frequent changes in a dimension (UD3 - SKU). Because of this, I'm considering dynamic dimensions where the SKU can be written and generated via code. Unfortunately, I haven't found anything that supports writing data from a cube view. I've only found material that says the "Dynamic Cube" needs to have the share and edit feature turned on. Question - Is it even possible to create a cube, use a dynamic dimension as one of its dimensions, write allocation calcs to allocate data to SKU level and be able to modify that data using cube views? If not, what is the best way to handle this use case without having to create another non-dynamic SKU dimension.Solved187Views1like4CommentsIssue in adding data to LIM WF model
In LIM WF model, I have created register with only 7 fields, Start Date, End Date, Entity, Employee id, Position id, FTE and Base Salary. Created two accounts FTE and Base Salary to copy data to people cube. Now when I am trying to add row, it is not adding any data in but its not showing in register. If i check database table I can see data. Earlier I have uninstalled LIM and WF multiple times to check if the issue gets resolved but still in same place. Any help will be good.30Views0likes0CommentsReorder Register Columns in LIM
Is there an ability to organize a default order for the columns in LIM? I understand the user can customize the order, but we'd like to determine a starting order. Register Definition doesn't give the traditional arrows available to reorder.Solved211Views1like3CommentsCalculate HC in LIM for Mid-Month Start
Is there an ability to calculate HC expenses that account for when in the month an employee starts and prorate accordingly? As an example, if the employee starts on the 15th then their monthly salary would be Salary / 12 * (15/30). The syntax available in the blocks don't clearly identify if this can be done.Solved246Views0likes5CommentsSame Scenario Across Two Cubes vs Separate Scenarios — Pros & Cons?
Hello everyone, I’m looking for feedback on the pros and cons of using a single Actual scenario across two cubes (e.g., Consolidation and FP&A) versus defining separate scenarios for each cube. For example: Option 1 (shared): Consolidation Cube : Actual (Scenario Type = Actual) FP&A Cube : Actual (Scenario Type = Actual) Option 2 (separate): Consolidation Cube : Actual (Scenario Type = Actual) FP&A Cube : Monthly (Scenario Type = Control) From your experience, how do these approaches compare in terms of data governance, maintenance, performance, flexibility for planning/reporting, and potential risks (e.g., unintended impacts between cubes)? Any best practices or lessons learned would be greatly appreciated. Thanks in advance!37Views0likes0CommentsUpgrade from 9.1 to 9.2
Hi, I would like to know if any major changes need to be carried over from 9.1 to 9.2 version upgrade. As we had some changes performed when we moved from 8.5.1 version to 9.1.0: Winscp to SSH.net Marketplace solutions to be upgraded to latest versions also Navigation center replaced applications reports, security audit reports. so, we had to remove the existing AR, SAR solutions. We had .vb in the extension wherever the xfbr has been referenced that extensions were no longer supported in 9 version. Thanks in Advance!247Views0likes1CommentTech Talks After Hours: CPMx IFRS
Join Aymar Doat and Tom Linton as they explore CPM Express IFRS; a productized implementation accelerator that delivers a pre‑configured, unified financial consolidation and planning foundation with an IFRS emphasis requiring minimal configuration to rapidly improve time‑to‑value. To receive OnePoints for watching this Tech Talk video, please visit the link below: Tech Talks After Hours: CPMx IFRS94Views0likes0CommentsPlanning: Daily Data to Daily Import to a Monthly App
Have you seen a KB / post that met the requirements for daily data? Please share your experience / practical advice to help us meet daily data requirements. - for Planning - flat files: Daily Data per Month - flat files: Daily Import - Reporting by Day by Month Thank you folks for sharing your expertise.Solved80Views0likes1Comment