TM1 Forum

I have a cube named: BV_Allocations which contains the following dimensions
Version (Actual, Budget,SuperFlash)
SF_InterlineFlag (NO,YES)
SF_BorneFlag (NO,YES)
SF_ContainerSize
SF_ContainerType
SF_Direction
SF_Account(ContainerCount)
SF_Service
SF_OriginRegion
SF_DestinationRegion
Period(201201,201202,...)
SF_Vyoge(BudgetedVoyage)
SF_Measure(TEU)

I have another cube named: BV_RegionTEUSplit which contains the following dimensions
Version(Budget)
SF_ContainerSize
SF_ContainerType
SF_Service
SF_OriginRegion
SF_DestinationRegion
Period
SF_tEUSplit_Measures(TEUSplit_Calc,TEUSplit_OverWrite,TEUSplit_Final)

My rule @ BV_RegionTEUSplit cube is as follows:
['Budget','TEUCount']=N:
DB('BV_Allocations','Budget','NO','YES',!SF_ContainerSize,!SF_ContainerType,!SF_Direction,'ContainerCount',!SF_Service,!SF_OriginRegion, !SF_DestinationRegion,!Period,'BudgetedVoyage','TEU');

and I would like to write external feeder for the above rule in BV_Allocations cube as:

1) ['Budget','ContainerCount','TEU']=>
DB('BV_RegTEUSplit','Budget',!SF_ContainerSize,!SF_ContainerType,!SF_Direction,!SF_Service,!SF_OriginRegion,!SF_DestinationRegion,!Period,'TEUCount');
Result: Giving me error as SF_Direction is not part of BV_RegTEUSplit cube.

2) ['Budget','ContainerCount','TEU']=>
DB('BV_RegTEUSplit','Budget',!SF_ContainerSize,!SF_ContainerType,!SF_Service,!SF_OriginRegion,!SF_DestinationRegion,!Period,'TEUCount');
Note: omitted using !SF_Direction, since it is not part of BV_RegTEUSplit cube.
Result: I can see the values with out using 'supress zero' feature. But when I use 'Supress Zero' feature I am unable to see the values

3) ['Budget','ContainerCount','TEU']=>
DB('BV_RegTEUSplit','Budget',!SF_ContainerSize,!SF_ContainerType,'EveryDirection',!SF_Service,!SF_OriginRegion,!SF_DestinationRegion,!Period,'TEUCount');
Note: I am using the consolidated element instead of omitting the dimension name.
Result: Now server is hanging.

Can any one help me in resolving this issue.

What should be considered when the dimension is not part of the cube while writing feeders/external feeders.


But I am getting error saying that syntax error on or before. Can anyone help me in correcting this? Should I enhance the rule part or feeder part?

Thanks in advance.

The right-hand side (RHS) of the feeder has to match the target cube. If there are dimensions in the source cube which aren't in the target cube, you need to pick one element from each un-represented dimension and include it on the left-hand side (LHS). Conversely (you've already done this right), if there are any dimensions present in your target that don't exist in your source, you need to call them out on the RHS (as you did with 'TEUCount'). Here's your source cube and the dims present and missing from the target:

Version (Actual, Budget,SuperFlash): present in target (OK to further filter as you have)
SF_InterlineFlag (NO,YES): need to add to LHS
SF_BorneFlag (NO,YES): need to add to LHS
SF_ContainerSize: present in target
SF_ContainerType: present in target
SF_Direction: need to add (your original question)
SF_Account(ContainerCount): need to add to LHS
SF_Service: present in target
SF_OriginRegion: present in target
SF_DestinationRegion: present in target
Period(201201,201202,...): present in target
SF_Vyoge(BudgetedVoyage): need to add to LHS
SF_Measure(TEU): need to add to LHS (appears you already did)

There are six dimensions in your source not present in your target, so you need to have six elements on the LHS of your feeder. Also, I would specifically identify the dimension with each element to avoid future rule ambiguity if you ever have two identically-named elements in different dimensions. IMHO, this shortcut is a bad idea and never should have been allowed in TM1. e.g.

['Version':'Budget','SF_InterlineFlag':'xxx','SF_BorneFlag':'xxx','SF_Direction':'EveryDirection','SF_Account':'xxx','SF_Vyoge':'xxx','SF_Measure':'TEU']=>
DB('BV_RegTEUSplit',!Version,!SF_ContainerSize,!SF_ContainerType,!SF_Service,!SF_OriginRegion,!SF_DestinationRegion,!Period,'TEUCount');

Matt