Recent Discussions
LIM (Workforce Planning) Register Definition
I'm working through a proof of concept for Workforce Planning, which is driving the addition of new Register Fields after the initial setup. I've added some new fields, but they do not display in the Register. Am I missing something simple or is this expected behavior? If it's expected behavior, then that would imply I need to do a complete rebuild (I know I can use import templates).
Use Claude to speed up OneStream development?
Hi All, Have anyone of you explored the use of AI tools like Claude to speed up OneStream build? If so, can you share the experience? In one of my recent project, I had to reverse engineer 100s of Business Rules for documentation purpose. By using CoPilot and Github, I was able to reverse engineer BRs in documentation format in few hours which would have been very painful otherwise and would have taken weeks to do so. Would love to hear how the ongoing excitement (or hype) around AI-led accelerated development can potentially help with OneStream build. Thanks.
Consolidate / Aggregate Averages
Good morning all, i've been asked to add some customer satisfaction values to our reports and its just a score out of 5, this works fine for base entities but I really need to parents to be an average of the base Entites that have a value. Is there a way t achieve this? appreciate your time. Tad
Row suppression not working with dynamic cube?
Hi folks, My suppression in my cubeview doesn't work. If I turn on any suppression (including 'invalid') the cubeview returns blank (no rows at all). It's a cube that's been loaded with dynamic data services and the data is showing as NotStored. I wonder if that could be the cause? Anyone else observe this or have any tricks? I've tried every combo of suppression option I can think of... I'm surprised it would return nothing even with only 'suppress invalid' checked..Issue Referencing Parent Entity in an Stored Account Member formula
Hi, We have a few accounts that contain stored formulas. These accounts contain formulas that reference another Account and Parent entity and it stores the result at a Base Entity. Below formula is for an account that has a formula pass 4. We are storing the result in "BaseEntity" and calculate Account1 by looking at OPEX at a Parent Entity. Obviously, since it is referencing a Parent Entity we have to run our consolidations twice in order to get the result. Is there a way to sum up the Base entities of Parent1 and reference that value in a formula or is there a way to run a consolidation within the formula for just that Parent Entity? In other CPM/EPM products I've worked with in the past you can right rules where you run an aggregation on the Entity and then run your calculation. In OneStream I cannot seem to find a way to do this. If api.Pov.Entity.Name = "BaseEntity" Then api.Data.ClearCalculatedData("A#Account1",True,False,False,True) api.Data.Calculate("A#Account1 = A#OPEX:E#Parent1:C#USD",True) End If Any help or assistance would be appreciated. Thanks John
possibility of UD1 parent-member consolidation by time
Dears, I need move one base member under another parent in UD1 dimensions, the problem is that member should be consolidated till specific time period and then should be consolidated under another parent. There is no option like "percent consolidation" with time frame on UD1 dimensions. Could anyone have any solution for described problem? Before: U1#A(parent) U1#A001(base) consolidated till proper month in 2026 U1#A002(base) After: U1#B(parent) U1#A001(base) consolidated after proper month in 2026 U1#B001(base)
