OneStream Platform Forums

Hi All, I have written below rule where, I am not able to see the results, But rule is executed without any errors. Rule is about : Writing up the source values based on the Tex1 and Tex2 assigned in the source Accounts. where Text1 & Text2 are target Intersections to to actually be written to... Kindly help me if something is missing in the code. Dim ResulDataBuf As DataBuffer = New DataBuffer() Dim DestinationInfo As ExpressionDestinationInfo = api.Data.GetExpressionDestinationInfo("V#Periodic") Dim DataBufFilter As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(V#Periodic,[A#[BS].Base.Where(Text1 <> vbnullstring And Text2 <> vbnullstring)])") For Each sourceCell As DataBuffercell In DataBufFilter.DataBufferCells.Values Dim cashflowCell As New DataBufferCell(sourceCell) 'Temp buffercell within the loop to copy my cashflow cell Dim sText1 As String = api.Account.Text(cashflowCell.DataBufferCellPk.AccountId, 1) 'Source Mvmt Dim sText2 As String = a

Dear Community  We want to update an application from the 6.8.1 version to 7.3.3 of OneStream.  Is there any possibility that the member ID could change from one version to another?  Thank you in advance 

We in the process of data validation and are constantly getting  "Exception of type 'System.OutOfMemoryException' was thrown." I know in hyperion we should change the time out.  Is there something similar we can do with onestream?      

I have currently set up a new data source and associated transformation rules (and allocated to the appropriate workflow). Data importing is correctly working for 2022 time period, however I am getting the following error in any other time period......I have got the Scenario as 'Current Datakey' and Time as matrix datakey in my columnsSummary: No valid DataKeys (Scenario / Time) found in data source.  Review the source data load processing log and check one-to-one transformation rules to ensure that you have created proper Scenario and Time dimension rules for this data source. Any ideas? I am assuming this might be one simple setting change somewhere 

Hi All, Is there a possibility to update WFScenario for all users of the application from back end through a Business Rule? When moving the app from one quarter to another for Financial Regional planning, some of the not so tech savvy Sales users are forgetting to change their WFScenario and triggering the calculations which are erroring out due to older scenarios being locked. We would like to have Admin update WFScenario for all the users of the application as a maintenance task.  Please let me know if the below would work for all the users. Or any other leads would also be appreciated.  

Hello,is there a way to grant access to unlock WFs by scenario. for e.g. we need the FPA team to be able to unlock budget WFs and the consolidation team to unlock actual scenarios. Currently, they both have access to unlock all WFs.Thanks for your help. Hadi 

Hi All,   I am using  Import , Forms and AdjInput   for Different columns in One Cube View but I want to Hide those names in the Cube View which are highlighted in Red color in the below picture, Can anyone suggest how to  Hide/ Rename those names?   Please find the attached screenshot for your reference         Thanks in Advance.        

This is OS v7.4.1It is running in a Cube View Extender Rule.I've tried both CubeViewGrid.ExpandedRowHeaders  and CubeViewGrid.AllExpandedRowHeaders    expandedRowHeaders = cubeViewGrid.AllExpandedRowHeaders; int rowNum = 0; StringBuilder sb = new StringBuilder(); foreach(CVGHeader cVGHeader in expandedRowHeaders) { List<CVGHeaderItem> headerItems = cVGHeader.HeaderItems; sb.Append($"Row[{++rowNum}]:"); foreach(CVGHeaderItem cVGHeaderItem in headerItems) { if(cVGHeaderItem.MemberInfo.NameAndDescription.Length>0) sb.Append($"{cVGHeaderItem.MemberInfo.NameAndDescription}|"); } sb.AppendLine(); }    Using cubeViewGrid.ExpandedRowHeaders yeilds :Using cubeViewGrid.AllExpandedRowHeaders yeilds (ironically none of the nested members on Column2): I'm not getting the members shown in the green boxes:  

Hello OS Team,I am testing a few things in the latest version 7.4.1 and noticed something changes from 7.3 but was not mentioned in the release note - so just want to double check in case I missed something:For this Import step, I don't have anything configured in "Calculation Definition", in 7.3 I am able to Load and Process cube without any error, however in 7.4 - the "Load And Process Cube" only did the "Load" and when clicked on "Process Cube", I am seeing the following error.I actually like this change - could you please let me know whether this is indeed one of the changes in 7.4?Many thanksWei

Hi,Is there a report to check how data was entered into OneStream i.e. through Forms or Imports ? We are using cloud version of OneStream.Regards,Avijit

If you encounter an Amount field that has spaces as the thousands separator AND includes a DR/CR indicator (e.g. 12 345 678 D) then you'll need this to parse the value: Dim strRawAmount As String = api.Parser.DelimitedParsedValues(4) ' Zero-based and adjust for your columns! '----------------------------------------------------------------------------- ' If not empty then remove space separator and interpret D/C indicators If Not String.IsNullOrEmpty(strRawAmount) Then Dim strAmount As String = strRawAmount.Replace(" ", "") ' 12 345 678 D becomes 12345678D Dim strDRCR As String = Right(strAmount, 1) ' D or C on end of string? Dim dAmount As Decimal = Left(strAmount, len(strAmount) - 1).XFConvertToDecimal ' Strip D or C and convert to Decimal '----------------------------------------------------------------------------- ' Did conversion to Decimal work? If IsNumeric(dAmount) Then '

Im trying to create a workflow Event Handler that kicks off when lets say a period is locked April 2023 will then kick off a stored procedure that copies data from a table leveraging the wtk of the locked period.  

Summary Is there any documentation and/or sample code showing how to use the new "dbWheres" argument in a LookupRowFieldValue() function? Detail In version 6.8 (maybe earlier), if you use .LookupRowFieldValue() with your criteriaExpression (i.e. - your where clause) as a string you get a warning that this syntax is obsolete. It still runs, but obviously we shouldn't use it going forward. So, something like this now throws an warning: .LookupRowFieldValue(si, dbLocation, tableName, criteriaExpression, fieldToReturn, defaultValue) .LookupRowFieldValue(si, dbLocation.Framework, "SecUser", Name = 'Phil Brosnan', "Email", String.Empty) OneStream wants you to use a new Syntax that replaces the criteriaExpression with a list of where clauses in a dbWheres object. .LookupRowFieldValue(si, dbLocation, tableName, dbWheres, fieldToReturn, defaultValue) Unfortunately, there is no documentation or examples on what a dbWhere object is, how to create one, or how to pass that dbWhere object into your

Hello, For Planning we use a scenario of type Model, on this scenario I do not find why consolidation on Revenue accounts is not working. The translation is working, but it does not aggregate or consolidate to group level. For accounts of type Flow (for volumes) it does work. Setting on the account is: Is Consolidated (Regardless of Formula Type), no formula is active on the account. Apart from that it happens also on asset accounts. I checked the Business Rule for consolidation, but couldn't find anything related to scenario or account. Any hints where I could look would be much appreciated. Kind regards Ben  

I have a BR that copies Actuals scenario data to a planning scenario (Mgmt_Actual).  It copies Post close adjustments that only exist for USD->AdjInput in Actuals from/to the USD->AdjInput and like Actuals there is no local data in the Mgmt_actual scenario.  I then try to copy the same data from the Mgmt_Actual to a forecast scenario.  But the calculate data writes to the Local->AdjInput (consolidation/Origin) member, not USD.  And when I run a consolidation it calculates USD with the Origin member AdjConsolidated.  I'm using the exact same code to copy (calculate)  the two scenarios.  Any ideas why one calculates USD->AdjInput, yet the other lands at Local->AdjInput? 

  Does the api.Data.GetDataBufferUsingFormula("FilterMembers(...)") only get cells that have values?  Is there a way to create a data buffer with empty cells?  Use case:  We need to to cycle through an account hierarchy and populate each base account with data from an intersection of a specific Account, UD2, UD3, and UD4 that are defined in the text fields of the particular account that is being populated. The other dimensions of the data buffer are limited to a single member (i.e.":V#YTD:F#End_Bal:O#Import:U2#000:U3#0000:U4#0:U5#None:U6#None:U7#None:U8#None")  

Hi All, We have 8 sibling Import workflows under one parent(Base Input Type Parent). We have one entity that's being used to load data in all 8 import workflows. Because we have good volume of data and multiple users loading the data to each workflow, whenever someone try to load the file through any workflow it is processing Load Cube for all remaining workflows as well and this process taking long time. It seems to be expected behavior of workflow design but Is there any recommendations that I can try to reduce the processing time ? Any suggestions would be much appreciated.Thank you. 

New install of 7.3.1.WebServer on one machine.  AppServer on another.When I attempt to access any of the WebServer pages, I am prompted with a very odd login page.The only fields on this page are a missing header_logo,  username/password fields and a login button.I tried to log in with the default Administrator password and it says "The password was reset and needs to be changed."  I have not logged in to OneStream yet, so the default password should not have changed.Since I cannot access OneStream, I am not able to reset the password.I have no idea where to start looking to resolve this one.Any help would be appreciated.Raymond

Hi EveryOne!!!! Dim resultDataBuffer As DataBuffer = New DataBufferDim destinationInfo As ExpressionDestinationInfo = api.Data.GetExpressionDestinationInfo("")Dim dataBuffSource As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(F#myF,A#XYZ.Base)") For Each sourceCell As DataBufferCell In dataBuffSource.DataBufferCells.Values BRApi.ErrorLog.LogMessage(si,$">> {sourceCell.GetAccountName(api).ToString} {sourceCell.GetFlowName(api).ToString}" ) Executing the code above I would expect to get base level accounts of node XYZ with Flow Member myF. However, I am getting the base level accounts but the Flow member is XFCommon. XFCommon is not even a Flow dimension member! Any ideas what I am doing wrong !? Thanks!

We are loading files into OS that have substantial amount of data, for some reason I am able to import the file but upon validating, I do not see any kicks out or any error, the validate tab stays the same and Load tab remains greyed out. I am unable to load the  cube. Anyone else experienced this before?Thanks GSJ 

I am looking for an option to read the parsed Excel file XFD range and check if it contains any #Value! cells. I am able to find a point in TransformationEventHandler business rule to capture the parsed data (TransformerObject.Parser.DelimitedParsedValues), but it's not giving all parsed data every time and giving only few lines sometime.Can you please suggest some solution to validate Excel file XFD range before loading it into cube.Also where can I find the details of the classes in OneStream specifically for OneStream.Shared.Engine.StageRangeContent

Hello Everyone,We are setting up our Consolidation and Planning application.In Consolidation we would like to set up workflow by entity (legal entity) to support consolidation.In Planning application, we would like to set up workflow by Business Unit to support planning activities by BUSINESS Unit Owner.any thoughts on how we can set up workflow as described above?Thanks, 

My client is using the 7.2.3.14520 server and getting an error message that says:Unable to log on User ''.  Your client XF version '7.2.14520' is incompatible with the XF server version '7.2.2.14307'.We get that error message when using the URL or the (7.2.3..14520) Windows client.  Same error. We are able to click through and login.Any ideas?

Hello, When I execute a Data management sequence or a custom finance function, I have this pop-up that will be shown to the user : Are there any ways to customize what will be shown to the user in this pop-up ? For instance, I want to  customize the message that will be shown in the blank text field below "0% Complete" or the message next to the task when it is running : Many thanks for your feedback ! Regards,

I have a process that causes contention if launched concurrently by users. Is there a way to check if a session with a specific description is already running? I would like to abort the session if another session with the same name is already running. I tried looking through properties and found "GetTaskActivityItem", but the definition and sample are not of much help.