How to get two decimal places in Member formula
Hi Everyone, I'm trying to write member formula (not dynamic calc), below is the syntax Dim Var1 as Decimal = Math.Round(api.Data.GetDataCell("A#630000").CellAmount, 2) api.Data.Calculate("A#520000 = A#430000 "*" & Var1 & "). after that getting error "Double is not valid, input string was incorrect format".56Views0likes7CommentsOrg-by-period
Hi all, Within our application, we have a requirement to be able to do restructurings. This means, on date A, a legal entity is owned by holding A, but on date B, it moves to a different holding company and is then consolidated under that holding company. Has anyone got this working, and if yes, could you share how? What I am running into right now: We can leverage org-by-period settings, but in that case for example opening balances become 0. Plus there is the complexity that you have to set the scenario consolidation view to Periodic, which brings challenges in rolling forward balances where there are no movements. This also means we cannot keep the consolidation setting to standard which means the performance is degrading significantly. So the question is, did anyone get this scenario workign, and can you share how? This would be grately appreciated! With kind regards, Tim Vierhout28Views0likes0CommentsLock Out Sold Entities, Keep Their Impact!
Managing Sold Entities Without Losing Consolidation Results. Hi Community, We’re looking to hear how others handle this in OneStream: When an entity is sold in a specific period (e.g., 2025M5), the requirement is to: ✅ Retain its posted journal values in group consolidation ❌ Prevent any further use of the entity (journals, data loads, forms) The challenge we've encountered is that setting In Use = False — even after journals are posted and consolidation has been run — can cause OneStream to drop that entity’s data from the group during future reconsolidation. This results in the loss of valid P&L impact from the sold entity. Our workaround: Keep In Use = True for the sold period Use workflow locks and security restrictions to block future changes Only set In Use = False once everything is finalized and locked 💡 Feature Suggestion: It would be incredibly useful to have a system property or override flag that allows us to: Set In Use = False to fully disable the entity in the workflow Still retains its consolidated values during reconsolidation How are you managing this today? Your thoughts! Thanks,25Views0likes0CommentsConsolidation in a Dynamic Cube
Hi Experts, I have a dynamic read only cube, source of this cube is a relational table having details like salary band, department, position, benefits %, tax %, etc. I am simulating some calculations in workspace assembly and setting records in the dynamic read only cube. I see expected data at base entity levels. How can I see correct data at the top entity level? Entity structure: I see same data at multiple levels. Asia and AllRegions data should not be same. Also drill down results are same at multiple levels which is weird. So if we are setting data at base entities in a dynamic cube, how does consolidation work here? JackLacava , would you please clarify this?42Views0likes1CommentDisable eliminations and Develop Custom elim
Is there anyway we can develop a custom elimination process in the OS and attached with the cube. I see there is a "Custom" option in the cube properties but dont know what this function will do. FinanceFunctionType.ConsolidateElimination. I developed a custom rules which eliminate at first common parent dummy base member and it all ties when I sum but i wanted to get it roll up to Total Entity in USD.41Views0likes3CommentsCopy Prior Year Retained Earnings
Anyone willing to share the process by which you copy prior year accumulated retained earnings to the current year? Is this just handled via data management steps, or do you need a business rule? It does not seem that our implementation partner set this up for us... therefore this account currently is just being imported from our ERPs at the start of the year. This is an issue for our few entities with foreign currency, as the balance continues to translate at the current month closing rate, which we do not want. Appreciate any insight! :-)Solved138Views0likes10CommentsCube | Data Access | Data Cell Access Security/Slice Security by U1#Geography
Data Management Access Security Please share your expertise to set up a Cube's Data Cell Access Security / Slice Security to limit data read access as outlined below: Dimension: U1# - Geography Total_Geography = Child 1 + Child 2 = Total / Top North_America = Child 1 / NA International = Child 2 / Int'l Slice Security: Access Level - Read Data by Geography - in a CV and a QV Total_Geo_Data = Read Total data | Read NA data and Read Intl data NA_Data = Read NA data | no data access = International and Total Intl_Data = Read Int'l data | no data access = North America and Total TY for your practical advice - SMEs.Solved193Views0likes2Comments