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)Solved95Views0likes8CommentsReport Scripts
Hi all, I'm trying to figure out how to leverage on Report Scripts using OneStream objects. Is it possible to leverage on BRApi inside scripts events ? A direct call to BRApi class results in an error, I'm wondering if there's some workaround or trick to reach the object. Best Regards FabioG21Views0likes2CommentsData Audit Dashboard
Hi All, I am trying to create a dashboard to extract the data for the given point of intersection basically I have given all the dimension parameter for the user to select and click on the button download that runs the DataManagement job and will extract the data for the selected POV . I am able to achieve the above requirement just like an enhancement I want to also get the data of the user details who has loaded data into those point of intersection. Can some one help me with the lead how can I achieve the above user details that would be really great. Thank You8Views0likes0CommentsApplication Logo in Report (and Scripts)
Hi all, I'm building a Report Component from scratch, but I'm not able to put the Application's Logo (defined in Application Properties / Logo File) in its header. I can add an Image control, but I must fill it with a file (or URL), looks like I cannot bind the control to the Application's logo (and IMHO this would be really helpful) I also tried to look at Report's Scripts, I see a lot of events, but I cannot find documentation to use them (maybe there's something I can do through them, to grab image from Application Properties, injecting it into the component) Just wondering if there's something I could do... Any help would be really appreciated20Views0likes0CommentsMissing OneStream shortcut icon
Has anyone experienced after creating a shortcut that the OneStream icon is missing from the shortcut? If so, does anyone know how to resolve this issue? I know I can create my own icon and map to it, but I would think that this should be there. Thank you19Views0likes1CommentCube View Group - Forms
Hi, I'm trying to figure out how can I make few rows as un editable. Example: highlighted rows in below screenshot. I remember this can be done through Row overrides but its not working. In column member filter, I defined two dimensions as below. What should I define in Row override to have 'Total Revenues', 'Total Expense' and 'Personal' rows un editable?45Views0likes7CommentsCube View
Hi, I'm trying to create a form with set of accounts in rows and column should be for adding the adjustments. Here, I do not required to pull any data from the cube. Instead I have to update the adjustments based on the scenario selected. This should be a separate form where the adjustments data should not update the existing forecast data. POV: Parameters in POV are defined to pull the accounts accordingly. Rows: Columns: Issue: I couldn't get the form with editable fields. refer screenshot below. FYI: Can Modify data for Column is set to 'True'85Views0likes14CommentsExport Data of Selected Parameter
Hi All, I am trying to create the dashboard where I pass all dimension from combo box to button taht triggers the DM sequence that has the Export Data step. I get the following error mentioned below. FYI please see the screenshot of the export data step mentioned below. Can someone please help where I am going wrong please help me with the approach. Thank you47Views0likes6Comments