I recently posted a question on the forums in relation to a workaround for a bug in the LOOKUP formula. I wholeheartedly feel like the LOOKUP bug (where it doesn't work for parent items that are in the same list as the leaf-level members) should be fixed. And I recognize that there are some workarounds available (as identified by the responses to my forum post). However, I stumbled upon something that I think would be helpful as an option in the system.
I think we ought to have the ability to have data that is not dimensioned by users, then have a rule that is dimensioned by users, and be able to sum the source data by that rule. This would allow us more flexibility in providing users views of data where thare are space limitations which prevent us from being able to dimension our output modules by all desired lists.
The content in this article has not been evaluated for all Anaplan implementations and may not be recommended for your specific situation.
Please consult your internal administrators prior to applying any of the ideas or steps in this article.