Application Build

Hi experts, I would like to get some feedback on an issue that I am facing with the current build. I was unable to submit data for the Actual scenario via forms. I had tagged the scenario with the scenario type 'Actual'. After checking all the usual areas, I changed the scenario type to 'Administration' and assigned the same dimensions to 'Administration' scenario type (that I had selected with the 'Actual' scenario type) from the 'Cube Dimensions' screen. And, I was now able to submit data for the scenario via the same form! Could this be something related to a scenario type corruption and how do we go about fixing this? Regards, Sou  

Originally posted by Diane Rochford Has anyone copied FXRates from prior month Closing FXRate to current month Average FXRate?  In HFM, I can copy last period in year closing FXRates, Actual scenario, to both current closing and current average rate, constant $ scenario. I was also able to copy the prior month closing rate to all future period closing rate and average rate within the Forecast scenario. I would expect I can do these copied within OneStream, I just cannot find where, or how, I can accomplish this task.   Help is greatly appreciated.   Thanks Diane    

Originally posted by Geoffroy des Dorides 1/3/2020 What is the simplest way to prevent a user that is able to certify to un-certify : In a base input workfow I have a task requiring a certification Therefore user are in the security group that allow ""Certification SignOff Group""I would like that these users are able to certify but not uncertify.(for design reason I cannot activate lock after certify functionality)what is the simplest way to achieve this? "

Originally posted by Kathryn Watkins 4/23/2019 Have a security design question I wanted to confirm. Herbalife wants to restrict the IT system admins from seeing any data and make sure that they can only add / edit / provision users. If they just put users in groups that are assigned to the system security roles SystemPane and SecurityAdminPage, they can see the page but are not able to edit the users' provisioning.

Originally posted by Arpit Maheshwari Is it possible to clear the sign-in info from the OneStream Desktop Client ?   We are using Microsoft Azure AD for SSO and every time we login, we get to choose which account to use for the login. Recently, the client is taking the account that is being used to login on the machine. Is there a way for me to use another account (separate account for testing with limited privileges) on the same machine ?   Thank you for the help

Originally posted by Gene Halbrooks Have a user who's windows is blocking the OS app from running, any others?  no recent changes to OS, and no recent changes to user system config.

Originally posted by Dayla King

Originally posted by Debbie Hinds Hi all, We are a new customer to OneStream and in the process of implementing the application.  We are wondering if anyone has a set of general test cases that you used for testing during UAT and willing to share with us.  Thanks, Debbie Hinds PRA Health Sciences

Originally posted by Oussama Bourakkadi Hello, how can we delete multi selected members from a dimension?

Originally posted by Kyle KohneOver the past 2 year ends we have struggled in January close with certain data pulling forward correctly.  These issues stem from our set up of rules for pulling beginning balances related to Retained Earnings and some within our NCI .  Has anyone created a quality methodology for testing future periods.  What I'm thinking is if we only have data in January and maybe February to push that data all the way through December to see how the beginning balances will roll in January.  

Originally posted by Ramanathan Ganapathy Hello All, Currently, we are loading the exchange rate source currency as "USD".  We want to change the same from "USD" to "GBP".  Currently we have the default currency as "USD" in the Cube.  Question: 1) Is it possible to change the source currency from "USD" to "GBP" 2) What impact we should consider when do this change? Thanks & Regards, Ramanathan          

Originally posted by Robert Wang I get this error message when trying to load metadata, it has worked on other applications so not sure why this one isn't working?

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?