Workflow and Data Integration

Hi,We would like to export the TRX files and use them in an external BI setup and secondly we would like to shedule that export and have it happen on a regular basisThe format is just nicer to work with than the XML files, when you use the aplication export functionality.KrPer  

Hello, We are working to identify what Cube Views are used within the workflow structure.  For steps that include views of Forms, this is easy as the Form Audit tab shows exactly what Cube View is being used on the form.  For dashboards, we are having difficulty identifying which Cube Views are embedded within each dashboard easily.  We are aware of the "Show Objects That Reference the Selected Item" button within Cube Views, however it doesn't seem to show us clearly if a Cube View is included in a dashboard. Does anyone know an easier method to identify what Cube Views are included in each workflow step and dashboard? Thanks for the help!

Would anyone be willing to share how they are locking data to end users, but still allowing consolidation users to make adjustments?When implementing OneStream, we created workflows for users to load trial balance data, complete forms and load journals. We also created a “Corporate_Consol” workflow where we the Consolidation users could load journals after the workflows were locked. We figured out that if the top month for the workflow was not locked, but the workflow channels under were locked, users could still submit data in OneStream using Excel forms. Now we are locking the months under each workflow to avoid user changes. This makes it hard when we have post close adjustments to book in the “Corporate_Consol” workflow, as we have to unlock each of the workflow months where there is an adjustment needed for an entity in the workflow.Thank you for any help/input!

Is it possible to update the Data Filters for a particular dimension used in a DM extract within a Business Rule? I am creating a dashboard that will have a button to run a DM sequence. This DM sequence runs a data export, but I would like to be able to update the Accounts used in the filter of the extract before running the extract itself (via a BR).

Workflows can be set up to be locked automatically after the certification step has been completed.. Question Credit: Noemi Nagy Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hi! New to the community. I have a user that has to manage 10 or so entities and it rollforwards. He need to click on each entity to enter in the data. do you know if there is way to set up an excel import for a rollforward activity where i can put the rollfoward activity pieces down a column the entities across the top and then import that entire spreadsheet?

Hey everyone. We are implementing a use case for a client that requires import of transactional data found within a csv file. The data is comma delimited, and enclosed in quotes. For example, if the data source contained only three fields, this is what it would look like:"Field 1 value","Field 2 value","Field 3 value"The problem that I'm having is that sometimes, Field 2 also contains a quote in it. For example, the client sells parts, and Field 2 contains a description of the part. The description happens to contain a quote (for example, 2" pipe). The data extract routine the client uses automatically includes a second quote to cancel out the first. So the value of Field 2 in this example would be: 2"" pipe. The file, if opened in notepad, would look like this:"Field 1 value","2"" pipe","Field 3 value"I've not figured out a way for OneStream to correctly handle this. The only solution that seems to work is pre-processing the file to strip out instances of two double quotes that aren't

Hello-We created a connection to an external database and I can see it just fine in our Dev application. under Data Source > External Database Connection in Dashboard Data Adapters. The issue we are having is, we are not able to write and execute a query against this External Database. Instead, we are only able to execute a stored procedure but the SQL Query field will not allow us to do something like:execute dbo.usp_GLReportHas anyone run into a similar issue? Any ideas are greatly appreciated.

Hello team,I need to know how we define the unassigned parent entities in the entity assignment for a WF ? Is it through a profile property or through an entity member property in the entity dimension ? i am not able to find some entities in some WF and it appears in others. Also , is it possible to call a function Entity base or hierarchy instead of calling entity by entity in the entity assignment tab ?Thanks 

Hello! I'm trying to set up a few workflows that individually kick off an SFTP load,  but only for that given workflow. I created a dashboard button that the user clicks on to run the SFTP data  management job, but it currently loads the fiels for all workflows set up for SFTP. I'm tyring to find a business rule line that doesn't sue the batch file load. Are there any examples of only loading a file based on the workflow selected?   Thank you!

Hi Team, Can Tableau Connects to One Stream ( on Azure Cloud ) ? Best Regards and Thanks Darpan Bhansali

Hi !We are trying to figure out ways to automatically upload data using either Business Rules / Data Management / Task Scheduling. Is there a way to automatically upload data from flat files or databases using these three components ?Data Management seems to provide only Export functionalities. Regards,

We have successfully set up and use workflow channels (tagged to accounts and workflow profile steps) in our divisional (Base Input) workflow profiles in our application build.  The steps and data lock based on their workflow channels appropriately.  However, we are having trouble getting Workflow Channels to work properly when it comes to the workflow profile (Parent Input) used by central finance.  The central finance team needs the ability to book historical USD overrides on select equity accounts on behalf of the divisions for all non-USD base entities in the OneStream application.  We are not using and have not configured the use of any UD dimension in our Workflow channels to this point.As of right now, we have assigned the central finance team their own Input Form profile step so they can submit these Overrides to the configured accounts (using Flow dimension).  We have given that profile a unique Workflow Channel and assigned the accounts specified in t

Hi all,I have a matrix load, on which account is matrix. One column with a specific account needs to go to 2 different accounts. For this I just reference the same column twice. This works fine.The issue is, the first instance the UD5 is coming from column 5, the second instance UD5 should come from column 16. How could I achieve this?Thanks!Tim

Does anyone know if OneStream is capable of exporting into AWS S3 bucket?Thanks.

Hi.  Is it possible to set Certification Profiles so they only show on a Quarterly basis?  The questions can be set to quarterly but the Profiles still exist in the off-quarter months and require a Certification sign off even though there is nothing to certify.  I have a client who needs an employee to certify a question on a quarterly basis and this employee does not have any other certification or workflow responsibilities.  

Originally posted by Francisco AmoresHi,   We have Rule1 and Rule2 in a transformation table. rule 1 executes first and we have assigned a complex expression with a conditional rule. We want onestream to apply rule2 if that condition is not met. However, it seems that you always must return something.   How do we deal with this?   Thanks

Does anyone know how to translate the value in m1status .. m12status in table DataRecordxxxx. Is there a second table I can referece? 

Hi everyone!I am Angel and I am new to OneStream implementation and currently facing an issue. I am trying to update the Cube Name in my Workflow Profile, but it returned an error message.This workflow profile is under Cube A which has been set as the 'Top-Level Cube for Workflow'. Under Cube A, we have several Sub-Cubes (Cube A1, A2, etc.) which have been set in the Cube References. I am trying to update the 'Cube Name' in my Workflow Profile from 'Cube A' to 'Cube A1' because we would like to load the data into that sub-cube (Cube A1), but it gave me the error message below (screenshots below). Could you please tell what the error message is about and what I can do/check to fix it? Any answer would be so much appreciated, thank you!!  Cheers,Angel

Good EveningWe are working on an OneStream implementation and one of our sources of data is OpenAir. This solution is cloud-based. We are trying to extract data via a ODATA call.Does anybody have any code examples on how to use ODATA as a data source?Thanks in advance.Marco A. Rossodivita

I have a single Connector BR that makes several independent API calls to external systems. When it's called the Task Progress window sits at 11% with the message "Parsing Source Data". I would like to update the task as it goes along so the user knows something is happening.  I found reference to the below snippet but don't know how to properly instantiate the extenderArgs variable. I tried using it with Nothing but it did not seem to work as intended. Is there a sample of how I can do this in a Connector BR? Dim bValue As Boolean = BRApi.TaskActivity.UpdateRunningTaskActivityAndCheckIfCanceled(si, extenderArgs, activityDescription, percentCompleteToAdd)  Thanks.

Hello all, is there a way to export a file to a users local folder (Outside of OS share)? For example the exports drom Data Management or anything that we created in a BR?   I know how to send it to a table/DB, but the question is if i can export directly from OS to a local folder. Am I missing something very obvious?   Thank you in advance

Hi allis there a way to disable the "Create Journal" button  (red)and keep the ""Create Journal using selected template" button (green) I would like to force users to select specific templates where the entity selection is limited to the E#Root.WFProfileEntities So that users cannot make mistakes posting a journal on an entity which is not part of the workflow. Thanks in advance for the help.Marcello  

Hi I am tried to configure a hard error on quarters and warning on off months for IC balances above thresholds.   The error I can use frequency Quarterly but for the warning I want it to run 1,2,4,5 etc.  I tried #TWFYearM1 or just 1 or just M1 but none of them worked.  Help?  Also checked the documentation says nothing about format and there are no examples in Golfstream.

You will get this error during the import step. Reason - The load file doesnt have any data after transformation.( ByPass).  The underlying code looks to summarize the data when it finds nothing, it throws an error.