Workflow and Data Integration

Hello, How can I seamlessly integrate SAP with Onestream in such a way that I can pull specific data for specific intersection? For example, let's say I want to only pull data from SAP that has entity as ABC and account as 123. How can I do that? It should be completely user driven and minimal intervention from administrator. Thanks

Hi Everyone, These tables house information about the Environment tables, and also the Application Tables.  It would be ideal to have not only know information on the fileds in these 2 tables mainly are the fields in GB or Tera Byte, but also the best place for information about the tables that come with OneStream. Thanks in advance of your help

Originally posted by Vignesh MohanHi, I am trying to import data from Snowflake using JDBC / ODBC connection. In the Snowflake side a view has been created with the correct data set for the import. The connectivity as such works as I tested the same through the Data Adapter in the Dashboards. I am able to retrieve data for the same query that I am using in the connector rule using this test method. The data structure type in the data source section in OneStream is setup as Matrix data as I need some of the column names to be mapped to the Accounts dimension members. When I run the data import from the workflow, I get the following error, 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. All dimensions are mapped appropriately in the transformation rules. I am also using few attributes to import

Hello, OneStream Community We currently have OneStream set up to load data files automatically over the filesahre API, notifying users via email when something goes wrong or succeeds. In addition, I would want to compute the validation errors from OneStream and email them to the users about the invalid intersections. Could someone please tell me how to go about doing that? Regards

What is the difference between WorkflowUnitClusterPk vs WorkflowUnitPk? When would you use one over the other?   Thanks, Scott

https://community.onestreamsoftware.com/t5/OneStream-Tech-Talks-Continue/New-Episode-of-Tech-Talks-Available-Now/td-p/33894 G'day, In this Tech Talks for Data Movement, Nick Bolinger suggested to use DMES as a better way than a DM Copy Job to copy data between S#s. We Imorted Actuals for '21-'23 via a Yearly Matrix and S# to then use a DM Copy Job to copy the Base data to a new Monthly S#Act: '21-'23 + '24.Pls share your DMES expertise to help us better copy Base data from historical Yearly S#Act's T# ('21-'23) to those T# of a live Monthly S#Act ('21-'23 + '24). TY.

Does anyone have information on how to restrict (No access) on scenario  Member, The app has the entity security setup. i tried with Data cell access Security "on the cube data access" not able to figure out. if any one gone through this scenario please help. Thanks PK  

Hi All, We have a client who is concerned about users being able to delete and reload journal entry attachments. From what I can see there is no audit record of this, the items show up in the ‘Attachment’ table when posted but once deleted there is no record of this being deleted. From what I can tell there isn’t a separate audit table associated with this. Does anyone know if there is way to prevent users from being able to delete an attachment or a way to provide an audit of items that were changed? I also was trying to find where attachments for Journals get stored to see if changing security on a folder was possible (maybe the only record is the table itself and this isn’t an option). Another idea was an event handler but it doesn’t seem like deleting an attachment is considered an event. Any thoughts or suggestions would be appreciated!

What are the different options available to integrate SAP RISE (SAP Cloud) to OneStream? Is there any adapter available? have anyone implemented this integration?

Hi i now have access to Onestream Navigator and would like some recommendations of which courses to complete to get an understanding of how to extract data out of Onestream  Does anybody have any courses that were done that would be of help

How to convert a MT940 bank file to CSV readable format for data load

Hi all,Is it somehow possible to customize the answers to the certification questions? We would generally only want yes/no, but by default there is now a whole list of possible answers. We are looking for a way to limit this list.With kind regards,Tim

Hello OneStream Community, We are currently in the process of establishing integration between AWS RedShift and OneStream. Our objective is to obtain data from SQL tables available in RedShift and load it into OneStream cubes. While exploring the best approach for this integration, it seems that pulling data from external data sources such as RedShift into OneStream is the most efficient method. Could anyone with experience in this area kindly share their insights and any best practices they might have? Specifically, I am interested in learning about state-of-the-art approaches for directly connecting to external cloud databases. Additionally, I would like to understand whether this integration requires the usage of S3 buckets and generated files or is it possible to work on direct connection. Your expertise and tips would be greatly appreciated. Thank you in advance for your assistance. Best Regards, Dawid

Has anyone used GetDirectLoadIntersectionErrors()?  I am making a huge assumption that the purpose of that function is to get the list of Intersection Validation Errors during a Direct Connect load?  I have a solution from one of the other posts to query the application database, but I see this function is available. So, I wanted to see if I could get it to work. I have tried: Dim intersectionErrors As DataTable intersectionErrors = BRApi.Import.Data.GetDirectLoadIntersectionErrors(si, wfClusterPk) I use the same wfClusterPk to run the import, validate transformations and validate intersections API calls.   When I try to use this code, I get: "Object reference not set to an instance of an object." Has anyone used this?  I am in Version 8.1.0 if that matters. Thank you, Scott      

Hello Everyone, Has anyone done an extract for BAPI "BAPI_AP_ACC_OPENITEMS" using RFC connection from SAP. I have below code, any suggestions here. What will be the Imports if we have to extract 7-10 columns in the extract ? Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Transformer, ByVal args As ConnectorArgs) As ObjectDim r3Conn As R3ConnectionTry'Create and open the R3 Connectionr3Conn = Me.GetConnection(si, globals, api)r3Conn.Open() Dim r3Func As RFCFunction = r3Conn.CreateFunction("BAPI_AP_ACC_GETOPENITEMS") r3Func.Exports("CompanyCode").ParamValue = "1000" r3Func.Execute()Return r3Func.Imports("").ToTable() ' End SelectCatch ex As ExceptionThrow ErrorHandler.LogWrite(si, New XFException(si, ex))FinallyIf Not r3Conn Is Nothing Then r3Conn.CloseEnd TryEnd Function  

(this is in a clone/test app) I need to perform forecast for 2025.  Our global POV (time) is set to 2024M3.  In the adaptor used to pull in my volumes it uses the GetAdoDataSetForAdaptor to pull in the data, but even with my WF POV set to 2025, it still pulls 2024M4-2024M12.  I'm guessing (obviously?) it uses the global year & not the WF POV to pull the data requested.  Is there a way to override this, or some other way to load my volumes in an out year

Hi all, how do you run an aggregation, i.e. calculate the "Aggregated" member of the consolidation dimension, without running a consolidation? In particular, would it be possible to setup the Process step of a workflow profile so that it runs an aggregation (as opposed to a consolidation/force consolidation)? Thank you

Hello, Does anyone maybe know if it is possible to create an endpoint in OneStream that will consume data pushed out to OneStream from SAP? In this case, SAP or another external solution would be the initiator of the connection. OneStream can consume the data it receives.

Hi All,I'm uploading a KPI file in our Workflow. However I keep getting this error? What could I be doing wrong?Summary: File does not contain any valid XF range tokens, Token xfd. 

I have a OS Batch File Load Setup which loads Multi Year and Multi Period Data(3 Years).I have an Extender Business Rule that creates the Batch File one period at a time and calls BRAPi.Utilities.ExecuteFileHarvestBatch to execute the data load one period at a time. Data Source is a connector.The issue I have is every time when I run the batch one of the WF steps (Validate Transformation, Validate Intersection or Load Cube) freezes and make no progress after executing roughly 10-12 periods. It doesn't make progress even after an hour wait. I will have to cancel the running task and batch and then restart the data management job with the next period forward. Again, it runs fine for 10-12 periods and freezes again.Appreciate any recommendations/suggestions to try resolve this issue. I am not sure if this related to any OS configuration that allows data loads for long time.     

Hello everyone, when data imported, the amount are displayed with only two figures after coma 0.00 i would like to display an amount format 0.00000 how can i do it in the datasource? Thank you for your help!

I have an IsOptional=True direct connect Import/Validate/Load Workflow channel.  I would like to be able to Complete this Workflow channel via the OS api without having to import/validate/load anything, the same as if someone selected the 'Complete Workflow' button just to the right of the 'Clear' button in OnePlace.  Actually, I have a number of such workflows, some are only required for M12 and others are placeholders for data that is being copied directly into the cube from other non-linked cubes. I can complete/revert the Workflow channel if it is set to Workspace using BRApi.Workflow.Status.SetWorkflowStatus().  And I can revert Import/Validate/Load workflows with the SetWorkflowStatus() too, but I do not appear to be able to complete the WF unless I'm at the last step or advance the steps with SetWorkflowStatus(). The BRApi.Import.Process.* functions will advance me through the Import/Validate/Load steps, but I cannot see how to do so without the functions imp

Hello Everyone, I'm trying to build an advanced transformation rule based on a member present in my dimension. For example, I want to bypass all lines that contain a member not existing in my UD3 dimension. Currently, I use a one-to-one mapping for my UD3 members and I add a mask to bypass the rest with: * -> (Bypass). However, this method doesn't handle cases where new members are added to my UD3 dimension. Each time this happens, I have to update my one-to-one mapping. How can I dynamically implement this using a complex rule or a business rule? Thank you for your help. Yahya

I am trying to retrieve Workflow Channel Information for a specific Workflow Profile in a Business Rule. I am able to fetch it using SQL using the Attribute Index value. Just checking if there is any in-built function to fetch it.

Hello, Is there a way to have some sort of business rule I can create for when a user answers a questionnaire (set up as Non-Financial stat account), that only based off their answers (Yes or No) specific forms come up in their WF profile? We're doing some auditing form creation and we're trying not needing to make different form template profiles/groups?. Thanks, Will