Announcement
ABCRecent Activity
Maximizing Cube Utilization in OneStream Applications
3 MIN READ Cubes control how data is stored, calculated, translated and consolidated based on the Dimensions assigned to it. Cubes are flexible and can be designed for a specific purpose (HR or People Planning Cube, Budget/Sales/Cost Drivers Cube or even Tax Cube) or data type in a OneStream XF Application. Dimensional assignments can vary by Scenario Type. An application can have multiple Cubes that can share Dimensions and data Separate Cubes may be used to hold data outside of the main financial Cube.Community Highlights: January 2025
1 MIN READ Happy February! Time flies! Just like that it's mid-February and that darn groundhog saw his shadow. While we may want to count the days until Springtime, we can't forget that January saw a lot of new faces and new discussions in our Community. It was also our first full month with the new design of the Community. We'd love to hear from you -- have you been enjoying the facelift Community received? Are there any features you love or hate? Comment below! Here's what we saw in January 2025: The Community had 28,099 visits in January 2025 and 90,609 page views We had 106 new discussions begin Reporting was our most active forum, with 33 new discussions Top Engaged Threads: Most Replies: BR Rule - BR api Error log Most Views: Primary and secondary axis align 0 point Most Active Members: Most Forum Replies: T_Kress Most Likes Received: sameburn Most Authored Solutions: MarcusH
Dynamic Member addition in version 9
We are looking for some help in direction to build dynamic member addition to a dimension using extensible business rule in version 9.0 We have tried to use the code that is used in earlier versions which uses declaration like "Dim newMember As New Member" but it does not work anymore in version 9 as it gives error when assigning values to newMember.Name property and some search suggests that we now need to use "Dim newMember As New MemberEx" Using this declaration results in error compiling the business rule. We are looking for some help/direction on this.
Exporting Account Type
I'm currently trying to export the account dimension members and their properties through a csv file. I can get all the properties necessary, but I can't get the "Account Type" property through the extender rule. I'm currently using Account_Type= Brapi.Finance.Members.GetMemberInfo(si,dimTypeId,stkItem.Name,True,Nothing,MemberDisplay).Member.GetType.FullName , to get the account type in columns but it isn't returning the correct account type of the member and instead returning " OneStream.Shared.Common.Member " in the columns.
Assistance Needed: Updating "Profile Active" Property via Extender Rule
Dear Team, I am currently working on updating the "Profile Active" property for a specific scenario type within a workflow profile. I am trying to implement this change using the below code snippet, but am not seeing the desired result: code snippet: brapi.Workflow.Metadata.GetProfile(si, "Parent Profile.Profile Name").SetAttributeValue(ScenarioType.Control.Id, 1300, Boolean.TrueString) Though I am aware that this update can be performed manually by accessing individual workflow profiles or using the grid view, my requirement is to execute this task through an extender rule. I've identified that the attribute index for "Profile Active" is 1300 and the value to be updated is of an object type. I suspect there may be an issue with the way I'm passing the new value in the code. I would appreciate any guidance or insight on how to correctly update this property using the extender rule. Your assistance is greatly appreciated. Thanks
Returning a success or failure message from DM via REST API
Hi all, I'm triggering a DM job using the REST API. The job is running a business rule. I handle errors in the BR but I need to actually return the success or failure as a response to the postman request. Right now, I get a success message no matter what happens in the BR. Thanks in advance!
Use 2 fields to determine dimension value in datasource
Hi all, I need to set up a complex expression to assign a specific value to the U6 dimension based on 2 source fields. Below part of the list of those source fields. The code I set up for the complex expression is the following: Dim fields As List(Of String) = api.Parser.DelimitedParsedValues() Brapi.ErrorLog.LogMessage(si, "Field count (List.Count): " & fields.Count) If fields.Count > 4 Then Dim loadedAccount As String = fields(4) Brapi.ErrorLog.LogMessage(si, "loadedAccount: '" & loadedAccount & "'") If Left(loadedAccount, 2) = "00" Then Return Right(loadedAccount, 8) End If Else Brapi.ErrorLog.LogMessage(si, "WARNING: only " & fields.Count & " fields; skipping Account logic") End If Every time I launch the loading process, however, it prints the WARNING message for all the rows, as if it didn't find any source field. Am I doing something wrong / is there an alternative way to retrieve the fields values that I am not considering? Thank you for the help!
