OneStream Platform Forums

I have used SaveCustomDataTable in OS v9.01 where you need to clear the data before loading the table and it works fine.Recently i was building similar logic in OS v8.2 and noticed that it was truncating my table , is this expected or is there something i am missingit is the standard call:BRApi.Database.SaveCustomDataTable(si, "Application",Table,dt,True) 

  Hi, we are looking for guidance and experience on automating the process of exporting  fx rate data from OneStream to Google Cloud Platform (GCP).What is the best approach to automate this data flow from OneStream to GCP?Are there recommended methods (API, connectors, data pipelines) for this integration?Any best practices or examples for handling FX data in this setup? Thank you!

Hi All,I am writing an Connector BR to connect to a system via their API.  I first build the rule as a Extender rule so that I can test the logic.  So far it works great.  It uses Asynchronous processing on all of the web calls.  When I try to move that code into a Connector BR, I am having an issue on the GetFieldList part of it.  When I try to use it in a data source, I get the following error:Unable to cast object of type 'System.Threading.Tasks.Task`1[System.Object]' to type 'System.Collections.Generic.List`1[System.String]'.I am guessing this is because the Main module in the BR is  public async Task<obect> Main so whatever is returned is going to be a Task<object>.Has anyone done Asynchronous processing in the connector rule and had the GetFieldList part working. My only thought to get around this is the write the data to a table/file with the Extender BR then the Connector reads that.  Any thoughts are greatly appreciated.

HiI'm look for a solution to perform time dependent mappings. For example: SourceTargetPrior to Dec 25xyDec 25 onwardsxzHas anyone come across the need for the before? And if so, what solution did you implement for this? Did you notice any issues with performance etc?Thanks,Mark

Dear community, I couldn't find any documentation about Storage Type and Existence Type. Any help or hint toward documentations would be greatly appreciated, especially on the one highlighted in red below. What I mean about storage type and existence type is the status associated to a specific cell: Storage Type: No data IsRealData IsDerivedData   Storage type: StoredButNoActivity Input Journals Calculation Translation Consolidation DataCellDetail DurableCalculation Regards,

Hello Fellow OneStream team - I have multiple csv file in a file share folder, using BRApi.Utilities.LoadCustomTableUsingDelimitedFile to do the job, but it's loading only single csv file into the custom table. Below is extender BR , not sure what am I missing in the For loop, guidance is appreciated.    Namespace OneStream.BusinessRule.Extender.Load_Table_Data Public Class MainClass Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As ExtenderArgs) As Object Try Select Case args.FunctionType   Case Is = ExtenderFunctionType.Unknown 'Select Load options Dim loadMethod As String = "Replace"                   '<-- Select file load method (Replace, Merge) Dim dbLocation As String = "App"                       '<-- Specify db type Dim tableName As String = "XFC_OStoSF_BudgetData"       

After upgrading to 9.1 recently we can't use our Application Reports because of this.Error compiling Business Rule 'RPTA_SolutionHelper'. 1) Error at line 13635:  Type expected.  This line is causing the error.Dim dataWcfService As New Data() Even if I were to fix that line the next line would be wrong because there aren't any overloads that accept a GUID for the GetFXRateType function.  Private Function GetMemberPropertyGuidValueAsText(ByVal si As SessionInfo, ByVal objPropEnumTypeItem As PropEnumTypeItem, ByVal storedGuidValue As Guid) As String Try If (Not objPropEnumTypeItem Is Nothing) Then Dim editorType As XFDataColumnEditorType = objPropEnumTypeItem.EditorType If (editorType = XFDataColumnEditorType.WorkflowChannel) Then If (storedGuidValue <> Guid.Empty) Then Dim wfWcfService As New Workflow() Dim wf

We are having an issue with users and page breaks in the excel add-in.    Example 1:  A user creates a cube view connection and pulls said cube view into an excel worksheet.   The result, however, does not render all the rows.  There is a page break and they are forced to page through to see the rest of the rows.   If I replicate these actions, I do not get the same page break, my results render all the rows on a single page.  No page breaks.  We went through preferences and other excel settings together to make sure our settings matched.  What is causing this to happen?  What other things can we try to resolve?   The user must have all the rows displayed at once (no page breaks).  Example 2:  A user creates a quickview only to have the results get cut off with a page break.  If I replicate the quickview, the return does not cut off the rows.  I get everything on the sheet.  Any hints, tips,

statement 1: gives zero which is correct =VALUE(XFGetCell(TRUE, "CONSO", B19, "", "Local", "ACTUAL", "2025M2", "YTD", D19, "F99", "BeforeAdj", "Top", "U1TOP", "U2TOP", "U3TOP", "U4NONE", "U5TOP", "U6NONE", "U7NONE", "U8NONE")) statement 2 : gives value which is correct =VALUE(XFGetCell(TRUE, "CONSO", B19, "", "Local", "ACTUAL", "2025M2", "YTD", D19, "FNONE", "BeforeAdj", "Top", "U1TOP", "U2TOP", "U3TOP", "U4NONE", "U5TOP", "U6NONE", "U7NONE", "U8NONE")) statement 3: gives incorrect value =VALUE(XFGetCell(TRUE, "CONSO", B19, "", "Local", "ACTUAL", "2025M2", "YTD", D19, "F99", "BeforeAdj", "Top", "U1TOP", "U2TOP", "U3TOP", "U4NONE", "U5TOP", "U6NONE", "U7NONE", "U8NONE"))+VALUE(XFGetCell(TRUE, "CONSO", B19, "", "Local", "ACTUAL", "2025M2", "YTD", D19, "FNONE", "BeforeAdj", "Top", "U1TOP", "U2TOP", "U3TOP", "U4NONE", "U5TOP", "U6NONE", "U7NONE", "U8NONE"))This works correctly in 8.4, but not after upgrading to 9.1

I'm looking for a way to report on our workflow profile set up - specifically want to be able to pull the workflow profile (the forms step added to the WF) and the associated "Workflow Name" (which is an awful name for this). Workflow Name refers to the tasks on the step:  The point is to make sure certain steps are all set up the same way with the same step tasks but I can't determine the best way to do this right now.  Looks like the WorkflowProfileAttributes table may possibly show me but I don't know where I can find a listing of what the AttributeIndex equates to on the actual WF set up (design doc shows zero results when searching either of those terms). Any direction or guidance would be very much appreciated!! 

Hello Team,I am currently writing a connector business rule that connects an EDM system to retrieve a file, apply mapping logic, and process the resulting DataTable into ACM. I have successfully implemented the same integration code for several other connectors, all of which are functioning as intended. However, when I attempt to apply the same logic for the Account connector, I encounter the following error:"Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index')"I have rewritten the rule twice but have not been able to resolve the issue.Do you have any insights into why this might be occurring?

When trying to connect to SAP from SIC, we are getting a tcp restart error   

HI,Modern browser could not be used.It has strange message "Skip to next section" for each dashboard component.

As the title suggests, I am trying to populate a dashboard list box that references the Workflow text property regardless of the dimension being used. I'm able to populate the list box using a single dimension, meaning a UD3 member is populated on the workflow's WFText4 property and a member list parameter uses |WFText4| to pull it in. How would I get this to work if the Workflow text value is not always UD3? For Example (both workflows will be using WFText4): Canada Workflow A needs a UD3 Member.Base to populate in the list box when they run the dashboard in their workflow but Canada Workflow B needs a UD6 Member.Base to populate the list box when they run the dashboard in their workflow. Please let me know if I can provide more context.

The title and image attached should provide enough context but please let me know if I can provide any additional information.

Hello,  When i am running Books from File Explorer -  Application Database, I am getting the below error, did any one come across this issue. requesting to help me how to handle this issue and get output.   

Hello, We are trying to automate a simple allocation of specific corporate expense accounts.  The accounts allocate to different business based on their contribution to total GP.  I currently have two calculations: Account Dynamic Calc - BU GP / Total GP, giving the business GP% UD8 Dynamic Calc - GP% * Corporate Expense Account, giving the expense to be allocated to each BU I run into an issue when data is pulled as either QTD or YTD.  As an example, if someone is to pull the data at 2025M3/QTD, it will calculate calculate a separate GP% for the QTD information and complete the calculation.  This creates a discrepancy when looking at data monthly vs. quarterly.  Instead, I would need it to add together months 1-3 for consistency.  (See below table for reference) Is there a way to make a dynamic calculation calculate only at the monthly level and instead aggregate months for other view selections (QTD/YTD)?       What is happenin

Hello,We want to spread data acrross multiple periods in a cube view, so we select the parent member (Year) and we expect that automatically OS applies spreading to all its base time members (months).However, we are working on a forecast scenario with the setting "Number of No Input Periods Per WF Unit" set to 4. And we don't understand how the spreading works.It seems the system calculates the difference between the amount entered at the parent member (Year) and the total amount of the closed months (the no input periods), and this calculated amount is the one that is saved at the parent member (Year), instead of the amount enetered initially.Could someone help us to clarify this calculation?Thanks!   

Hi Team, In our system Narrative Reporting setup has done, but when we open Narrative Reporting. could not able Fetch and Load and anything. seems like everything is empty(below screenshot are for your reference). Can you please help us to setup the Narrative Reporting in the system.    

Hello, I have a table view where I also allow users to save changes. In my code I'm checking for the cells that have changed using "If tvr.Item("Bonus").IsDirty()". This seems to work fine for non-numeric columns, however, I find that for the numeric columns the cells are always marked as dirty even if they are not changed. I tried different things, e.g. marking the column as decimal data type "tv.Columns(7).DataType = XFDataType.Decimal" but so far no luck. Do you have any advise how this can be solved? Thanks, Volker

Hello,We are facing the following issue, we use the following xfbr to generate accounts in a cubeview rows and retrieve descriptions : XFBR(CCF_XFBR, GetCCFDrillDownWithDescription2,memberExp=[A#CashFlow_Gestion.TreeDescendantsInclusive], Time=|CVTime|).However, the Cube View where this XFBR is applied always displays the descriptions in the default format. The description does not adapt based on the user’s culture settings.How can we make the XFBR return descriptions that vary according to the user culture?For reference, here is the XFBR code :Public Function GetCCFDrillDownWithDescription2(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DashboardStringFunctionArgs) As String Try 'Get the Dim PK for Entity Dimension Dim accountDimPk As DimPk = BRApi.Finance.Dim.GetDimPk(si,args.SubstVarSourceInfo.WFAccountDim) Dim flowDimPk As DimPk = BRApi.Finance.Dim.GetDimPk(si,args.SubstVarSourceInfo.WFFlowDim) 'Dim memberListClass As New O

Hello everyone,I recently attempted to register for a OneStream certification exam and noticed that both the Lead Architect and Core Application Architect certifications are available. Could you please clarify which one is required for my consulting firm to qualify for a higher-level partnership with OneStream?Additionally, I would appreciate any insights into the main differences between these two certifications, as well as the passing score (percentage of correct answers) for each.Finally, if you have already taken one of these exams, I would be grateful if you could share your experience.Thank you in advance!

We are preparing to move the Transaction Matching (TM) module, an out-of-the-box marketplace solution, from the Development environment to the QAT environment.Could someone please guide me on the process for migrating the database tables, along with the match sets and matching rules created within the TM module?Specifically, is there a way to extract and load these artifacts directly, rather than recreating the entire solution from scratch in the new environment?

Hello, I have an automated report book and would like to expand the functionality to include charts (in addition to the existing cubeviews).  I was able to add the chart, but I'm struggling with trying to control the formatting.  I would like to modify the header and have the chart fill the page (too much white space). See below. Thanks! Is there a way to format the chart output, in particular I would like to enlarge the chart image and have it stretched across the page?

HI Team, We have created a stored calc and it is working fine at Base and parent entity level, but when we are running at Top entity level and my Time is 2028, at this i am getting below error. could not able to figure it. Can you please help us resolve the issue.