Hi All,
I'm trying to build a schedule with nested row dimensions where level 3 member is based on level 1 member value.
Let's say I have TIME expansion in columns and three espansions in rows: RESOURCE, DOMAAIN, PROJECT.
RESOURCE dimension members have a custom property DOMAIN which should facilitate many-to-one relationships between members. For example, RESOURCE_A only has value on the intersection with member DOMAIN_A. There are several hundred resource and domain members so displaying memebrsets is not an option, moreover, determining the relationship based on names or ID-s is not so intuitive.
So basically I have the following Membersets in Evdre control panel:
EXPANSION 1 | EXPANSION 2 | EXPANISON 3 | EXPANSION 4 COL | ROW | ROW | ROW TIME | RESOURCE | PROJECT | DOMAAIN BAS; BAS; ="ID=P00 or ID="&I8; NOEXPAND
I was expecting that if I have row keys defined as follows, EVDRE would expand based on first two rowkey columns and repeat whatever is left in the last. I have similar schedules working but without formulas in rowkeys, just plain hard-coded id-s.
Rowkeys:
RESOURCE_A | P00 | =EVPRO(H2;K15;"PROPERTY_1") RESOURCE_A | P01 | =EVPRO(H2;K15;"PROPERTY_1") RESOURCE_B | P00 | =EVPRO(H2;K15;"PROPERTY_1") RESOURCE_B | P01 | =EVPRO(H2;K15;"PROPERTY_1")
Any suggestions or alternative solutions welcome.
Many Thanks,
MU