Write 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.29Views1like0CommentsCalculate 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.Solved138Views0likes2CommentsUpgrade 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!121Views0likes1CommentReorder 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.Solved115Views1like1CommentTech 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 IFRS73Views0likes0CommentsPlanning: 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.Solved62Views0likes1CommentHow to Add Adjustments with Add Back Category and Free-Form Add Back Name to Actuals in OneStream?
Hi Everyone, I’m working with Actuals data structured like the attached screenshot and want to add adjustments linked to this data. Key points: Adjustments must tie to Actuals by Company, Account, and Month Each adjustment includes: An Add Back Category An Add Back Name, which is free-form text and can vary monthly I want to maintain monthly detail and enable reporting and drill-down by both Add Back Category and Add Back Name My questions: What’s the best approach to model and load adjustments with both a Add Back Category and a free-form Add Back Name in OneStream? Should Add Back Name be a UD member with auto-create, a text attribute, or something else? How to avoid member explosion or reporting complexity given the free-form nature of Add Back Name? How can I ensure adjustments roll up correctly and maintain data integrity? Any recommendations for validation, governance, and reporting for this kind of adjustment detail? Thanks in advance for your insights!24Views0likes0CommentsSum PLP Register Column for all employees
In People Planning, is there a way to sum all the values in either the PLP register or calc plan for all employees to get a total to calculate an allocation. My client would like to allocate a Pension Pool by the Employee’s Wage / Total Employee Wages. I am trying to find a way to calculate the Total Wages for all Employees using Allocation Methods as they run by RegisterID/CalcPer. Any ideas.23Views0likes0Comments