OneStream Platform Forums

I have a dashboard report with text boxes that grow with the text.  Is there a way to prevent the box from breaking on a page break?  I know how to do this in Word, but cannot find a setting for it here.  See screenshot for example.  Apologies, I had to blur the actual text.  

Hey I a running a stored procedure on Oracle EBS in OS using SIC. Me as a admin can run the job succesfuly. However other than admin users cannot.  Smart Integration Connector remote query failed.ORA-03135: Connection lost contactORA-03135: Connection lost contactAn existing connection was forcibly closed by the remote host What could be the possible issues. I checked the BRs and DMs used for the same I can see the changes the access groups are set to Everyone.SIC log: [2024-07-03 06:08:38 ERR] RunDBCommand Exception invoking SQL: Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-03135: Connection lost contact ---> OracleInternal.Network.NetworkException (0x80004005): ORA-03135: Connection lost contact ---> System.Net.Sockets.SocketException (0x80004005): An existing connection was forcibly closed by the remote host    at OracleInternal.Network.ReaderStream.Read(OraBuf OB, Int32& InbandErr, String& InbandErrMsg)    at OracleInterna

Is it possible to load one file twice without creating two separate loads?We want to load one file but with separate columns used in each load. Load 1: Amount- column G, Source - column B, other columns the sameLoad 2: Amount- column H, Source - column C, other columns the same Would I have to import this file twice with 2 of everything...WP, Data sources, etc. ?

Good morning! Does anybody know how to fix these certification errors?  Thanks!

Hi Team, Can someone please help to guide how to read the view last source & log file using business rules and save it back onto File Explorer for a user to access it. Regards  Darpan Bhansali  

In a data connector rule, we need to run the api.Parser.ProcessDataTable funciton that can process a DataTable. However, using SIC funciton, we have to get data from the source into a XFDataTable: Dim xfDT As xfDataTable = Nothing . . . xfDT = New xfDataTable(si,objJobStatus.RemoteJobResult.ResultSet,Nothing,1000) The XFDataTable is created and we can see that it has rows in it. We convert the XFDataTable to a DataTable using: Dim dt As datatable = xfdt.ConvertToDataTable(si)  When we run the new DataTable thorugh the ProcessDataTable, we get an error: "Data load Ado.Net DataTable is invalid or null." When we try to count the rows on the DataTable, we get an error: "Object reference not set to an instance of an object" Is there any information out there about the differences between a DataTable and a xfDataTable? Is there another way to convert a xfDataTable to a DataTable that will no result in errors?  

Hi Everyone. What I want to do is to obtain the child entities of an element, to save them in a variable and compare them with the entities that are traversed in a data management, I would like to know how I can do this in addition to how I can get in a BR the value of an intersection, as if it were in excel. Example the childrens of this.  

I have attached the Parameter (Delimited) in the Cubeview. In parameter I have added a drop down what that drop will do it will add 2 flow dimensions members data which is huge. for 2 column data adding it will works fine but when I run it for whole entity.base or account.base, after few minutes OneStream forcibly stop process. how can I solve this problem ?

We would like to automate the load process but there are always a few validation errors.  Is there a way to get the data to load excluding the ones with errors and email a report of the validation errors.  We would be able to load the good data and work on the errors before the following day load.

When I try to upload my file it shows up like this, and this is the excel sheet I am trying to upload: any ideas? thank you!

hello team  i am new OneStream consultant  kindly need to know how to setup Midstream Metadata Manager on OneStream application   Regards 

Hello, Wondering if anyone knows how to set up dimensions in order to have the following requirement :  - Users with access to the cube Consolidation need access only to data from the dimension B - Users with access to the cube Accounting need access only to data from the dimension C - Users with access to the cube FP&A need both access to data from the dimensions B & C (dimension A) The following setup does not yet meet our needs :  Thanks for your help. Harry

Hello, I was wondering if there's a way to use one of the OneStream Excel functions (i.e. =xfgetmemberinfo) to grab data from a Cube View Connection? I know I could pull this data from the headers, but my work doesn't like using them really and was wondering if there was another way. Thanks, Will

I have SIC version 8.2.1 I already created the gateway and is online, is a Direct connect type configured to connect with SAP I already install the SAP dll in the SIC local When I try to compile my SIF in the Onestream App asks me for the Gateway, but I can't see my direct connect gateway, only shows the Database Gateway What I'm doing wrong?   Regards

I have couple of Connector DS and multiple Flat file DS in OS.Currently, the client wants to include Eurpoean culture for some of the users. I noticed that the dataload is behaving weirdly. The same data load now multiplies the data into 100 for a Eurpoean user/ what are the possible places where this should be fixed? Please note that I have multiple Parser,Conditional BR running on DS and TR as well.  

Hi, Does anyone know a report that shows all workflow profiles and who processed them? I know that for forms we can use adapter - FormsStatusForWorkflowUnit, but it's just a forms - I need all inputs. Many thanks!

I am using below sql to get validation messages from the workflow transformation process to be used in  Transformation Event Handler. But, I need to put the output of this dictionary into a flat file. How I can read the contents of this dictionary created. Thanks so much for your help! sqlValidation.Append("Select * ") sqlValidation.Append("From StageToFinanceValidationError ") sqlValidation.Append("Where StageToFinanceValidationError.WorkflowProfileKey = '" & wfPk.ProfileKey.ToString & "' ") sqlValidation.Append("And StageToFinanceValidationError.WorkflowTimeKey = '" & wfPk.TimeKey.ToString & "' ") sqlValidation.Append("And StageToFinanceValidationError.WorkflowScenarioKey = '" & wfPk.ScenarioKey.ToString & "' ")   Using dbConnApp As DBConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si) dtValidation = BRAPi.Database.ExecuteSqlUsingReader(dbConnApp, sqlValidation.ToString, False) Dim sb_ValErrorsReport As New Text.StringBuilder() For E

Hello - I'm looking for a formula to calculate data from one entity to another for two specific accounts. I would just use a standard data management job for this since the amounts are not changing, however I want the sign to change, so the amounts will net to zero when the entities are consolidated in the same structure. Can I use api.data.calculate for this? And if so, would the formula be stored on the two accounts? 

Hello everyone,  newbie here,  We about to embark on phase 2 of our implementation with the first task of creating drill back capabilities to our Oracle EBS 12.2 (on Prem) application.  I want to try to organize as much of this as possible up front since my IT resources are extremely busy at this point.  I have been searching for guidance on the best options for setting this up, but have run into so much disparate information.   Is there any one of you fellow Oracle EBS users who would mind jumping on a call with me to discuss some of my options?  1.  Where can I find Oracle SQL code examples to drill back to trial balance, journal and subledger information 2. Where could I find OneStream code snippets that could be incorporated into my application for this drillback data.  Any help would be greatly appreciated.

Hello All,We are having a requirement where we need to export Dynamic Calc members through FDX. We have few dynamic accounts which are complex and it refers to different time periods like (T#POVPrior, T#2023, T#2022). So whenever we run the export, it generates a very huge amount of error logs , 1 Million, referring to the T# Summary: Error processing script '((Divide(A#ABC:U8#Sample,A#DEF:U8#None))*100)'. Unable to execute formula for member 'ABC'. Invalid script 'A#DEF:I#Top:T#LastActualPeriod- A#IJK:V#YTD' near 'T#'Here LastActualPeriod will be calculated based on current actual period, Example T#2022M1Any idea why this happens and any alternate ideas to come out of this and export the Dyn Calc Accounts.Thanks in advance for your help !

Is there any way to perform bulk copy of a compressed data table to an Oracle Database using SIC.

Hello everyone, Im tryng to add a drillback option to my BR connector, but i have no idea how i can write it down on my script, any help or instructions from you guys is well apreciated!Here is my complete BR connector it pulls data from a biblent table: Imports System.Data Imports System.Data.Common Imports System.IO Imports System.Collections.Generic Imports System.Globalization Imports System.Linq Imports Microsoft.VisualBasic Imports System.Windows.Forms Imports OneStream.Shared.Common Imports OneStream.Shared.Wcf Imports OneStream.Shared.Engine Imports OneStream.Shared.Database Imports OneStream.Stage.Engine Imports OneStream.Stage.Database Imports OneStream.Finance.Engine Imports OneStream.Finance.Database Namespace OneStream.BusinessRule.Connector.Central_Connector_BiBlend Public Class MainClass Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Transformer, ByVal args As ConnectorArgs) As Object Try 'Get the query informat

I have a dashboard that has a button and multiple checkboxes attached. When clicking the button, I want it to verify if the user has checked any boxes, and if so, export data that corresponds to the checkboxes. If no checkbox is selected, upon clicking the button, I want the user to receive the following message: "No export option was selected. Please check the tables you want to extract and try again." The current behavior works for when a checkbox is selected. But if I uncheck all boxes and hit the button, it gives me the message, but also opens the file with the data that corresponds to the last checked boxes. The navigation action for the button is currently set to Open File. Any ideas on how to stop opening the file if no checkboxes are selected?  Thank you!

Note: this post is a follow-up from a post I made previously: https://community.onestreamsoftware.com/t5/Application-Build/Member-List-Business-Rule-in-Data-Access-Security/m-p/34916#M3533 Hi all,  Previously, I had asked about some details surrounding the running of a MemberList BR in a Data Access security filter; specifically, when the data access security runs (answer: every 24 hours unless IIS is reset) and if there's a way to force a re-run (answer: resetting IIS). After doing more work on this, we noticed that it looks like the data access security is applied on an app server-by-app server basis, and the app server that's used to handle the security is based on the app server that handles the user's log in. For example, if my log in action is handled by AppServer1, the data access security that's applied to my session is determined by the security that's currently applied in AppServer1. So it's therefore possible that one user, their logging-in being handled by AppServ

Hi, I'm trying to copy consolidated data from one Cube to another one. All the process works perfectly except for the consolidated data. C#Elimination is not being imported. The part of the connector rule where I think there is a problem is here, but I don't know how to solve it: Dim dtDataRecord As DataTable = BRApi.Import.Data.FdxExecuteDataUnit(si, myCube, "E#E004", "C#Local:P#PL00", ScenarioTypeId.Actual, "S#ACT", "T#"& wfTime, "YTD", True, filterF, _ 4, False) Thanks,