Time Profile: Time dimension at week level vs at month level with weeks in UD
Hi All, I am designing a new app with huge data set at detailed level and need time at weeks level. I would like to know if going by custom profile with time dimension at weeks level would be more efficient or having time dimension at month level and using WEEKS in User defined dimension would be better in the performance. It would be great if you can share some pros and cons for both the approaches and which one would be optimistic. Thanks in advance.
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.
