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.
Rule error
-
- Posts: 59
- Joined: Thu May 26, 2011 5:04 am
- OLAP Product: COGNOS
- Version: 9.0
- Excel Version: 2007
Rule error
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
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
- 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
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
-
- Posts: 59
- Joined: Thu May 26, 2011 5:04 am
- OLAP Product: COGNOS
- Version: 9.0
- Excel Version: 2007
Re: Rule error
Thank you a lot, 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
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
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