TM1 Forum

Thanks lotsaram!
I thought about 1) but that would be difficult to maintain since the hierarchies can't be based on dynamic subsets or can they? 2) may be an option, but then again, I'm looking at both the maintenance and consolidation issues, I think...

I'm pretty new to TM1 and this problem has me stumped. Any help would be appreciated. 2 Cubes: Employee Stats and Costs. To somewhat simplify, Employee Stats has Employee, Month and EmpMeasures dimensions. Employee dimension has the OfficeID attribute and is arranged in a department hierarchy, the E...