OneStream Platform Forums

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,

Can we do input in multiple currency? How can we do input in other currency apart from Local? For example, if I have IN entity, I want to do input in SG, USD and other currency?

Hi, Is there any way to remove users from the groups by using Load/Extract option from the system tab. i know we can add new groups or users but i want to remove the existing user from existing groups via xml. Thank you in Advance, much appreciated for the help. Thanks Satish P 

I am trying to build a stacked bar chart with time on the x-axis. Time is being chosen via a parameter in the cubeview and then populating the 12 months prior to the time chosen as well as the time chosen. The time profile being used a custom profile with M1 being April. When I enable "Add Start End Calendar Time" in the data adapter and use "StartTime" as my argument, the data comes through for the right months, however the descriptions for time are that of a standard time profile (i.e. M1 is January) even though it is pulling April data. When I disable "Add Start End Calendar Time" in the data adapter and use "Time" as my argument, I get the correct time descriptions for the custom time profile, but they are out of order (displaying in alphabetical/numerical order).  Does anyone know a way around this? 

I'm building an integration that uses an OAuth 2.0 endpoint to return an access token for a 3rd-Party REST API service. I'm unlikely to be able to get a client-credentials grant for machine-to-machine RSET interactions (which would be ideal, so I have to proceed this way). It's Xero (don't ask....) The authentication endpoint uses a user/password followed by 2FA challenge in order to allow the API scope to be set, and an access token (and refresh token) to be returned to a redirect URL. I can do this easily in PostMan because PostMan - whilst not having a valid redirect URL - can intercept the request and extract the information in the URL/response Headers sufficiently for them to be used in subsequent API Requests. I'd rather not do this in PostMan going forward, and I'd like to handle the login/challenge in a Web Component in a Dashboard. I can get as far as opening the login Web Page, completing the 2FA challenge and then authorising the scope of source Entities, BUT when I hit OK t

Hello, I am looking to connect with any OneStream customers who are using OneStream as the source for their final trial balances. Currently we book a few top-sided entries in OneStream and then push them down to their appropriate ledgers the following month. This results in our trial balances coming from our ERPs to always be in balance. We are considering having our Shared Services Team take over some entries from our Controllers that would be top-sided in OneStream and we are considering not pushing them down to the ledgers. We are essentially looking at OneStream as being the source for our final trial balances. We currently use the Account Reconciliations Solution, so we would still reconcile the trial balance and all the tops-sided entries. Is anyone currently doing this? I've seen this done in HFM, curious if any OneStream customers are. Thanks! Regards, Ronnie Karpinski

I am wanting to use a custom Data Style that I have made in Excel, in a OS Quick View. I have followed the instructions found here  but it seems that the custom style does not populate as an option in the OneStream  Quick View settings. Is there something I have to do after creating it in excel, but before using it in OS? 

Hello,  I am using an excel Form Matrix template to load some data into OneStream. I am trying to add Annotations into this view but I am facing a issue.  Using the AN# in the matrix layout will automatically populate all the periods with the same comment. I would like to specify in the template for the annotation to go only to T#|WFYear|M12 for example.  Can anyone help me with this? Thank you

Hello everyone, While checking a DataRecord table in OneStream Application database, the following three columns exists:  UD34, UD56 and UD78. Does anybody know what is the utility of these columns? Is there any method to calculate the value that is added for each of these columns? Thank you in advance for your help. Regards,