Discuss the features and functionality of OneStream.
Recently active
Source: Migrated from Champions Hi! This is my first time posting but we’ve had multiple users trying to copy tabs that have quickviews to another file while keeping the connection instead of rebuilding. Is this possible? Thanks!
Source: Migrated from Champions I built a mass upload template leveraging XFSet to use for our budget and forecasting processes that has a quick view to pull in all the accounts in our account dimension. I did this so that if we add a new GL account, the quick view updates upon refresh and is available for the users to budget/forecast to, rather than having to update the template for the users. The XFSet is hidden so users don’t accidently break the formula. The quick view is also hidden for the same reason. I have the sheet protected to further mitigate risks of users breaking the template. The issue is when we go to refresh the template which refreshes the quick view, the protected sheet won’t let the quick view refresh. Does anyone have a workaround to protect sheets while still refreshing the quick view?
Source: Migrated from Champions Hi, is there a way to create ranking within cube view? for e.g. Ranking Top 20 branches based on branch Profit. I think it would involve writing a BR but not sure. Any ideas will be greatly appreciated. Thanks
Originally posted by Hans van der KempIf I look at the Data Adapters, it seems the method type "JournalForWorkflowUnit" contains the required information. So then I would need a Studio report based on that data adapter, similar to the RPTA -> is that the best approach?
Source: Migrated from Champions How can I create a cover page in an XLbook (first tab in the excel book)? I have tried uploading .xlsx and .xfdoc.xlsx single tab excel files into File Explorer under Application Database and System Database. The cover pages don’t appear when the XLbook renders. This does work for PDFbooks.
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 James Kirkby Hello: I want to have a confirmation rule write a value to a single intersection (api.data.calculate) by either calling a finance business rule or writing the calculate directly into rule text. The rule loops thru base entities and certain accounts, then writes the value stored there to a single member; basically, a check to ensure that all base members foot to the top of a hierarchy in USD (We have had issues with this in the past, and now have historical data that doesn't foot in certain areas identified in our most recent conversion.) I don't want this to run on a member formula as it will significantly slow down consolidation on all other data units, and this really is a confirmation by nature; a data quality check. Our consultants suspect that this may be by design; that during the running of confirmation rule, the cube can't get written to. PS - I can confirm the data calculate is in fact running as I'm writing the calc string to the error l
Originally posted by Brad KoteckiWe have a business rule set up that emails users once completed. To do this we used the sample under Snippets>Other>General>Send mail. Is there a way to BCC the email addresses on the email, rather than sending directly to everyone as a group?
Originally posted by Cosimo Palmisano3/16/2020 When I then try to use this parameter in an XFBR call, the NameValuePair dictionary doesn't contain the full string value and it only contains the 1. Everything after the 1st comma gets truncated. Is there a workaround to this issue?
Originally posted by Ramanathan GanapathyHello All, Currently Our Default Currency in the system is 'USD". The system is rolling up the value correctly for the all the flow member formulas for USD. We also defined additional currencies in the system and for that the base value is not rolling up to the parent. Is there is any formula available for us to use for the Parent to do the aggregation instead of Translation? Thanks & Regards, Ram
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 Ashok AmreshI am trying get rolling average of an Account (i.e. average of prior 8 OR 12 quarters ). i am New to Onestream and really finding hard to find function etc. any help is appreciated.
Originally posted by Marouane TalbiHow to write a UD conditional rule that would map the UD based on the target account : 1. For target accounts under the EBIT hierarchy, the UD should be mapped to "NO_UD" 2. For the remaining accounts, the target UD should be mapped according to the mapping of the transformation rule table.
Originally posted by Charlotte Mikes i created a report from xfgetcells. is that uploadable into a new cubeview?
Originally posted by Carien ClassensOur client has a requirement to manage ownership data on a monthly basis in multiple structures. Is there a solution to load ownership data with the use of excel? Something similar to: (XFGetRelationshipProperty("Entity";$A12;$B12;"PercentConsolidation";"Actual";C$2) Thank you
Originally posted by Darryl GerrowWe have a number of cube views that we automate delivery to Excel using Books, but would like to know if there is a way to set the Excel Freeze Pane settings in the cube view itself so that users don't have to set it when they receive the Book?
Originally posted by Felipe Alcorta We have quite a bit of entities across many currencies. Is there a way to incorporate into a CV the associated currency (found in the currency setting of the member props) for a specific entity?
Originally posted by Bob Nelson When using an If statement inside of a loop the reference guide only shows example of = and <>. Are there other conditional statements that are supported by an If statement in report books. Specifically I am looking for "contains" a certain text string or "does not contain" a certain text string. I'm also open to using a Right command to parse the Loop variable as in if Right(loop variable, 4) <> "_USD". Thank you,
Originally posted by Kimberly Reasonerwe have several employees who receive inventory reports with XFGET Cells, that do not have a license. When they open of course they are getting #Value. Is there a setting that can be used so that everyone can see the data, without wasting time saving it off line for several people. thanks,
Originally posted by Lawrence ManekinHi, Working on a POC for a client. To get data in quickly, I uploaded an Excel document so I can run a pivot off of it. The Excel is in the public folder. I'm using this syntax {Application}{Documents/Public/GLtransrevfields.xlsx}{Sheet1}{MyRange}{True}{True}{} but it keeps telling me that it's invalid. I have tried calling out the specific application name as well, but no luck. Any suggestions would be appreciated. -Larry
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 Bart DeHaas I have a cubeview that is run in a reporting book. I have created a Cubeviewer extender rule to change some formatting. For example, to put a different logo on the report based on the entity. It works fine. On the report there is also a header line and I can adjust the header line height by the following code ElseIf uiItem.UIItemType = XFReportUIItemType.PageHeaderLabelBar ThenuiItem.Height = 1 I also wanted to change the color to the company color. But it does not do it, I used uiItem.Bordercolor. But it keeps it black (See below picture, what I am looking for). Does somebody know how to do this?
Originally posted by Mike KralCompany has a few hard carriage returns in their data file. OneStream processes it without error but multiple lines gets created and the data does not get loaded. Looking for guidance or a snippet of code to add to the data source to remove this hard return and get everything on one line. Thank you!
Originally posted by Dayla King
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.