Ho to extract a hierarchy for any dimension in Level format in OneStream?
Originally posted by Vignesh Mohan Hi, How can we extract the hierarchy of any dimension in an excel in a Level based format starting from top most level to the bottom most level for every base member ? Basically I do not want a Parent-Child format extract. Please find the attachments for the sample screen shot.Has anyone ever extended on the scenario?
Originally posted by Andrea Tout 9/23/2019 Has anyone ever extended on the scenario? We have on division that has it's own cube, and they have a lot of versioning and no one wants to deal with it in the other cubes. Display security doesn't exist for the scenario dimension.
Create custom member filter - Tree
As we cannot filter the Tree member expansion, is it possible to create a custom Tree? If not as a custom expansion, perhaps a code that returns a tree i.e. XFTreeItem? Dimension: Account Parent1 + Member1 + Member2 +Member2.1 +Member2.1.1 +Member2.1.2 +Member2.2 +Member2.2.1 In the above account dimension, I dont want Member 2.2. I just want the ultimate Parent1, the next level (Member1, Member2), and all base members. The result would be something like: Parent1 + Member1 + Member2 +Member2.1.1 +Member2.1.2 +Member2.2.1 Thx
Cube View - Split Delimited Stored Item Text into Separate Columns
Hello - I have a cube view that currently has two columns. The first is just base members of an account hierarchy, and the second is a dynamic calc UD8 that retrieves the text 5 value for each account stored by scenario type. The UD8 is working and pulling the correct text 5 values, however some but not all of the stored item text is delimited by semicolons. How can I split this text by semicolon into separate columns in the cube view?
Allocations in OS
Source: OneStream Champions Hi all! Do any of you run allocations in OS? Would you be able to share how you accomplish this? Currently we manually reallocate data that comes into our income statement accounts under one UD2 to two UD2s based on the percentage split of units (which is a stat account in OS). This is loaded as a balanced journal entry every month but I’m wondering if there’s a more efficient, less manual way to accomplish it. I tried reviewing OS academy, the design doc and golfstream and can’t find a good example of an allocation being run. Would any of you have a suggestion? For a simple allocation like this, would you recommend a CV form to allocate or would the Allocation journal entry type work better? Or maybe it’s a formula on the UD2 member itself that triggers the allocation? I’ve also submitted a support ticket but was thinking that maybe some customer experience would be useful too.
