Skip to Content
0
Former Member
Dec 03, 2009 at 01:30 PM

Conditional row keys in EVDRE

40 Views

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