The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Specifying SiblingSortOrder while adding relationship through extensibility rule
Hello,
Can we figure out sibling sort order for existing members and add the new members at a specific position in hierarchy through extensibility rule?
Any samples would be helpful.
Dim relationshipPositionOptions As New RelationshipPositionOptions
relationshipPositionOptions.SiblingId = sSiblingID
relationshipPositionOptions.MovementType = RelationshipMovementType.InsertBeforeSibling
BRApi.Finance.MemberAdmin.SaveRelationshipInfo(si, relationshipInfo, relationshipPositionOptions)Specifying movementtype worked.
No assistance needed.
Hello,
I tried to move a account from one position to another position within same parent group.
Tried to modify using the codes above but no luck. Below is my code and any help will be appreciated.
'Try to move Myaccountname position to before SiblingName
Dim parentMem As MemberInfo = BRApi.Finance.Metadata.GetMember(si, DimType.Account.Id, "ParentName")
Dim siblingMem As MemberInfo = BRApi.Finance.Metadata.GetMember(si, DimType.Account.Id, "SiblingName")
Dim myMember As MemberInfo = BRApi.Finance.Metadata.GetMember(si, DimType.Account.Id, "MyAccountName")
'Relationship
Dim relationshipInfo As New RelationshipInfo
Dim relationship As New Relationship
Dim relationshipPK As New RelationshipPk
relationshipPK.ParentId = parentMem.Member.MemberId
relationshipPK.ChildId = myMem.Member.MemberId
relationship.RelationshipPk = relationshipPK
relationshipInfo.Relationship = relationship
Dim relationshipPositionOptions As New RelationshipPositionOptions
relationshipPositionOptions.SiblingId = siblingMem.Member.MemberId
relationshipPositionOptions.MovementType = RelationshipMovementType.InsertBeforeSibling
BRApi.Finance.MemberAdmin.SaveRelationshipInfo(si, relationshipInfo, relationshipPositionOptions)
Thank you!