Application Build

Originally posted by Laura Garcia4/25/2018 Question: If in the far future an Entity that exists in the Corp Cube (Top level cube for Workflow) wants to breakout into its own cube, what is the best way to handle this? Assume that we don't know which Entity this would be necessary for either, just a possible future need.

Originally posted by Jon Golembiewski 8/9/2018 Has anyone had the requirement to add a factor to an FX rate? For example the Yen FX rate would be 1.25 but then a factor of 100 would be applied to the rate during translation? I think this would have to be done in a custom translation rule but would like to know if anyone has handled this before.

Originally posted by Martin Toma1/25/2019 I wanted to know how you guys have addressed this issue before. My only thought was to create another WF that loads to the Planning Cube and have that feed from the stage table of the Actuals cube. This Planning WF would automatically be loaded (via Batch) upon successful load of the Actuals cube.   Question from the partner:   We have 2 cubes – one where we load actuals from EBS and another where we do planning. Data is loaded into the Actuals cube from EBS where we consolidate/group the lower level Entities into summary Entities via Transformation Rules. Essentially in Stage for the Actuals cube, the Entity dimension is more granular than what is in the actual financial modeThe Actuals cube is used to process actuals, elimination, adjustments, etc. and then we copy the data to the Planning cube.That works beautifully, but if I’m looking at my actuals from the Planning cube, and try to drill down, I only see what was copied over fro

Originally posted by Jeff Wood 10/21/2019 I have a point of view in local currency that looks like the following: Cb#OSTP:E#VCOC_CTX:P#Legal_CTX:C#Local:S#TXActualRTP:T#2017M12:V#YTD:A#TXPTIBA001:F#RTPProvisionVar:O#BeforeAdj:I#Top:U1#CA:U2#Gross_Input:U3#USGAAP_Total:U4#National:U5#None:U6#None:U7#None:U8#None When I pull the USD point of view for this same calculation, I get the following: Cb#OSTP:E#VCOC_CTX:P#Legal_CTX:C#USD:S#TXActualRTP:T#2017M12:V#YTD:A#TXPTIBA001:F#RTPProvisionVar:O#BeforeAdj:I#Top:U1#CA:U2#Gross_Input:U3#USGAAP_Total:U4#National:U5#None:U6#None:U7#None:U8#None My client does not want T#2017M12 for the FX rate but wants to use a 2018 FX rate. How do I override the FX rate? Any help is greatly appreciated. Thanks.

Originally posted by Henning Windhagen 11/4/2019 How do I change the data in a derivative rule that is returned? I have a derivative rule that returns the normal accounts and re-directs the data to a new entity. The problem is, the loaded entity is in GBP, and the new, re-directed one is in THB. (This is a management reclass, believe me when I say this is required by the customer...) Now I want to leave the dimensional derivative mapping as it is, but change the actual data (translate in the complex expression / BR) to be able to load it to C#Local in THB. Anyone ever done anything like that before? All I basically need is a way to change the returned data (same like the ""Multiply"" or ""Divide"" function, I would then just retrieve and apply the respective FX rate myself.

Originally posted by Karen Blackmon 7/24/2018 Can we change the FX Rule Type for a Cube after it has been used for USD activity only with no translation performed??We have dedicated cubes for tax that have been used for > than 1 year. Cubes are set with a FX Rate Rule Type For Revenues and Expenses = Direct. Client has not performed translation to date, though they have begun data assembly of opening balances in functional currency for a specific period. Client has made a change in process, and would like to use the Periodic translation method to translate. Since we have never performed translation on these cubes: - Is it 'OK' for us to change the FX Rule Type for Revenues and Expenses? - Will this cause data changes to our prior periods, (all in USD)? - Any special handling required for the opening balances that client is assembling in functional currency?

Originally posted by Eric Osmanski 8/1/2018 Has anyone written custom translation rules where they can send me some samples?

Originally posted by Nick Kroppe 10/6/2018 Hey Guys, what is best practice for handling fx rates for forecast or rolling forecast scenarios? If the client wants different rates by forecast, are there any other options outside of creating a new fx rate type for each forecast scenario?

Originally posted by Quentin Vermolen 8/7/2019 I'm trying to remember if setting the application currency (GBP) is what should be set as the 'Destination Currency' when entering FX Rates?

Originally posted by Cosimo Palmisano 10/24/2019 What's the best practice for setting rates on forecast scenarios?

Originally posted by Rassie Smit 12/10/2019 We have a possible requirement to be able to model currency translations across different versions.

Originally posted by Rob Dessureault 4/15/2020 Are there any issues with changing the default currency after data has been loaded?

Originally posted by Christian Wetterwald6/25/2019 I need to build an entity structure for a PoC that behaves like extensible dimensionality, for the legal scenario a member is base, but for management reporting it is a node. Simple for all dimensions except Entity. How would you solve this situation, is there even a simple solution? The second question is related. What happens, if all children of an dimension - entity or not - are disabled for a scenario or time period, will the node become a base member?"

Originally posted by Jessica Toner1/10/2020 I have 2 monolithic cubes in a demo app that both need to have a specific account with the same number. Since the account is already being used in one cube's account dimension, I can't add the account to the other cube since it technically exists within the application. Is there any way to add the member to the 2nd cube's account dimension? 

Originally posted by Pascal De Schryver7/4/2019 Does anyone have a document showing the work that is required to split a live cube in 2? The business case is that we will have regional cubes initially but that down the line might be split further if the client wants to add responsibility levels and further decentralization capabilities? For example we would start with an AsiaPacific cube since this the current organization but what is the work required if they decide after a few years to split it in 3: Asia, Australia and Pacific.

Originally posted by Christine Kennedy5/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.

Originally posted by Henri Roest 7/12/2018 Asking for a customer. Is is possible to apply currency translation on data in the Stage ?

Originally posted by George Waddell 11/6/2019 Hello, Working on a client App that does not require currency conversion (only USD involved). Wondering what any considerations should be with setup (present and future). Anything special to be aware of when dealing with only 1 currency? Future considerations with setup today vs. adding translations possibly in future? Also noticed when trying to enter data in CV to "Local" member for Budget Scenario, could not enter unless Consolidation Member POV was set to None (??). Entities are tagged as USD.

Originally posted by Cosimo Palmisano 8/1/2019 FX Report - do we have an out-of-the-box report, cube view or dashboard for showing FX rates stored in an app?

Originally posted by Andrea Tout 12/19/2019 Is there anything that we have that pulls when a user was created and by who? 

Originally posted by Felipe Alcorta Hi all: In our current model, we have 100-200 new dimension members every month with actuals from our source system.  Part of the maintenance is the manual add of descriptions for all these base members.  I am doing it via a grid view in the dimension library but OS only allows me to copy paste (from Excel) one at a time.  Is there a way to copy/paste multiple at once using the grid view?  Or is there a better way?  I'm hoping I can leverage Excel + OS front end rather than having to find a solution via the Marketplace. TIA

Originally posted by Keith Chapman Is It possible to add a member to the View Dimension? Say Current Month Vs. Prior Month Variance Member? We would like to be able to Drill down on the Current Month Vs. Prior Month Variance # that we now have created in a report.  

Originally posted by Alona Edwards

Originally posted by Dhwanish Patel Hello,  I have 12 different applications, and I want to provide access to 12 different users to these applications. How can I assign security to these 12 different users at once? Instead of going to 12 different applications and assign users. Thank you in advance.  

Originally posted by Dipali Pawar