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?New balance sheet accounts do not feed through all months i.e. derived data is not working. Why ?
Hi, I have created some new balance sheet accounts relating to Right Of Use Assets, I have copied the structural dimensions from my existing fixed assets, so that every member property field matches. I use a generic cubeview for recording opening balance adjustments, when I key into all my other balance sheet accounts, then the derived value flows through the remainder of the year. This happens regardless of which is the first month I key into. However, for my new ROU accounts, it does not do it. The values just show as 0 and I have to key in the actual value manually each month thereafter. Here is some sample data to show what is/is not happening. Also, it does not matter which month is the first month. So what have I missed in creating these ROU account codes in the member properties ? They use the same flow constraint as my other fixed assets, so it's not that. Where else do I need to look ? Cheers Mark
Question: Can you add a new member to dimension through dashboard?
Hi there, I'm testing out the capabilities of OneStream for a PoC. Is there any way for a front-end user to add new members to, e.g., an account dimension through a component of a dashboard? Ideally using a variable specified within the dashboard. In the example screenshot, I want to enter a name in the text box, press the green button, and have the specified name added to the dimension of the cube view below. Thanks!! 🙂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.
