OneStream Platform Forums

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 Armando OrtizHi community, Does anyone knows if there is a limit on the number of lines that can be submitted to OS from an Excel sheet and what is that limit? Thanks in advance for your valuable help.

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 Retha DuPlessis Can you please confirm if there is a report that list all the users?

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 Cheryl NastaWhen multiple QuickView files are open, but only one is connected to the Add-In, users have experienced long refresh times when refreshing the one sheet in the active file. Is this common and is the best practice to only have one file open at a time?  What contributes to the latency in refresh if the other files are not connected?

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 Kathy Dyda I am setting up Transaction Matching for our Cash Reconciliations.  I have ~70 separate data sets and the data source is one file - thus I am using Data Splitting.  A separate workflow profile is needed for each data set - properties are the same only the name is different.  It seems I should be able to copy a sibling profile, change the name and save.  I have not found a way to do this.  Any recommendations? (for a bit of humor, if anyone is curious it is six page downs, and five arrow downs to get to the 0_Frame_TXM_OnePlace - Transaction Matching workspace dashboard)

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

Originally posted by Matt Brown Is it possible to add number formatting to data in cubeviews depending on the scaling selected from a delimited list? I've tried adding the number formatting to the delimited list e.g. "3, NumberFormat = 0.00" but the system won't recognize the exact formatting. Although it does recognize other formatting such as Bold or Italics.

Originally posted by Charlotte Mikes We see it in the data import but it goes to none when it get validated.   The IC code has been set up in the IC dimension. I don't know where to go look to find out why the IC code load but during transformation/validation it go to none

Originally posted by Nick Bolinger10/16/2019 Customer has users who will only be working with Quick Views in Spreadsheet and not the Excel add-in. Can they set custom cell styling like they can in Excel? In 5.1 and 5.2 there's the same cell styles toolbar and it says you can set your own... but where?

Originally posted by Rahat Fatma Hi,  I am using bound list parameters which query the table to bring the year, but default value remains blank even though I have set it to be a particular year. Is there was way to make the default value for bound parameters to actually work    

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 Christopher AyotteI'm building a report in studio and have a need to create a parameter that will capture the User Name of who is running the report. I know I can do this IN the report using Page Info control box. But I need to capture it as a parameter so that I can use the parameter as means to filter a SQL dataset query.   I've done this many time using SSRS, but I can't seem to find a way to do this in OneStream Studio Designer. Any suggestions?

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