Application Build

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

Originally posted by Andy Moore 10/9/2018 All of my planning project thus far have been for USD only. In my FinReporting cube today i have entities 10 (Peso), 35 (USD) that make up a division NAA because entities cross divisions and in my Budget Cube i have Division NAA as my entity with UD1 as my legal entity with 10 and 35. My question is what have people done for currency assignment when the client plans by division but plans in local entity currencies when entities are now in UD1? Do you do simple custom translations where you translate entity 10 to Peso? What have people done in the past or have seen?

Originally posted by Stanislas Mareschal de Longeville 2/19/2020 Hi, my client wants to use translation rate by entity. Two entities that have the same currency may not have the same rate (not the same closing rate for example). This is not specific to a few accounts or flows. It should be applied to the whole translation engine.Does anyone have faced this issue ?

Originally posted by Scott Holt 7/25/2019 Security Template Question: The case is that for some groups the customer can have up to 9 plus users associated to a group but in the template, it is only planned for up to 5 children. I guess you could add columns but then the xml generation formula isn't updated to take into account the values in those extra columns. So does anybody have a pre-built one with the code amended for more than 5users to a group? Or do you just load multiple times?

Originally posted by Sam Richards 6/9/2017 I am trying to get security setup around nested dimensions. In the example below I want to have a user be able to have access to only be able to edit HL_Acct_Measures. I setup the security around the dimension property like below but when I assign that group to my test user it allows me to edit the Corp_Acct_Measures as well. Is this because the HL is inheriting the Corp accounts? Below are some screen shots of the setup. Screen shot of the HL Security Screen shot of the Corp Security Security on the test user showing assigned to HL manage Security showing no access given on the corporate manage

Originally posted by Celvin Kattookaran5/31/2018 I've a question on extending or adding a relation in Account dimension. Maybe the people who converted a Hyperion Planning can shed some light.I'm expanding the conversion utility that I created to migrate Essbase, I'm almost done with Planning and have few questions around Account dimension. Let's say I got 3 cubes in HP (Hyperion Planning) Workforce Capex Corp Now Workforce and Capex can have entirely different set of accounts. Corp can have it's own set of accounts and some accounts from Capex and Workforce - not all. I cannot find an example in GolfStream where this is done. Entity I can add a relationship from a different hierarchy, I cannot do that in Account (or I'm doing it wrong, which is probably the case).How have you guys done this, source plan type and valid for plan in HP converted to OneStream.

Originally posted by Nick Blades 4/17/2018 had a question around security groups....is there a limit (theoretical or otherwise) for the number of security groups?

Originally posted by Matt Grundey 11/30/2017 Hi all, is it possible to give a subset of users the ability to amend/update/move relationships within just one UD. I'm working with a client who have a contracts hierarchy in UD3 and would like to give a user in each division the ability to manage this dimension. Obviously, they don't want the users to be able to do anything to the other dimensions. I can't see anything in terms of security settings in the doc and my gut says its a no.. but thought I would ask.