OneStream Platform Forums

Hi, is there a way to set a parameter via task scheduler and pass it to the data management sequence and also its' steps? I've been able to pass a parameter to the sequence but I need it to reach the DM-step. (pictures to prove example)

Hello folks, Is there an explanation why SetDataCellsUsingMemberScript() writes to the cube only the last value from a list? If the list is formed by 10 records only the last one is written. It seems it keeps writing to the same intersection by continuously overwriting instead of adding.

Hi there, we are trying to figure out a way of collecting capex project information in OS inside a user friendly form (not capital planning register). Wonder if anyone else is doing it and how you are accomplishing this? Trying to figure out how to allow users to enter project number and name without creating metadata for each project in one of the dimensions ahead of time or if there is an easy way to accomplish this. The information we need to collect is really minimal, number, name, description, amount per year and a classification in one of three buckets.

Hi, I'm trying to execute DM Step using Rest API using below URL and Body Text but I'm getting an error with error code 400 and with the message unsupported API version. Can you please let me know what could ne the issue? Thanks for your help! URL: https://servername/onestreamapi/api/DataManagement/ExecuteStep?api-version=8.2.2 Body Text:; {"BaseWebServerUrl": [https://servername/onestreamweb],"ApplicationName":[Consol],"DataManagementGroupName": [DataCopy],"StepName": [Test_Copy],"CustomSubstVarsAsCommaSeparatedPairs": [""l} Error Message: Request Status: 400 Bad RequestResult: Non-200 response code received: 400 URI 'https://servername/onestreamapi/api/DataManagement/ExecuteStep' does not support the API version '8.2.2'.","code":"UnsupportedApiVersion","traceId":"00-a6552d7760a854272b00c71c0b9fc82f-b8030eb56b2b0a75-00"}  

Hello, Is there a way to allow a group of users to quick post journals under a certain threshold amount, but if higher than the threshold the journal needs approval? I used a rule previously that will reject the journal if the user attempts to quick post above a certain amount, but then I can't figure out how the next step would be for X group to go in and approve it for them?   Thanks!

When building a Data Source bound to a Connector business rule, if a need arises to use a Complex Expression, and that expression requires referencing several unbound fields, what is the proper statement to use to retrieve those field values in the expression? I had been told to use the args.Line.Split function. For example, if I needed the Entity field in the data set, and Entity was the 10th field in the list, the expression would be: Dim entity As String = args.Line.Split(",")(9)The "9" is used instead of "10" because the zero-base index.I'm finding this args.Line.Split statement does not work properly if the field value contains a comma. The field imports correctly into the data set, but the args.Line.Split statement cannot differentiate a comma delimiter from one embedded in the field value and it ends up returning the wrong field. Is there another statement that can be used in Connector based Data Sources to reference fields in complex expressions?  

Hi All: I have ran the workflow to copy the Actuals to Forecast and the data got copied over successfully. while validating the balance sheet for the certain IC plug accounts, Etiquity accounts the data is not matching Actuals versus Forecast. For example, the below.   I narrow down to the issue, I can see that the difference coming from historical override adjustment and beginning balance. I am not quite sure how to narrow down further to fix this issue, any leads/suggestion to check on this to fix?    

Hi All, Is there a way to prevent a user from selecting "Clear All Import/Forms Data from Cube" or clearing up the data?   Thanks    

Hi!    Ok here is my data:  Here is my data sources: Here is my application properties: If I have Global DataKey Scenario on for both Scenario and Time in Data Sources, why am I getting this error message: 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 When I try uploading? Does anyone know if I need a transformation rule and what that would be? Thank you!

Hi everyone, I have a question related to the upload of a new dimension hierarchy through an XML file. I currently have a file excel with the whole hierarchy for each dimension that I keep updating based on my client requests. I noticed that when I upload the file, the system merges the current version of the hierarchy with the previous one. This does not work for me because I would need the old hierarchy to be replaced by the new one.  A possible solution could be to manually delete the hierarchy members before the upload of the new hierarchy, but this would delete the data that has been loaded already. I would need a solution to just overwrite the current relationships between the members of the hierarchy without deleting them. Is there a way to do that? Thanks in advance!

Hi,   I have been trying (unsuccessfully) to configure my OneStream app against an azure AD. I have created an Azure AD and followed the steps that are in OS documentation. However when I try to login with my email which is configured against my Azure SSO I get a message "The external provider authentication provider settings in the XF Application Server Configuration file are invalid". My OS app is a local installation on my machine. Many thanks !

How do you add a data key to a OneStream application?

Hello, Here is an example of what we are trying. We have set the close dates and created a task in task manager which has a data management sequence as action and the start hour.  Does Task manager run the data management task as per the start hour given? The Auto execute option runs the task when the task is approved but we are trying to run the task at the scheduled time using task manager. Thanks in advance!  

Is there a way to get Workflow Status Method Query, I have requirement to modify the Profile Name in the output to include Description along with Profile Name.

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.  

Hi all We want to add more Cultures to the ENG-US one, but the option is greyed out. We are told to untick it, but this option does not exist or we are looking in the place? Please see attached.  Thank you.  Nouria

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. ?

I can use T#YearPrior1(|WFTime|) in my cube views and it yields the correct date. However, when I use this variable in my ConfirmationRuleArgs, I get an error noting: "Invalid calculation script. Unexpected text. |WFTime|)." Is there a way to have the confirmation rule pull December PY based on the workflow time the user is in?  Thanks for the help!

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  

Hi there,We are trying to test data provider endpoints using Postman but they always fail with Error: connect ETIMEDOUT xx.xxx.xxx.xxx:50001.I have read the documentation, manage to call Authentication API with Personal Access Token but no luck with other endpoints. OneStream support has enabled calls in IIS and has no clue what's wrong.For example:POST "https://{OurBaseWebServer}:50001/onestreamapi/api/DataProvider/ GetAdoDataSetForSqlCommand?api-version=5.2.0"Request Body: { "BaseWebServerUrl": "{OurBaseServerURL}/OneStreamWeb", "ApplicationName": "OneStream Test", "SqlQuery ": "SELECT * FROM Dim", "DbLocation": "Application", "ResultDataTableName": "ResultDataTableName", "XFExternalConnectionName": "", "CustomSubstVarsAsCommaSeparatedPairs": "" } Any idea?  

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 ?