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