Skip to Content
0
Former Member
Jan 10, 2012 at 07:12 AM

How to use property of dimension to filter the 2nd dimension in Allocation?

19 Views

Hi experts,

How do we use a property of one dimension to filter out the members of another dimension in allocation script engine?

eg of two dimensions

1.)Entity dimension - (entity dimension)

memberset: Channeltype (property)

Stores

Store1 Boutique

Store2 Kiosk

Store3 Branch

Store4 Concession

Store5 Franchise

Nonstore

2.)business Channel dimension - (user define)

memberset:

Channeltype

Boutique

Kiosk

Branch

Concession

Franchise

Nochannel

in allocation code

*runallocation

*factor

*dim entity what=Nonstore; where=bas(Stores)

*dim businesschannel what=nochannel; where= ? ;

*endallocation

The thing is that when the engine selected store 2 for entity it should select kiosk as its businesschannel.

Please advise.

Thanks as always,

yajepe