OneStream Platform Forums

I am updating a customization to the Account Reconciliations solution to version 8.4 and have converted my custom business rules into a workspace assembly/assembly files.I added a custom maintenance unit to the OneStream Financial Close workspace to build said assembly and I am now having issues calling my assembly, specifically, the workspace assembly service factory file I created is not getting recognized.I found an instance of a button in the Reconciliation Manager MU where a button component calls upon the Integration assembly in the Integration MU using the following syntax:{Workspace.Current.Integration.WSMU}{OnOpenDetailItemTransactionDrillbackClick}{ItemID=[|!SelectedReconItemID_RCM!|]}I also have my Workspace Assembly Service that I created set on my custom maintenance unit:So after adding my own custom button (to appear on the Account Recs UI) in the Reconciliation Manager MU, I followed the same logic for executing the call, below is an example:{Workspace.Current.MyAss

Was able to "Process Cube" for October and November... in attempting to close a form for December (1Q) - now receiving this error message. The Entity Assignments and Calculation Definitions on the Workflow Profile are the same as they've ever been. Can somebody share other possibilities based on what this code is telling me? Cannot execute the Process Cube (Calculation) workflow task because the current workflow profile [Investment_Sub] has not been assigned a calculation definition.User Interface Stack Trace:   at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs)   at System.Se

Is it normal for certain security settings to be "reset" when a copy of production is made to dev? Every time we make a copy of production into the development environment certain security fields within Security Roles, Entity dimension, Scenario dimension, Workflow Profiles and Data Management Groups are set to "(Not Found)" instead of the correct security group.  Is this normal? If so, what's the easiest way to update this? Thanks!

Hi all,I'm quite new in OS and, as a Dev, I'm writing some code in Assemblies/Business Rules.I'm experiencing an issue with Intellisense.While I'm working from inside a class, I can see all the hints supplied by intellisense for all the Standard/OS Classes/Methods and for the Methods inside my current class.Unfortunately I cannot see hints for my other custom classes/methods that I wrote under the same assembly/namespace (they are correctly referenced, the assembly is compiled)I tried adding triple-slash comments, but - again - no luck.Just wondering if there's something I should do to make intellisense works or if I stumbled in a platform's limit.Thanks in Advance for Your precious helpFabioG 

We are working on a POC to extract data using FdxExecuteDataUnit.  We are using an Extensibility business rule and running it using a DM job.  I am getting assistance from our corporate IT group as I am not good with C#.  The business rule is writing data to a table and then is taking the data from the table and putting it in a text file.  There is something missing or wrong with this and I am hoping someone can help with the code since I do not have access to the TechTalks that focus on FdxExecute. The code was written to do the FdxExecuteDataUnit and then also write some sample data to the table.  This way if the FdxExecute does not generate any data we at least get a file with the sample data.  I am getting a file but it only has the sample data spelled out in lines 100-150 of the business rule.  I am also getting the following warning when I compile the rule:  "1) Warning at line 54:  Unreachable code detected" If I comment out that line

OneStream Support team has submitted a Bug PF-33928 to Development team to Fix the XFGetCell Issue. Issue:XFGetCell formula shows zero (instead of blank) despite setting DisplayNoDataAsZero parameter to FALSE

Hello OneStream Community, Currently working on setting up an automated process to handle BAI file uploads directly into each specific bank workflow in our OneStream application.  1. BAI Parser & Data Source Configuration - We've installed the BAI Parser dashboard to view and manage all imported BAI files. The BAI data source has been configured and initial tests with sample files have been successful. 2. File Transfer & Business Rules - Plan is to automate the transfer of finalized BAI files from our system via FTP to the OneStream file system. This requires a BR to connect with the FTP site and currently developing a BR to facilitate this connection. Once the files are in OS, they'll be imported into the appropriate bank workflow. 3. SFTP Wrapper and Workflow Integration - After the initial FTP transfer, a separate BR will be implemented to securely retrieve and upload the BAI file into the bank workflows. Question: For those who have set up similar BAI automat

I've tried to implement this function as per the Business Rules Editor snippet: Dim objByte() As Byte() = BRApi.CubeViews.Process.ExportCubeViewGridsToExcelFile(si, custSubstVarsForAllCubeViews, cubeViewNamesAndVars) However, I've had a few problems with this, the main one being that I've been unable to save whatever it returns to an Excel file. Here's what I've tried: Dim fileName As String = "test.xlsx" Dim filePath As String = $"Documents/Users/{StringHelper.RemoveSystemCharacters(si.UserName,False,False)}" Dim XFfileDataInfo As New XFFileInfo(FileSystemLocation.ApplicationDatabase,fileName,filePath) Dim XFfileData As New XFFile(XFfileDataInfo, String.Empty, objByte) BRApi.FileSystem.InsertOrUpdateFile(si, XFfileData) Whenever I run this code the output file is an XML. How do I save this to a .xlsx file?

Hi Team, Could someone assist me with transitioning WinSCP operations to SSH.Net? Also, is this a good move to make? Thanks, Anitha  

XFGetCell formula shows zero (instead of blank) for despite setting DisplayNoDataAsZero parameter to FALSE

Hi all, I thought this was easy but not sure what I am missing. I have a current data management job that is running off this parameter and works just fine.  Scenario=[Actual], Time=[|GlobalTime|]. I have tried [|GlobalPrior1|] with no luck I am trying to get the prior month so I have tried Scenario=[Actual], Time=[|GlobalTimePrior1|] but that is an invalid sub variable, is there another syntax to use on this? I know you can with t# in cube views but this is the DM job. Thanks in advance!

Hi All - I have a scenario where I need to copy the data from Parent Entity to the Base Entity with ICP.  ThanksKrishna

Hello All, SetDataCellsUsingMemberScript() seems to only write the last value added to list.  I am successfully adding 14 records to the objMemberScriptValues list (I can loop through them and see the 14 unique intersections) but only the last one is being updated in the cube. I'm looping through the records in a datatable and then each intersection is added to the list: '*********************************************** For Each row As DataRow In dt.Rows   strProfileName = row.Item("ProfileName").ToString strCube = row.Item("Cube").ToString strEtT = row.Item("EtT").ToString strCnT = row.Item("CnT").ToString strSnT = row.Item("SnT").ToString strTmT = row.Item("TmT").ToString strVwT = row.Item("VwT").ToString strAcT = row.Item("AcT").ToString strFwT = row.Item("FwT").ToString strOgT = "Forms" strIcT = row.Item("IcT").ToString strU1T = row.Item("U1T").ToString strU2T = row.Item("U2T").ToString strU3T = row.Item("U3T").ToString strU4T = row.Item("U4T").ToString strU5T = row.Item("

Hi everyone,In my environment, I had some calculated data in 2023Q4. 2023Q4 was completely locked and certified.After that, I loaded a zipfile, containing XMLs consisting of Cube Views, Data Management Steps, Extensibility Rules, Metadata and some dashboards. I uploaded this to update an existing partnerplace solution running in my application.After loading the zip file, the calculated data from 2023Q4 was gone. After recalculating, the data was back, so no issue. However, I'm very confused on how the load of a zip file containing XMLs could have affected calculated data in a locked period. Thanks for any help or information.Kind regards,Floris

Hi, I have a SQL table with a decimal column that allows nulls, and I want to differentiate between an actual 0 and a null value.I seem unable to configure the SQL Table Editor in a way that enables me to save a null value. When I press Insert new row, it defaults to an amount of 0.0, instead of null. I am aware that I can do a dashboard extender and override the save operation but in this case the column value could be either 0 or null and I wouldn't know how to differentiate between the two. Any ideas? 

Hi everyone, I have to do some systems diagnostics but I cannot run the dashboard because there is an error in the business rule "OSD_SolutionHelper". This business rule does not compile due to an error in line 4882Dim computer As New Microsoft.VisualBasic.Devices.Computer()Error: Type 'Microsoft.VisualBasic.Devices.Computer' is not defined. Anyone else encountering this issue? We are on version 8.4.0.16413. RegardsMartin  

Data Mgmt sequence and steps work great when utilizing a 'manual' initiation of this process and business rule. However, the DM process automatically initiates twice daily at specific times using the same code and rules. When this occurs, it fails on occasion (not always), and this error message is received: Summary: Error processing Data Management Step 'ProcessRecons_RCM'. Unable to execute Business Rule 'RCM_DataMgmtProcess'. One or more errors occurred. () Concurrency violation: the UpdateCommand affected 0 of the expected 1 records. This is the business rule in use... asking if anyone can spot an obvious issue I have overlooked or might know the cause of the failed task on occasion. Business Rule: 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.ExecuteDataMgmtBusinessRuleStep 'Prepare Parameters Dim wfProfile As String = args.Na

Hi,We successfully imported data from stage to cube. But while creating cube views, I am getting fewer records. Not all data is showing up in cube view. I checked the tables in the database; they have all the lines, but the cube view is importing only the first line. What can I do to get all the lines calculated in Cubeview?This account has 1343 records but cubeView fetches only 1st line.

When I use a formula to set-up the time member, the XFGETCELL formula that refers to this time member is stuck in #REFRESH. The weird thing is, if I go in the XFGETCELL formula and hit enter without changing anything, when I refresh the sheet it works and gets a value, but next time I close excel, re-open, re-connect and refresh it's stuck once again in #REFRESH. If I hardcode the time I don't have this issue, or if I concatenate to a hardcoded number, it also works. As an example I have a list of 12 rows with numbers across 30 or so columns and a total at the end. The rows represents each month, so to get the last current month with numbers I use a formula (example countif) on the total column and then concatenate this to the year, so if I have data until October, I would get 10, so the formula returns 2021M10 for the current year and 2020M10 for the prior year. Is this an issue with the add-in itself where it is confused on the order the excel formulas are being calculated?

Have a question regarding- " if two import workflow profiles are not siblings of the same input parent, but load to the same entity, scenario and time dimensions, the data loads and clears at the account level. " If the two import profiles are not sibling to the same input parent (like it is not sibling 1 and sibling 2) , how can we load to the same entity? Since, entity assignment is done at a parent input profile level, If 1 entity is assigned to parent 1 input profile, we cannot assign the same entity to parent profile 2  

Hi All, Is there a maximum with regard to the datasources used in the BI viewer. I am not able to add more then 3 datasources? I currently use 3 cubeview MD    

  Hi, All -  I’ve developed a dashboard that includes a text box, parameter components, and other elements. Users can input a date and click a trigger button to fetch the data, using inbound parameters in the data adapter. The dashboard is supposed to default to a date value upon loading, but it’s not pulling the expected default from the parameter. Ideally, the dashboard should open without any issues, but instead, it’s throwing the following SQL error: "Conversion failed when converting date and/or time from character string. (SQL Error Number -2146232060, 241)" Currently, the dashboard is not opening and displays the error above. The data adapter field value format for date is as shown below. I’ve tried various options for setting the default value in the dashboard parameter, but the issue persists.  Please let me know if you have any suggestions. thank you !        

Hi all,just finished to see the "Mining for Gold: SQL Parametrization", very informative episode. At the end, Chris Loran explained how to leverage on caching system offered by "globals", to avoid multiple executions of the same query against the DB. I do have a couple of questions about globals, to better understand how they work:Is globals object exclusively dedicated to caching data ? (AFAIK: Yes, it is)I haven't found a "duration" of the stored key: it's me or it doesn't exists ? I mean, once I put something in the globals, when it will be invalidated ? (AFAIK: No timed duration of the cached value)Deleting keys: looks like I can only delete ALL keys, not specific keys. Am I right ? (AFAIK: I am right)I already added answers to my questions, thanks in advance for those who will confirm (or not) them.FabioG

Hello, We are looking to export data from OneStream to Snowflake using APIs. We are using OneStream's cloud hosted environment, and the authentication method is just a Reference Token. We are looking for more secured way for sending the data from OneStream to Snowflake. Let us know if there are any suggestions or alternatives for this data integration with more secured way of authentication. Thanks, Tharun.

Hi,  I am just wondering, is this a limitation of OneStream? Does the column member filter support only two levels? Are we unable to add additional levels beyond this? Thank you to those who will share their inputs.