OneStream Platform Forums

Hi All!  Our computer have recently been updated with the latest Microsoft patch and my colleagues and I have noticed we have lost copy and paste functionality within OneStream. For example, when I copy a cell from a cube view the following error occurs:In addition to this, we have lost capabilities to copy and paste members within dimensions. Has anyone seen this type of error before? Thank you all!  

Hello,   I'm new to Business Rule, and I'm struggling with the execution of a data management step with type "custom calculate". Currently, the execution of this script is giving me the message below : Error processing Data Management Step 'CC_FY2022_BUD'. Unable to execute Business Rule 'CopyData'. Invalid destination data unit in script 'A#Account1:C#Local:T#2022M1:S#Budget:U1#None:U3#T:U8#None:O#Import'.   In the Data Management step, I have defined elements in the POV and Data Units, and "Data Units" elements seem to be taken into account correctly, but elements in the "POV" such as U2, U4, U5, U6, U7 elements that have been defined in the POV of data element task (hierarchy nodes) seem like is not considered in the calculation.   So here are my questions: - What is the error message mentionned above actually saying ? - Are POC elements from the Data Element task taken into account in the Finance Business Rules ? - How do you efficiently debug a Business Rule ? &nbsp

Is there a way to validate the Total Debit or Total Credit amount of a journal and send back a warning/fail message if the total is over a certain threshold when we try to post/save the journal? Thanks

Jigsaw, one of the partners in South Africa needs to build an Onion Graph for one of our SA customers. Anyone have an idea how to do this?  

I have a report book I've built that loops thru a dimension and creates a tab for every member in a ud hierarchy. I've set book to label the tabs using the CVUD2 and CVUD2Description.  It works quite well except there are some descriptions that have hyphens in them which don't print out. Is there any way to print the hyphen included in some descriptions?

Hello! I'm looking for a solution to the new Quickview feature of splitting up Excel tables into pages, when the number of rows exceeds a certain number. I'd like to show all information in one page still, if possible.  

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  

Hi all, We have dynamic number of columns in our cube views/reports and it changes the number of pages that the rows go over based on the number of columns and fitting the the width of the pages.  Is there a way to make sure that the rows are set to a set number of pages high? Thanks

Hi, When creating a simple cube view using both calculated rows and columns, the intersection of these two formulas doesn't display correctly. Is there a way around this? See attached photo where Variance and Variance % columns both show the value of the first cell instead of the difference and difference percentage as they do in the other rows.

Hi, I would like to retrieve the value for a text attribute of a member - could be in any any dimension - in order to display it in a label on a dashboard. Can I do so with a generic XFBR?

Does the BI Viewer support ranking?

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    

Hi all How can I run a calculation for a subset of dimension members. Something like all base members of member Top, but not the none member, or just the members with text1 attribute = "Calculate", or just a comma separated list of members. Do I need a for loop? Cheers

I have a csv import coming from excel. One of the columns is of type date but when it gets saved into CSV the date is replaced by integers in the format excel uses to store dates. How can I convert those integers back into dates?

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 Rahul Joshi I am trying refer a intersection in member formula and apply condition based on the referenced cell.     Dim nvASP As DataCell = api.Data.GetDataCell("A#[ASP (£)]:F#No_Curr:I#None:U1#[Adjustment (Override)]:U2#None:U4#None:U5#None:U6#None:U8#None") If nvASP.CellStatus.CellAmount = 0.0 Then api.Data.Calculate("F#No_Curr:O#Forms:U1#Total:U2#None:U4#None:U5#None:U6#None:U8#None:I#None:A#[ASP (£)] = F#No_Curr:O#Forms:U1#Calculated:U2#None:U4#None:U5#None:U6#None:U8#None:I#None:A#[ASP (£)]") Else api.Data.Calculate("F#No_Curr:O#Forms:U1#Total:U2#None:U4#None:U5#None:U6#None:U8#None:I#None:A#[ASP (£)] = F#No_Curr:O#Forms:U1#[Adjustment (Override)]:U2#None:U4#None:U5#None::U6#None:U8#None:I#None:A#[ASP (£)]",,,True)     It does not consider the if-else condition and just process the first condition .Something which i am doing wrong in here ?

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

How can I use the api.LogMessage or BRApi.ErrorLog.LogMessage functions to print out the member names of a list of objects  like member, or memberinfo?

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 Yan SavinskyHow to check if time period is the last month in a quarter in the Business Rule?   Thanks in advance.   Yan Savinsky

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?