loading 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?
Managing Group Company Exits in the User Workflow View
Hello everyone, We have several companies that have been sold or dissolved. To simplify users’ work, we would like to stop displaying workflows for these entities for periods when they no longer exist within our group. I’m not sure if this is the recommended approach, so please feel free to share your best practices with me. For my part, I have several ideas: Revoke access to the workflowProfile of the relevant entities via the access permissions of the users responsible for importing the data. Use a Business Rule to retrieve the name of the entity linked to the user’s workflow and, using its Entity ID, retrieve the date the company left the group, which is stored in Text6. This way, I could either display no periods (meaning there would be no workflow), display all 12 periods, or display only the X months of the year the user was in the group. I can retrieve the ID of the entity assigned to the workflow, but I can’t retrieve the data in Text6. I get the error “Object reference not set to an instance of an object.” If args.MemberListArgs.MemberListName.XFEqualsIgnoreCase("IsFormValidForEntity") Then '-- Usage: T#Root.CustomMemberList(BRName=JR_MemberList, MemberListName=IsFormValidForEntity, CVName=[RLS010 Local - Compte de résultat]) 'T#|WFTime| Dim WfGUID As guid = si.WorkflowClusterPk.ProfileKey 'obtient la clé de profil du workflow actuel de l'utilisateur Dim EntityList As List(Of WorkflowProfileEntityInfo) = BRApi.Workflow.Metadata.GetProfileEntities(si, WfGUID) Dim entityId As Integer For Each eInfo As WorkflowProfileEntityInfo In EntityList api.LogMessage("Workflow Entity:" & eInfo.EntityName) entityId = BRApi.Finance.Members.GetMemberId(si, DimType.Entity.Id, eInfo.EntityName) api.LogMessage("entityId :" & entityId) Next Dim entityText6 As String = api.entity.Text(entityId,6).ToString '<-- Error Object reference not set to an instance of an object. api.LogMessage("entityText6 :" & entityText6) Do you have any advice on the best way to handle an entity’s departure from the group, while retaining or not retaining the ability to access its previous workflows? Sincerely,
CAMT.053 Files (ISO20022)
Has anyone imported CAMT.053 files from their bank into OneStream? We are embarking on an Account Reconciliation project and trying to accommodate our international sites. We've been told this is tricky and to stick with the BAI format, but that will be problematic as we integrate more global entities.
How 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.
Unable to Complete Workflow due to Security Access
Hello OneStream Community, I am running into an issue with the ability to complete a workflow with a dashboard button as a test security user. Any help would be greatly appreciated. I have a consolidation status dashboard, which is attached to the top-most workflow node for a given month. My issue is as a test end-user I keep receiving the following error message when attempting to complete the Workspace chevron and move on to the certify step of the workflow. The security settings for the workflow are very simple, so it's not clear what could be the issue here. Is there another way I could get around this?Cube Root Workflow Profile - Display Description
Hi Folks, I was wondering if there was a way to display a description for the Cube Root Workflow Profile in the dropdown menu. For example in my screenshot there is Corporate_MON and Corporate_WOR. I would like them to display: Corporate_MON - Monthly Forecast Workflows Corproate_WOR - Planning Workflows Note: I did try adding descriptions, they only seem to display for children of the main Cube Root Workflow ProfileConfirmation Rule detail
I created a new entity and workflow in OneStream. The metadata, workflow properties, and configuration are identical to existing workflows and entities. However, I noticed a difference in behavior: For the existing workflows, the confirmation rule displays results at the company level, even for entities with multiple child BUs. For the new workflow and entity, the same rule displays results at the BU level, showing multiple rows for each child BU. I have verified that the rule, meta data configuration, and workflow properties are the same.
