Workflow and Data Integration

Hello Integration Experts,I would like to know what are the alternatives we have to Integrate Netsuite with OneStream and which is best among RESTAPI and ODBC. Thanks

Is there a way to load to multiple scenarios from one Workflow? Example, from the below Workflow POV, I want to load to the Actual_PP scenario, but also to the Forecast_PP scenario. I don't want to create a new workflow for forecast because I want to use the values from People Planning that have been calculated for Actual_PP to populate both scenarios.  I don't what to load the People Planning register twice and calculate it twice.

Hi All,I am trying to create simple Extender rule to export only the AverateRate FX rates.  I saw this post: What is the most efficient method for exporting FX rates to a CSV file in OneStream? | OneStream Community  But this does them all.  Short of exporting to this file and creating another file from that one.  Does anyone know how I can filter the export to just get the Average Rates?I see the variable xmlOptions.ExtractAllItems = True.  But if I set it to False, I don't see what options I have to filter to specific metadata. I'm open to exploring other options as well.Thanks,Scott 

Hi,I am trying to load data from BiBlend to cube using a import validate load steps on my workflow and using also a connector, but i truggle a bit onthe connector Businessrule, i would like to know how the BR can connect to my biblend table.I have already done a br connector cube to cube, but never a biblend to cube.if you have any example of the script that i can add to my BR in order to connect the BiBlend Data table it would help a lot.Thanks, 

Hi,I have an admin dashboard where I show all parameter values and information I need before I start my Data mgmt jobs. There is one value I dont figure out how to show in my dashboard. I have a Conditional input rule on the Cube. Can I create a parameter or Data Adapter or something to be able to pull the value and show in my dashboard? I only need to retrieve the Scenario value.  

Hi all,I have connector rule set up to an external source table that is working fine to pull data into stage, but I would like to automate the execution of the workflow as well so that the data in the cube is refreshed nightly.  I found the below api but it looks to me like it's meant to load a flat file into stage via an extensibility rule, not from an external table. I'm not sure how to connect it to the connector/import step I want to automate. Any thoughts? Dim WFTime As String = TimeDimHelper.GetNameFromId(api.WorkflowUnitPk.TimeKey)Dim results As WorkflowBatchFileCollection = BRApi.Utilities.ExecuteFileHarvestBatch(si, "Actual", WFTime, True, True, True, True, False, False, False)

Dear community,My company has just switched over to v8 and we are in the works of switching over from a current rest API to the Power BI connector.Is there any guide or thread that goes through how to set the prompts for the connector? I get a little bit confused as to what needs to be filled in. For example, the prompt asks me to fill in "Entity" and many other dimension parameters - however, our business consists of many, many entities and I would not like to create one data connection for each one of them. Same goes for "Account" and many other fields, none of which I am able to leave blank.Any advice? Rasmus 

Hi,I've got a business rule where I use BRApi.Workflow.Metadata.GetParent(si, si.WorkflowClusterPk) to look at the status of the parent workflow profile. However, if a user does not have access to the parent workflow profile, then they get an error "Security Access Error. User is not authorized to access workflow profile". So it seems that the function BRApi.Workflow.Metadata.GetParent(si, si.WorkflowClusterPk) is not very useful and it is a bit bizarre that it refers to user security. Is there a way to run this business rule as administrator perhaps or something else I can do?

I recently discovered that data from deleted Scenarios is not removed from many of the application data tables (XFW_PLP_Plan, XFW_PLP_Register, ...)   Does anyone know why it remains and is it safe to remove as the scenario no longer exists.   I would think removing the old data would improve performance and reduce db size.    Or am I unaware of the tools to perform such maintenance?

Hi,Is there a way that I can see all the intersection errors for all lines rather than selecting one line at a time and seeing just that one constraint error?I've checked in Application Reports and can't find anything that helps.ThanksGuy

Any ideas what attributes this message might be referring to? There are no errors in the error log and the Task activity shows reconciliation discovery was completed, yet New = (0). Thank you for any leads in advance!  

I created a detail account dimension without creating a summary account dimension first.  When I attempt to create a summary account dimension now, I get an error message indicating the member already exists.  I tried to delete the detailed dimension and start over but there is already data saved.  How can I correct this?

Hello there,  can someone please share a sample transformation event handler code to map an unknown dimension member to a "placeholder" in the same dimension when validation step fails? Appreciate it!  

Hey Folks, I am looking to map all validation errors that might occur during an automated load to a placeholder member in the UD1 dimension, but i am running into issues as the mask rule approach is not working. Does anyone else have any other way to make this work? Below is what i have tried but i still get kickouts in the validation step of the load process.    

We have a client who wishes certain workflows (Input Child) to only be visible at specific periods during the year (6 and 12) The only way I could conceive of this based on my knowledge of OneStream to date is through managing security profiles somehow (Access Group) But everything I have seen indicates a very binary process, you have access or you don't.   

Hi allit seems that OS 8.4 notification settings by default only send emails to 50 users. Could this setting this changed / amended and if so in which part of the application?Thank you Nou

I'm fairly new to OneStream. I've a requirement where if ICP is P213 and irrespective of any source entity then target entity will be "Chicago" and if Source entity is "E123" then target entity will be "New York". The problem which I'm facing is that I do have "E123" in source file where it only takes the mapping of "E123"->"New York". It doesn't even see if the ICP is P213.

Has anyone come across a bug that causes S4 HANA - URL drill-back to get truncated on execution? We are calling a remote URL that opens the Fiori app.  The actual URL gets cut off from the # sign from the OS Drill-back in the browser. Simple code in use - The drillback code is:drillBackInfo.DisplayType = ConnectorDrillBackDisplayTypes.WebUrlPopOutDefaultBrowser.OneStream Support reported this as a bug in the solution.  Any thoughts?

Hello, Has anyone had this error message "No valid DataKeys (Scenario/Time) found in data source".  I received this message when importing a "text" file through the workflow.  Once import is selected and is at 94% complete prior to validation.   I have checked on Scenario & Time to make sure it is proper.  I need help on how to fix this.   

Hello,Is there any way to leverage a Dashboard Extender rule to set Workflow POV items? I previously had made a post by doing this in the new SmartLinks rule, but I was able to find a way to avoid using that. When my dashboard gets loaded, an extender rule executes, I want to run a subfunction that updates their workflow profile, scenario and year.Is this possible?

Hi all, We have Excel file that we upload into Cube (some tabs from this Excel file). This file also contains additional tabs that we want to upload into stage only and create cube views based on numbers on these additional tabs. Could you please advise where I can find instructions how to create, upload, perform mappings (if necessary), aggregate stage data and create cube views based on stage data.  

Our team submits topside entries in OneStream using the Adj channel. Upon a journal reaching "Submitted" status, I want our application to send an email notification to the approver that the journal is ready for review. We already have email notifications up and running for our application. I would like to have the email distributed based on a security group we have, CorpAdjApprover. Any ideas on how I can set this up? Would it go through an Event Handler business rule? Thanks in advance.

Hi I have created a workflow and need to assign entities however they are not showing up on the list. The only one which is showing up is NoneWhat could be the reason for this?  Regards

Just a heads-up for anyone using the REST API - this may save you some head-scratching!GetAdoDataSetForAdapter (5.2.0/Synchronous) and non-Default WorkspacesThere appears to be a problem with running GetAdoDataSetForAdapter if your DataAdapter is not in the Default Workspace. The Data Adapter returns an HTTP/200 in PostMan BUT the Response Body is null.It appears that the WorkspaceName parameter in the RequestBody has not yet been implemented in the RESTAPI.The RESTAPI documentation still referes to this parameter as being "reserved for future use" (but I assumed that this was a documetation bug as non-Default Workspaces have been out for a while in 7.4/8)API Version 7.2.0 and WorkspacesIn the Asynchronous APIs (7.2.0), there seems to be no way to specify the Workspace when you are generating the Application Session Token (SI), so you get the same problem with Data Adapters not in the Default Workspace.I proved this by moving my Data Adapters to the Default Workspace at which poin

Hello Everyone,I was wondering if anyone has experienced and resolved the issue I am finding. I am working on an excel workbook that has tabs corresponding to each workflow step consisting of various forms.  These forms have parameter requirements. The request is to have the parameter dropdowns on each excel tab. The issue I am having is some of these form tabs have the same parameters. I am met with the popup, this parameter already exists when trying to introduce it a second time on a different tab.  I know you can set one parameter to work across the entire workbook however that is not what my client wants.  The only way around this that I have found so far is to make multiple copies of parameters within the Application however I would rather not have multiple parameters that are the exact same. The other option is to have a separate excel workbook for each Workflow task.I find even setting the parameter to be used across the entire workbook to be a bit clunky.Thanks