What could be a reason for a Save button in a workflow to be triggered several times after save?
For some reason, the workflow save event is being called several times. I have this configured right (I believe): Dim returnValue As Object = args.DefaultReturnValue args.UseReturnValueFromBusinessRule = False args.Cancel = False Case Is = BREventOperationType.Workflow.UpdateWorkflowStatus Dim sWorkflowImpactMessage As String = args.Inputs(3) 'Example: 'Reason = Save Data Cells 'Data Entry Type = CubeView 'Cube View Or Filename = NameOfCube 'Data Entry Audit ID = 0d6e8f60-de0f-4ab3-ba69-2f28a0d2 'Task Activity ID = 00000000-0000-0000-0000-000000000000 If ( sWorkflowImpactMessage.Contains("Reason = Save Data Cells") ) Then If (args.IsBeforeEvent = False) And (sDataEntryType = "CubeView") Then Here is my code - If I print a message, I see it several times. Thanks Raf100Views0likes2Commentsloading sub-ledger data into OneStream
Hi Community :) We are currently in development with regard to loading sub-ledger data into OneStream, but the balance specifications are so granular that we currently have them split into about 10 distinct loads. Because of this setup, our end users are being forced to manually click "Load and Transform" 10+ times to get a complete sub-ledger balance loaded for the period. Obviously, this is tedious, creates a poor user experience, and introduces a lot of room for human error. We want to streamline this. What is best practice to do this?69Views0likes2Commentsloading from ERP
Hi Community :) We are currently in development with regard to loading sub-ledger data into OneStream, but the balance specifications are so granular that we currently have them split into about 10 distinct loads. Because of this setup, our end users are being forced to manually click "Load and Transform" 10+ times to get a complete sub-ledger balance loaded for the period. Obviously, this is tedious, creates a poor user experience, and introduces a lot of room for human error. We want to streamline this. What is best practice to do this?21Views0likes0CommentsSequence not performing appropriately in WF
Hello, I have Product and Customer allocations that I would like to be ran on the process step of the Workflow. The weird challenge that I am running into is that when I run each step of the sequence on its own, the allocations are executing as expected. When I run all of the allocations with one sequence/in the Workflow, my allocations are producing errant results. (E.g. my allocated-in amount in is only a small fraction of my allocated-out amount.) Is there a property I am missing on a sequence or workflow that may cause problems if not handled appropriately? I am calling the sequence with a No Calculate in the WF, which executes a handful of Finance BR Calcs.SolvedScheduled tasks not running
Hi, I have 12 separate schedule tasks that is set to run monthly on calendar days 1-15. It runs every 2 hours starting from 12AM. (Next is 2AM, 4AM, and so on) I am encountering inconsistent issues with 6PM and 12AM where it does not kick off at all on random days. I've checked the configurations and can confirm it is set up right. Any idea what's causing the inconsistent failure to run? I'm in central time if that helps.66Views0likes2CommentsHow to "Import" "in parallel" via a "OneStream Connector" to a "Data Warehouse"?
Please share your practical advice to help us meet the new Integration requirements. - I couldn't find a OneStream KB/post nor a good result from free Gemini. - We're using SAAS on v9.0 to move to v10 upon its upcoming release. Thank you folks for sharing your expertise.85Views1like2CommentsIncluding Journal Entries from Different Origin Member in Account Reconciliation Discovery
Hi Community, I’m working on an Account Reconciliation solution where I need to ensure posted journal entries balances are also included in the Account Reconciliation discovery process. Currently, by design the Discovery process only pulls trial balance information already imported and validated in the Stage. Therefore, I wanted to check if there’s a recommended, or best practice approach, to accomplish this requirement. Any guidance or examples would be greatly appreciated, thanks in advance for your help!115Views1like3CommentsErrors creating New Task in Data Import Schedule Manager
I am getting several errors when setting up a New Task in the Data Import Schedule Manager. We are on OS version 9.01.17403, and I have installed the latest version of DSM, which is 8.4.0_SV100. I suspect this may be a version compatibility issue, so I am curious if anyone has been able to get this solution to work in a 9.01 application. I have already uninstalled and reinstalled the solution, which didn’t resolve the issues. Below are the two errors I am seeing: When choosing Global Scenario from the Scenario(s) drop down list, I get an immediate error “Error processing member. The item was not found. Member, 11111111.” The details state: Unable to execute Business Rule ‘DSM_Paramhelper’ where it appears to be trying to call the Global Scenario by OneStream.Client.Api.DashboardsAjaxServiceReference.DashboardsAjaxServiceClient.GetParameterDisplayInfosUsingDashboardNameCompressed(SessionInfo si, LoadDashboardInfo loadDashboardInfo, Boolean isForDashboardUIWithInteractiveComponents, Dictionary`2 custSubstVarsAlreadyResolved). If I pick a specific Scenario, I am getting a different error. It allows me to pick the Scenario and Time, but when save the Task, I get “The input string ‘’ was not in a correct format.”. The error details show it is an issue with the same Business Rule ‘DSM_SolutionHelper’ where Conversion from string “” to type ‘Double’ is not valid. The input string ‘’ was not in a correct format. OneStream.Client.Api.DashboardsAjaxServiceReference.DashboardsAjaxServiceClient.StartExecuteSelectionChangedServerTaskCompressed(SessionInfo si, Boolean isSystemLevel, Guid primaryDashboardID, Guid embeddedDashboardID, Guid componentID, PageInstanceInfo pageInstanceInfo, XFSelectionChangedServerTaskInfo serverTaskInfo) Any advice on how to correct these issues would be greatly appreciated.Solved103Views1like1CommentExport data using a Method Query
Hi I have a method query that returns a data table of roughly 300k of records. Is there anyway to export the result of the method query to a csv file? I'm not keen on using a spreadsheet business rule or a grid view on a dashboard given the volume of records that is being returned. Thanks, MarkSolved1.7KViews1like5CommentsEncryptText And DecryptText Replacement
Does anyone know what replaces the 2 utility commands below? I get a warning message that those commands are obsolete but it does not give any indication or hints of what the new commands are or what's currently available? BrApi.Utilities.EncryptText andBrApi.Utilities.DecryptText Any help is highly appreciated. Thanks, JunSolved191Views0likes3Comments