Announcement
ABCRecent Activity
today's date to be populated as the default value
Hello, I am using a textbox to input a date, and its action property is linked to a parameter with the type set to "Input Type." When running the dashboard, the user wants today's date to be populated as the default value instead of manually entering a date. Has anyone tried using the Date function with the input parameter type for this purpose? thank you!
Security "Reset" When Prod is Copied to Dev
Is it normal for certain security settings to be "reset" when a copy of production is made to dev? Every time we make a copy of production into the development environment certain security fields within Security Roles, Entity dimension, Scenario dimension, Workflow Profiles and Data Management Groups are set to "(Not Found)" instead of the correct security group. Is this normal? If so, what's the easiest way to update this? Thanks!
Register Now for the January Edition of Tech Talks!
Registration is now open for the live January Tech Talks! On this edition of Tech Talks, Sam Eburn and Jérôme Marcq join Tom Linton and Matt Kerslake to demonstrate the power of no code Dynamic Dashboards on the OneStream platform. Learn how features such as Repeat Arguments and Template Parameters can be created without the need for complex code writing. https://www.onestream.com/events/tech-talks-no-code-dynamic-dashboards/Member formula to allocate bal sheet by UD
Hi experts, hoping someone can guide me. Our P&L is recorded by Line of Business (UD2), however our balance sheet is recorded to UD2 None. FPA has a requirement that they currently handle manually to "allocate" the balance sheet to the lines of business based on the percent of revenue. Our partner initially achieved getting closer by using a dynamic formula on UD8. This does not ultimately provide the accurate results at the consolidated level (due to nature of dynamic formula). We believe we need to change this to a formula pass but it is proving to be challenging. We are open to suggestions, using UD7 (tracking) or UD6 (reporting). I am also open to creating a mini alt acct hierarchy since it really only needs to apply for a handful of summary level accounts. (Coding examples would be so very appreciated!) Thank you!BR Rule - BR api Error log
Hello All, OS experts - Greetings ! I am trying to complete the following code to extract the year and month from a given date. To help with validation and debugging, I've enabled BRAPI.ErrorLog.LogMessage to display the variable outputs in the error log. However, for some reason, it is not displaying any values in the error log. I would greatly appreciate any insights into what might be wrong with the code. Here is the code I am working with: Dim vDate As String = args.NameValuePairs.XFGetValue("Date") ' e.g., "01/01/2025" (MM/DD/YYYY format) ' Log the retrieved Date for debugging BRAPI.ErrorLog.LogMessage(si, "vDate: " & vDate) ' Ensure vDate is not null or empty before proceeding If Not String.IsNullOrEmpty(vDate) Then ' Extract the year (last 4 characters) from vDate and convert to an integer Dim vYear As Integer = CInt(vDate.Substring(6, 4)) BRAPI.ErrorLog.LogMessage(si, "vYear: " & vYear) ' Extract the month (first 2 characters) from vDate and convert to an integer Dim vMonth As Integer = CInt(vDate.Substring(0, 2)) BRAPI.ErrorLog.LogMessage(si, "vMonth: " & vMonth) Else BRAPI.ErrorLog.LogMessage(si, "vDate is null or empty!") End If Thank you in advance.
