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
MarioGV
3 years agoNew Contributor III
Cube view using complex function Account
Hello; Im crating a cube view with 2 rows (maybe more) that one of them is a result of a complex function:
"A#INCOME_STATEMENT.Base.Where(Text1 Startswith On-Campus)" and shows several rows qualifi...
Omkareshwar
3 years agoContributor
You can write an XFBR Rule
Within that rule you can pull all the members in a list using this code
Dim Accounts As List(Of String) = BRApi.Finance.Metadata.GetMembersUsingFilter(si, "DimensionName","A#INCOME_STATEMENT.Base.Where(Text1 Startswith On-Campus)",True).Select(Function(c) c.Member.Name).ToList
This will pull aur your relevant accounts in a list then you can loop over that list create an empty string and append all you accounts in this format A#Account1 + A#Account2 and sooo on
then add that to the getdatacell and return in your cube view