Recent Discussions
Split hierarchy into 2 dimensions to ensure retroactivity
Hi everyone, We are currently developing a planning solution in OneStream for a client who has requested that the Cost Center dimension (and its related nodes) be updateable every year, while still maintaining full retroactivity when users need to view reports for prior years. We have considered two possible approaches: OPTION 1 Each year, load a new Cost Center hierarchy associated only with that specific year. When users want to analyze historical data, they simply select the hierarchy corresponding to the year they are reviewing. The main drawback of this approach is that, over time, multiple versions of the Cost Center hierarchy will accumulate, which could potentially impact maintainability or performance in the long term. OPTION 2 Separate Cost Centers and their nodes into two distinct dimensions. Introduce a technical member in the Account dimension and use a data entry form (maintained annually) where users enter a value of “1” at the intersection of each Cost Center and its corresponding Node. Source data is initially loaded only at the Cost Center level (using a dummy member for the Node dimension). At the end of each cycle, a Business Rule is executed to populate the Node dimension based on this mapping. This approach avoids unnecessary data duplication, but it introduces additional process complexity and reliance on manual maintenance. Does anyone have experience with similar requirements, alternative approaches or feedbacks on this topic? Thank you in advance!
Format - Header Text alignment
Hello, I would like to align vertically and horizontally the text on my column header (in Cube Views and Reports). It seems there is no option to do that in the format parameters (only in Excel). I have tried to use an inline Formula, at least for the Report format, but it is not working. I keep having errors messages. Do you know a solution to get a more consistent presentation ? Thank you in advance, MorganeExecuteCustomCalculateBusinessRule in parallel
Hi all, so I'm running a Finance Business Rule through BRApi's ExecuteCustomCalculateBusinessRule method, passing a POV through its nameValuePairs parameter. Since I need to run it from a WorkSpace for a bunch of different DataUnitPK, I'd like to run them in parallel. Unfortunately it doesn't work. It seems to me that: The first launch runs with a POV passed in parameters (let's call it POV-A) The second launch sets its own POV (let's call it POV-B) if the first launch is still running - and that's natural for parallel execution - every reference to api object seems broken, since it refers now to POV-B Does someone was able to parallelize the above mentioned method ? Thanks in advance for Your help Regards FabioG
Export Invalid intersections including validation messages
Hi, I'm aware that from the Validate workflow step, the full list of invalid intersections can be exported as in the picture below (right click > Export): The Validation messages are not included in the export. Is there a way to export the full list of validation messages together with the invalid intersections? Thank youPlanning: 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.Automated User Provisioning: Best approach to sync Users & Security Groups?
Hi everyone, We need to automate user creation and security group assignments in OneStream using data from an external Identity system. I have two main questions: Is it feasible to fully automate this without manual intervention? What is the best way to implement it simply (avoiding heavy middleware)? We are considering two solutions: Just-in-Time (JIT) via OIS, and SCIM. Does anyone know how we can set these up? What is the recommended "standard" approach for this? Thanks for your help! Madiha
Check details for disk space
Hi guys! I would like to know if there is a way to get a more detailed view of what is consuming disk space for each application within my environment. I understand that the System Diagnostics dashboard provides a report indicating how much space is allocated and how much is being used per application; however, I would like to know if there is a way to obtain a more detailed breakdown per application. Thanks!
