Rule error

Post Reply
ryan
Posts: 59
Joined: Thu May 26, 2011 5:04 am
OLAP Product: COGNOS
Version: 9.0
Excel Version: 2007

Rule error

Post by ryan »

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.
Configuration Details
Microsoft Window Server 2003 Exterprise x64 Edition Service Pack 2
RAM 32 GB
using IBM Cognos Express Xcelerator (Version 10.1)
MS-Office Excel 2010 (12.0.6514.5000)SP2 MSO (12.0.6425.1000)
Microsoft .NET Framework 3.5
User avatar
Michel Zijlema
Site Admin
Posts: 713
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: Rule error

Post by Michel Zijlema »

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
ryan
Posts: 59
Joined: Thu May 26, 2011 5:04 am
OLAP Product: COGNOS
Version: 9.0
Excel Version: 2007

Re: Rule error

Post by ryan »

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.
Configuration Details
Microsoft Window Server 2003 Exterprise x64 Edition Service Pack 2
RAM 32 GB
using IBM Cognos Express Xcelerator (Version 10.1)
MS-Office Excel 2010 (12.0.6514.5000)SP2 MSO (12.0.6425.1000)
Microsoft .NET Framework 3.5
Post Reply