Announcement
ABC
Recent Activity
TransformationEventHandler - Adding new member to main and Alternate hierarchy
Is it possible to add members to both main and alternate hierarchies using EventHandler from source. Was not able to achieve using existing code. Below code is being used to add new members from source to the Flow dimension which works for main hierarchy but not adding under Alternate hierarchy, any help is appreciated. The new member needs to get added under both parents below Dim flowDimName As String = "Product_Attributes" Dim flowMF As String = "F#TopProductAttributes.Base" Dim flowLookup As Dictionary(Of String, MemberInfo) = Me.CreateMemberLookupUsingFilter(si, flowDimName, flowMF) Dim ExistflowLookup As List(Of MemberInfo) = BRApi.Finance.Metadata.GetMembersUsingFilter(si, flowDimName, flowMF, True) Dim flowAddedMembers As New Dictionary (Of String, String) 'Set the parent to add new FLOW Members under Dim tFlowColIndex As Integer = (objTransformer.TransformerDimensions(StageConstants.MasterDimensionNames.Flow).DataTableColumnIndex) + StageConstants.TransformationColumnIncrements.Target '****************Start adding new members********************************************* 'Loop over all pages in the cache If objTransformer.DataCache.Pages.Count > 0 Then 'Move to the first page objTransformer.DataCache.MoveFirstPage(si) 'BRAPI.ErrorLog.LogMessage(si,"Add member Yes: Line 223") 'Process All pages in the data cache For intPageNo As Integer = 0 To objTransformer.DataCache.Pages.Count - 1 'Set the current data page objTransformer.DataCache.ActivatePage(si, intPageNo) 'Process each row in the data table on this page for each dimension we are checking For Each row As DataRow In objTransformer.DataCache.CurrentPage.PageDataTable.Rows ' BRApi.ErrorLog.LogMessage(si, "Line 123") 'Check the target Flow Value Dim targetFlow As String = row(tFlowColIndex) Dim flowDesc As String = "" '*** Product Attribute Description *** Dim flowMember As String = row(tFlowColIndex) 'Determine Flow Parent member Dim flowParent As String = "NA_RELEASE_STATUS" 'Determine Flow Parent member Dim flowParent As String = "NA_RELEASE_STATUS" If (Not row(tFlowColIndex) Is Nothing) Then If flowMember.XFContainsIgnoreCase("NOT_RELEASED~AUTOMOTIVE") Or flowMember.XFContainsIgnoreCase("NOTRELEASED~AUTOMOTIVE") Then flowParent = "NOT_RELEASED" ElseIF flowMember.XFContainsIgnoreCase("NOT_RELEASED~AUTOMOTIVE") Or flowMember.XFContainsIgnoreCase("NOT_RELEASED~AUTOMOTIVE") Then flowParent = "AUTOMOTIVE" End If End If
Silence the Slack, Master the Stack: Deep Learning Through Instructor-Led Training
2 MIN READ We all know it can be a challenge to fit training into your busy daily routine. Between back-to-back meetings, chat messages from co-workers, and the long list of tasks that are due by the end of the week. For some learners, this is where on-demand training proves particularly helpful. You can fit it into your schedule when you have free time. But what do you do if you never get that coveted free time? This is where instructor-led training takes center stage. Block off your calendar (with permission from your boss, of course), mute the chats, and focus on LIVE learning. Attending a live training course with expert instructors allows you to devote your undivided attention to taking that next step in your OneStream journey. OneStream instructor-led training provides you with the ability to ask clarifying questions and get immediate answers and feedback. It allows you to gain exposure to how other users in the same (or differing) industries use OneStream. For example, you might participate in a live troubleshooting session or collaborate on case studies with peers from other industries. And best of all, it allows you, as the learner, to be more engaged due to the scheduled class time, group discussions, and real-time interaction with the instructor. If you are new to OneStream or are looking to deepen your knowledge, consider learning in a way that allows you to be fully immersed for a few days and stay present. Earn a micro-credential badge (a few examples below) to post on LinkedIn and CPE credits, too. Now through the end of 2025, we are offering special savings! Save 15% on PUBLIC INSTRUCTOR-LED TRAINING classes with the coupon code: ILT15%EXCLUSIVE Enjoy a 50% discount on the OneStream Certified Associates (OCA) - Administration R2 Exam or the OneStream Certified Specialist (OCS) - Reports & Dashboards Exam. To redeem, open a GES ServiceNow ticket with the Credentialing team. Note: This offer cannot be combined with other discounts. The coupon is only valid through December 31, 2025. Enrollment must be completed before the listed expiration date, but the class can be scheduled for Q1 2026. Exams must be taken by December 31, 2025. Check out our instructor-led training calendar in OneStream Navigator! Sign in to Navigator and select Instructor-Led Training at the top of your dashboard: Search for the course of your choice either by typing in the name or using a filter: You will see the location if the event is in-person, or it will be indicated if the course is live-virtual. You will also see the date of the first day of training and the start time, adjusted for your current time zone. Click View Details to start the registration process. Questions? Comment below! Or reach out to us anytime via a GES (Global Education Services) ServiceNow support case. We look forward to seeing you in the classroom soon!Pre-Order Today: OneStream Security Essentials
1 MIN READ Coming October 14, OneStream Press is proud to announce the debut of our first ever mini book: OneStream Security Essentials. This OneStream mini-book offers practical guidance, analogies, and in-depth information to help you design, test, and maintain a robust security model. Whether your company is small, large, public, or private, this book delivers the background and tools to meet your company’s unique security and data requirements. Protecting your OneStream investment and data – while making your end-user experience optimal – is fundamental to getting the most out of OneStream. Pre-Order Today OneStream Security Essentials, written by Teresa Kress 📅 Launching October 14 📚 Explore our full lineup: onestreampress.comErrors 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.OneStream Certified Associate (OCA) - Administration Exam
1 MIN READ Does your OneStream Administrator know how to modify security settings and application properties? Expertise in managing security settings and application properties is crucial. Validate these skills and proficiencies with the Administration R2 certification exam! Prepare with these key learning resources: Course: OneStream Administration Course: Getting Started with OneStream Course: Configuring Core Application Security Webinar Series: Administration R2 Exam Prep on OneStream Navigator Empower your Administrators with the knowledge required to maximize your OneStream implementation! Work with them to support them in their certification journey! Visit the Certification website today to learn more about the OCA – Administration exam and other certification opportunities.
Books to PDF - Multiple Entities
Hi All, I'm having a hard time running a book that creates a pdf by entity in an automated fashion. I've created a book with a loop calling a file which is a book of cube views. Running that book individually works well. When running the book that contains the loop, it works fine when saved as a .pdfbook but the problem I run into is that it times out due to processing time when I try to run it for multiple entities. The book is about 80 pages or cube views. So I created a .zipbook version of the same book with said loop to run it from Data Management in the background. The problem I'm now running into is running the .zipbook version creates 80 pages of blank reports rather than the data I saw in the .pdfbook. If anyone has any suggestions, I'll take them. Thanks!
Tech Talks: Migrating Finance Business Rules to Assemblies replay now available!
1 MIN READ On this episode of Tech Talks, Terry Ledet joins Tom Linton and Matt Kerslake to demonstrate the process and steps involved with migrating legacy Finance Business Rules into Assemblies while answering common questions along the way! This replay is available here until 10/17/25 so be sure to watch now. You can also watch this replay at anytime on Navigator as part of your Passport subscription. Tech Talks: Migrating Finance Business Rules to Assemblies
