Application Build

Originally posted by Fredrik Erlandsson Hi all, Does anyone know how to easily overview changes in the EntityDim in terms of Percent Consolidation and Percent Owenership between periods and years? Can this be extracted or built in a cube view? For example if i would like to get a snapshot of one hiearchy in the EntityDim including percent ownership for period 2020M10? Thanks, Fredrik

Originally posted by Clarke Hair Looking to start using the View txt fields (Annotation, Assumptions…) and understand that there is no natural way to have that information aggregated/consolidated up. I am told that a BR is needed to do this. Just checking to see if this is correct and if anybody has had success in this getting it to work. Ideal use would be for our regional leaders to be able to see summary comments on specific line items that we report on.

Originally posted by Eric Osmanski 11/5/2019 Anyone got a new version of the auto add member extensibility rule?

Originally posted by Celvin Kattookaran12/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.

Originally posted by Andy Moore 5/31/2018 How can I call a Dashboard Extender function, from an extensibility rule ?

Originally posted by Felipe Alcorta Hello: We'd like to incorporate variance explanations into our cube views.  If the cube view shows one periodic comparison (e.g. Jun YTD CY vs June YTD PY), we have a corresponding dynamic calc that calculates the variance and we can use the (out of the box) variance explanation from the View dimension in order to have comment/explanation functionality. However, if we have multiple comparison period in the same column template/cube view, we are unable to.  If we take the same approach as one periodic comparison, the same comment would appear in both comparison columns since there's nothing to distinguish which periodic comparisons are being explained against.   We tried using a placeholder UD8 elements (no formulas) in addition to the variance explanation from View dimension but OneStream says it's an invalid cell.  Advice?

Originally posted by Rob Dessureault 5/10/2019 Need to report companies with different year-ends as well as a Standard Corporate year end report for consolidated results

Originally posted by Rich House What is this error? Transaction (Process ID 77) was deadlocked on lock

Originally posted by Matt Grundey 2/18/2019 Can I have 2 cubes in the same application but using different time dimensions

Originally posted by Paula Mihalko 2/20/2020 Building out a weekly application (they know data will need to be loaded weekly at some point in the future). From the ticket: are there any exceptions or background processes that would allow modification of the time dimension definition after the application creation? My only real concern is definition of 53 week years. For instance, if we define a 4-5-4 calendar with 53 week years in 2026 and 2033 and then we find out later than it should have been 2027 and 2034 with 53 weeks, would there be any way to change this once the application is created?

Originally posted by Pascal De Schryver 10-17-17 Why would you pick 4-4-5 over 5-4-4 or over 4-5-4?

Originally posted by Craig Masters 4/2/2020 Who changed the time profile settings?

Originally posted by Andrea Tout 3/26/2018 Has anyone ever built a weeks application? Is it possible to have one cube as a weeks cube and all the others as month cubes?

Originally posted by Andrea Tout 12/16/2019 Can you have a weekly app that has one cube that is 454 and one that is 445?

Originally posted by Tommaso Massai 3/29/2019 Is it be possible to name the Quarters and Half-Years using the year of the starting period instead of ending period.

Originally posted by Michael Gialanella 5/20/2019   Has anyone implemented a Long Range Plan - LRP scenario that spans multiple years and the Input Frequency varies by Year?  

Originally posted by Rob Dessureault 4/28/2020 Is there a way to use a Range for the Time year in a CV? Is there a dynamic way of doing this without having to hard code the year?

Originally posted by Mike McGinnis 1/31/2020 I have a customer. with a Vietnamese entity which normally loads data in their local VND currency but this month they can only provide the data in USD currency. So they are asking for a way to load USD to a VND entity one time only. Would they need to load the USD data into a separate USD entity and then roll that up to the VND entity?

Originally posted by Charlie Griffiths 6/27/2019 Does anybody know how I reference FX rates in a Dashboard XFBR String rule? I need to perform some FX conversions within a Reporting Compliance solution. Thanks.

Originally posted by Jon Golembiewski2/23/2019 In general, is it possible to import a file to a cube that is outside the cube set in the workflow? I am fairly certain it is not but maybe there is a configuration or workaround I'm not aware of. Let's say you have a Drivers cube and you want a user to load a file to that cube and then import a file or fill out a form in the Main Cube. Is the only way to have the user switch workflow profiles?

Originally posted by Eric Osmanski 3/12/2020 Anyone have any clever ideas on how to get certain UD members to not translate? I can only think of a custom translation rule which specifically excludes them and then runs the regular translation on all other members. Looking for different ideas.

Originally posted by Henning Windhagen3/5/2019 Moving an entity between cubes Hi, a partner has an entity structure with four sub-groups. Each of these sub-groups has a different cube (i.e. four cubes). Now, apparently, they need to move one entity from sub-group 1 (and cube 1), to sub-group 2 (i.e. cube 2). The cubes are set up to cater for extensibility in BUD and FC in later phases, i.e. nothing has been extended yet, so the dimensionality of cube 1 and cube 2 is the same, apart from the different entities. My approach would be, keep entity ABC in cube 1 and create a new entity called something like entity ABC-new in cube 2. However, the partner wants to move the entity ABC from cube 1 to cube 2 completely, which I do not think is feasible, because you would change the historical data of that entire sub-group 1 as well as 2. Now my question: Has anyone done that before? Is there another feasible way other than my approach? Even if we say we do not care about the historical data of

Originally posted by Eric Osmanski 1/29/2019 Anyone know why this is the case? All of the Entities in the below Tree are CLP Entities. Entity 585 has an auto-translation currency of USD. 5XX and 5ZX are set-up identically. Yet, ActivityCalc doesnt roll up to 5ZX, but it does to 5XX? Then FX doesn't roll up at all. Then EndBal does for both Entities. It seems each of these Flows have different behavior. What am I missing? **putting auto-translation of USD on the parents does not help, all IsConsolidated settings on the calculated accounts are True **

Originally posted by Eric Osmanski3/22/2018 Does anyone know if there is a significant performance impact when grabbing data from different cubes and writing data to/from different Cubes within a calculation? Is it faster if the data used in calculations exist in the same Cube? My gut tells me yes, but I wanted to confirm.

Originally posted by Steve Mebius 11/13/2017 Anyone set up a workflow where a review parent CANNOT see the data for that period until the dependents are certified? THey have view for all entities, but dont want them to see it until then