OneStream Platform Forums

Hello,  I am wondering if there is any way to change a fiscal year once we have been using the application for quite sometime (several years.)  Our current Fiscal year is 2025 so all the data is being imported into year 2025, but we now need to adjust our fiscal year one year back.  So everything in 2025 becomes 2024.   Is this possible?  Or what options might I think about? Would I need to setup and start using a new scenario? Any ideas, comments, suggestions would be greatly appreciated.  Thank you  

I have a dashboard with a cubeview.  The user is allowed to enter data into multiple cells and then save.  I have a save event handler to verify the data entered, however, I cannot access all of the information at one time.  The event handler provides access to one cell at a time.  Also,within each row I have a cell where users may change the numeric value and another where they type in an annotation.  Changes to the numeric value cells will fire the event handler however changes to the annotation cells alone will not trigger the event handler.  Is there any way to access the entire cubeview pre saved data to verify entries.  I need to know that if a user entered a value that they also entered an annotation or if the user removed an annotation where a numeric value existed on that row.  

Hi all we have this error with our SIC connection to SAPhe SSL connection could not be established, see inner exception.)The SSL connection could not be established, see inner exception.Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host..An existing connection was forcibly closed by the remote host. (Socket Error Number 10054)Anyone seen this before and knows how we can resolve?Nouria

Is it possible to copy a value from one cube to another mutually exclusive cube with a Custom Calculate business rule? I am trying to copy a value from the Cb#Financial cube to the Cb#CASH cube.  However, using the “api.Data.Calculate” code below I get the error “Invalid destination data unit in script” even though the Data Unit defined in my Data Management step matches the target cube Data Unit.Dim sTops As String     = ":C#Local:S#AOP_Final:V#Periodic:A#BGMOPEX:F#EndBal_Input:O#BeforeAdj:I#None:U1#TopUD1:U2#TopUD2:U3#SALARY:U4#TopUD4:U5#TopUD5:U6#TopUD6:U7#None:U8#GC_USD"     Dim sNones As String = ":Cb#CASH:E#US01:S#CashForecast_Forecast:T#2024M10:C#Local:V#Periodic:F#EndBal_Input:O#Forms:I#None:U1#None:U2#None:U3#NoVendor:U4#None:U5#None:U6#CashForecast_Plan:U7#None:U8#GC_USD"                            

Hi All,Could you please provide the code for sending a CSV file from OneStream to the SAP environment using the PUT API?Thanks,Chandrakala  

I have a Cubeview that's Header rows are Entity/Account/UD2.  I'm going to export to excel, but currently I get column A is Entity, Column B is Account and Column C is UD2. I'm trying to figure out if there is a way to make Column B be a concatenation of Account and UD2 when it's exported.  Column C can be whatever or not at all.

Hi All,As the name states above I'm trying to dynamically modify suppression settings on a column in a CV based on a value selected in a parameter. So for example let's say if a user selects an option from a parameter I want to modify suppression settings on certain columns based on that selection choice. I have two questions:Is there a way to do this?If there is a way, how would this business rule/function be passed? In the CV? In the Cube? Thank You...Any assistance on this would be extremely helpful. 

Hello, I'm somewhat new to writing code for confirmation rules. I'm trying to create a confirmation that is only for 1 entity and we'd like it in our general rule groups for confirmation rules and not have to create it's own rule profile.  Basically we need to the rule to be If WFProfile Entity <> 02140 return True, if not then (enter rule I already created). I couldn't find anything in the documentation about making it entity specific and excluding other entities. Thanks, Will

Hi, Is it possible to attach a file from the public folder to the mail using the function, BRApi.Utilities.SendMail(si, emailConnectionName, toEmailAddresses, subject, body, attachmentFilePaths) Would appreciate any assistance. Thank You.

I'm trying to load a workflow using an Excel template and need to set the *WorkflowName* as one of the following: Import, Validate, Load, Process, Workspace, Confirm.Currently, I'm using the highlighted value in the *Workflow* column for this purpose.Similarly, if I need to set the *WorkflowName* to Workspace, Direct, Process, Confirm, Certify using the template, what value should I use? Is there a reference list for this, or where can I find it?   

Hi- I was wondering if there is any way to combine 2 cube views that are already built. Assets and Liabilities are on 2 different reports and I am trying to combine into 1 report. 

Hi All,  I would like to execute a batch posting of all unposted journals in all base workflow profiles. Is there a way I can execute the posting via business rule?  Thank you in advance. 

Hello All,Is it possible to establish a connection between SAP SuccessFactors and Onestream?Thanks,Chandu  

Hi All,We currently have BiBlend set up to use all 20 attributes. We're considering reusing two attributes to load data from different columns (these attributes are currently used but are no longer needed). Our plan involves renaming these attributes in the Cube Settings and updating the data source.Does anyone know if this is possible? Are there any restrictions or limitations on how attributes can be used or modified after the initial configuration?Thanks in advance for your insights.

I have a dashboard with buttons that export excel workbooks. I have one cubeview that uses Column Sets and I am not able to get this one to work with the button. I was hoping either a combo box or pop up parameter would work, but I cannot get the export to recognize the columns. When I manually run the book from file explorer it gives me the column set parameter and works just fine. This leads me to think I'm missing something in the button execution.Thank you!

Hello,  Can the Excel format be set on the cube view so that the header font can be underlined, for example?  New Product Analysis instead of adding a guideline for the entire header cell?

Hi Everyone. I have a question about how I can assign the entity that appears in my Calculation Definitions to my assigned Data Management Step. Currently, I have it set to E#Root.WFProfileEntities, but since I have it in a Profile that does not have entities assigned (because it is a Profile where I want to mark all my WF as complete), it gives me an error when I try to use it from there.  

how can i retrieve the WF (year-1) M12 in CV column?  example: WF year: 2023, 2024, 2025 CV column time parameter: 2022M12, 2023M12, 2024M12

how can i change the Is IC account parameter to true from 2025?  for historical data it should be false

I have captured journals at a base entity on C#OwnerPreAdj . When I process the cube, the values do not get consolidated. I have to run a Force Consolidate for the result to come through on reports.  I have set my cube settings for Calculate OwnerPreAdj if No data to True.  This is on Onestream Version 8.4.

Hi Everyone, I'm designing a form where I display accounts in rows and columns header like Beg Bal, End Bal, Variance, etc. In the rows, I've configured a member filter as follows, which pulls all accounts under the PREPAY hierarchy, but excludes A#150123: A#PREPAY.Base.Remove(150123):Name(|MFAccount| - |MFAccountDesc|) This works perfectly, as it displays all the accounts under the PREPAY hierarchy except A#150123. However, when I try to display the total, I encounter an issue. I'm using the following member filter to display the total, but it doesn't work: A#PREPAY.Remove(150123):Name(Total: Prepaid RF, net)orA#PREPAY.Remove(A#150123):Name(Total: Prepaid RF, net) As a workaround, I have displayed the accounts under PREPAY individually and used the following formula to display the total: Is there a simpler or more efficient way to achieve this without the workaround? TIA

Hi Everyone, has anyone already tried to reference a Workspace Assembly business rule from a Finance or a Connector business rule? I have a business rule that is packaged to an Assembly in a Workspace:   It has a set of public functions returning dictionaries and other variables. And I would like these functions being called from a Connector. I can successfully reference it from another Assembly workspace. But when I am using the same syntax in a connector, that is not working:   I am assuming the referenced Business rule must be declared in the Properties, but I am not sure of the syntax. Or even sure this is accepted. Many thanks to anyone who can helps!

Howdy,When using Guided Reporting, the Selector List Labels are not being positioned correctly. As shown below, the label is positioned on top of the next parameter (to the right) instead of the parameter it's associated with. Has anyone experienced this before and have a solution?  Additional information:Occurs in every report when viewing in Guided ReportingGlobal Selector List Labels are aligned as expected  Thanks in advanceMantis   

Hi all,  I'm after some guidance for a capex form that I'm currently developing. Simply, it's a form that takes the current month closing balance (BS accounts) less the prior month closing balance, and need to categorise these movements.  At the end of FY24, 2 entities liquidated (LQE) and transferred assets to a new entity. In the entity dimension, it's timestamped in the 2 entities as no longer in use from FY25 M1 onwards. So for FY25, there is no form to fill in for the 2 LQE's but there is for the new entity. However, at group level, it shows the FY24 balance with 2 LQE's and no balance for new entity, and FY25 is no LQE's, just the new entity. Because the setting means the 2 entities are no longer part of the group, it's no longer showing in the movement columns. See below.  The real movement for the month to be explained is -33k, but the calculated movement ignores the 2 LQE's and just shows the new entity with +164k addition. Any ideas how I can develop this form

We are looking to turn some of our existing cube views into report books to loop through entities. Right now we use an XFBR string (referencing Brapi.Workflow.Metadata.GetParent) instead of a parameter to determine the entity. Is it possible to create a report that loops through the entities with the XFBR string or would we have to duplicate the cube views and use a parameter instead?