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.
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
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
How have we accomplished intercompany eliminations across cubes?
Originally posted by Christine Kennedy 5/7/2020 How have we accomplished intercompany eliminations across cubes? We have an existing customer that has Actuals come from two cubes (one for JDE data, one for SAP) and are struggling to get this set up.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.We have a client that had two cubes but they only want to load the GL data to stage once
Originally posted by Michael Malandra 6/8/2017 We have a client that had two cubes but they only want to load the GL data to stage once. The first cube would have workflows that Import data from the GL to stage. How would I build the workflow profile to validate stage data and load to the second cube?Guidance on data-transfers between cubes?
Originally posted by George Waddell 3/2/2020 Can someone give me some info...guidance on data-transfers between cubes? I started off extracting the data via DM from a Sales cube. I need to import that data over to a Finance cube...how do I import the Sales Cube data file (in file Share DM folder) into the Finance Cube? Then I noticed this DM Export Sequence..I've a question on Entity extensibility (I know that it is not possible)
Originally posted by Celvin Kattookaran 12/20/2019 In LRP cube Entity is at upper level. However, that is not true for all entities it is a ragged hierarchy. How do you handle this scenario. Create separate hierarchies for both cubes with a prefix? Now how about the data movement? DM job to pull parent data, again some entities are base at both cubes. Swap entity to a UD and extend it, now what is implication for this - client is not happy with changing entity Add a field which says which entities to extract How can i handle data entry for LRP at Houston and other base entities (some could be base in Finance cube and some are parents) and move Finance data from Finance to LRP.
