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 feeder for the above rule in BV_Allocations cube as:

['Budget','TEU']=>
DB('BV_RegTEUSplit','Budget',!SF_ContainerSize,!SF_ContainerType,!SF_Direction,!SF_Service,!SF_OriginRegion,!SF_DestinationRegion,!Period,'TEUCount');

But I am getting error saying that syntax error on or before. Can anyone help me in correcting this.

After a quick check I see that you're referring to the dimension SF_Direction as a variabe in both your rule and your feeder. This dimension is however not part of the BV_RegionTEUSplit cube, so this reference is not valid in both the rule and the feeder.

Michel

Michel Zijlema wrote:After a quick check I see that you're referring to the dimension SF_Direction as a variabe in both your rule and your feeder. This dimension is however not part of the BV_RegionTEUSplit cube, so this reference is not valid in both the rule and the feeder.

Michel

Thank you a lot, Michel.