Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor II
5 years ago

How do you group base members without a new hierarchy?

Originally posted by Felipe Alcorta In our previous consolidation/reporting tool (Tm1/IBM), we always had the ability to group certain members together without having to create a hierarchy.  We cou...
Books
Cube View
OSAdmin's avatar
OSAdmin
Valued Contributor II
5 years ago
Originally posted by Ben Novak

populate the text# field of those base members with a common value and use the member expansion where(text_ contains ____). see example below where this will return all base branches that contain the word 'budget' in the text2 field property of each base branch member

 

u2#branches_all.base.where(text2 contains Budget)