Journals OwnerPreAdj
I have captured journals at a base entity on C#OwnerPreAdj . When I process the cube, the values do not get consolidated. I have to run a Force Consolidate for the result to come through on reports. I have set my cube settings for Calculate OwnerPreAdj if No data to True. This is on Onestream Version 8.4.
block consolidations from a specific Cube View using technical parents
Dear all, Is there a way to block the consolidations if a technical parent is picked? There's a CubeView having the entity tree in rows and consolidation levels in columns. I'd like to only block all consolidations that have a technical parent (this would just polute the database). Is there a code example that could do this? Thank you for the help. Best regards, CarlosExtracting Journals in a loadable format?
Hi, We're on 7.4. Is there a way to extract a posted journal from one application so that I can easily load it to another application. This would be super useful for investigating issues. At present, we can easily find imported data files, and load these into our test app. But I can't see any way to extract journals in the same way. The only options seem to be extracting a .csv file, which has the information but is not formatted in a way that can be loaded again.Consolidation stopped working
The client's consolidation stopped working on their top member after a specific point of time. From their earliest data point through 2023M11, it works fine. From 2023M12 forward it will consolidate only up to the members directly below the top parent. Nothing else has changed, except the data source. This was working as of a couple of days ago and suddenly stopped. I can see it running calcs fine, but the numbers in regular accounts do not roll up. Any thoughts? I've checked all the properties I could think of and turned off all calculations, but nothing helps.
Org-by-period Consolidation | Eliminations
Good Day, In order to implement Org-by-period Consolidation, you need to set the Consolidation View to Periodic so that the correct Share for e.g. the income statement can be calculated for only the period for which an entity was consolidated to a parent. The guidance is clear that "When Consolidation View is set to Periodic and no data is loaded to the IC Accounts for a specific month, custom Elimination rules are required". I assume this is because of built in zero suppression settings on the Elimination data buffer. However, here is what is strange to me and I'm not sure if I'm missing something. When setting the Consolidation View to Periodic and note that No Data Zero View is set to YTD as data is loaded YTD, for any entity, there is a problem with eliminations as follows: When loading 100 000 in January, the full 100 000 is eliminated. If you load 100 000 again YTD in February, nothing gets eliminated. If you load e.g. 100 000.01 YTD in February, then the full amount gets eliminated again. So it seems that custom Elimination rules are not only required when no data is loaded to the IC Accounts, but also if the data loaded in the next month is the same as the prior month?
