Announcement
ABCRecent Activity
Fetching text property by time
Hi, I'm trying to display a time-variant text property of the UD1 dimension member in a report. The challenge is that the text value can exist in any period of the member, so I currently loop through the forecast periods (spanning two years) to retrieve the values. While the code works, its performance is not good. Is there a way to fetch or look up the text properties by time (possibly from a specific table) without iterating through all periods? Any command or optimized approach to achieve this efficiently would be highly appreciated. Dim Date As String = $"{year}M{month}" Dim timeID As Integer = timedimhelper.getidfromname("Date") Dim myVaryByTimeId As Integer = BRApi.Finance.Members.GetMemberId(si,DimType.Time.Id, Date) Dim mbrText As String = BRApi.Finance.UD.Text(si, 9, mbrId, 1, -1, myVaryByTimeId)
Consolidated Annotations
Hi. Is it possible to make annotations in the UD1 dimension and have them roll up to the respective legal entity (at consolidated level)? A challenge I'm facing is that only specific base members under the UD1 dimension reference the legal entity in the text field. How can I manage this so that only the relevant regions (that reference legal entities) contribute to the commentary at the consolidated level?
Member Dimension correction
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?
Extracting entity hierarchy without constraints
Hi! Is there a way to extract the entity structure without constraints? In the current entity structure, every entity has a different UD1 constraint, but I need this to be set to Root for all entities when loading it in the other application. I know in Notepad++ you can use find/replace to modify this, but because every entity has a different UD1 constraint, it is still quite a manual process. Wondering if there is a more efficient way. Thanks in advance!
How can I wrap V#Annotation text in a column?
Hi all! How can I wrap V#Annotation text in a column? Right now the reporting is not the most user friendly so we're wondering how to show it better. It looks like there were some suggestions from three years (Maximum characters for Annotation | OneStream Community) ago but wondering if we've made any progress on this issue since then :) Thank you! -Nicole
