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

CarlosAlvear's avatar
CarlosAlvear
Contributor II
2 years ago
Solved

Define and Edit Text for IC members

Dear all, I'd like to know how do you define a particular text for an IC member. I thought that once you define a text for an entity having a IsIC = True will transfer that information automaticall...
Metadata
  • JackLacava's avatar
    JackLacava
    2 years ago

    My bad, I got confused with something else.

    I think this warrants a quick member list. Amend values of dimensionName and entityFilter as necessary:

    ' in a Finance BR
Case Is = FinanceFunctionType.MemberList
  If args.MemberListArgs.MemberListName.XFEqualsIgnoreCase("withText1") Then
	Dim dimensionName as String = "CorpEntities"
	Dim entityFilter as String = "E#Root.Base.Where(Text1 <> '')"
	Dim ICs As New List(Of Member)
	Dim entities As List(Of MemberInfo) = brapi.Finance.Members.GetMembersUsingFilter(si, _
			brapi.Finance.Dim.GetDimPk(si, dimensionName), _
			entityFilter, _
			True)
	For Each entityMInfo As MemberInfo In entities
		ICs.Add(brapi.Finance.Members.GetMember(si, dimtypeId.IC, entityMInfo.Member.Name))
	Next
	Return New MemberList(New MemberListHeader("withText1"), ICs)

     

CarlosAlvear's avatar
CarlosAlvear
Contributor II
2 years ago

Hi Steven,

The original need is to use a MF for IC, for instance "I#ICEntities.Children.Where(Text2 Contains XXX)".

Thank you!

JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
2 years ago

Should be doable by referencing entities. Not tested but this should work: I#ICEntities.List(E#YourRoot.Children.Where(Text2 Contains XXX))